Lowyat.NET: Latest topics by yoyorock

liferay..

yoyorock — Fri, 19 Feb 2010 21:42:58 +0800

hello everybody...i want to know how to make the email portlet for example yahoo mail.when login to liferay and add the yahoo mail portlet to the page then after logout the liferay and sign in again the yahoo mail already login..how to do that???sorry for the bad English..

liferay portal

yoyorock — Thu, 04 Feb 2010 23:45:25 +0800

hello..i want to know about liferay portal and how to use it..

-Sql Code-

yoyorock — Sun, 21 Jun 2009 08:56:09 +0800

"DELETE FROM pengguna,komputer WHERE komputer.pc_id=pengguna.id_pengguna AND no_pekerja='$no'"

This is my SQL code but i still get an error...

Php...

yoyorock — Tue, 02 Jun 2009 09:32:06 +0800

<?php
//set IE read from page only not read from cache
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header ("Cache-Control: no-cache, must-revalidate");
header ("Pragma: no-cache");

header("content-type: application/x-javascript; charset=tis-620");

$data=$_GET['data'];
$val=$_GET['val'];

//set database
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "inventory";
mysql_pconnect($dbhost,$dbuser,$dbpass) or die ("Unable to connect to MySQL server");

if ($data=='bahagian') { // first dropdown
echo "<select name='bahagian' onChange=\"dochange('unit', this.value)\">\n";
echo "<option value='0'>-</option>\n";
$result=mysql_db_query($dbname,"select id, bahagian from bahagian order by bahagian");
while(list($id, $name)=mysql_fetch_array($result)){
echo "<option value=\"$id\" >$name</option> \n" ;
}
} else if ($data=='unit') { // second dropdown
echo "<select name='unit' >\n";
echo "<option value='0'>-</option>\n";
$result=mysql_db_query($dbname,"SELECT id,unit FROM unit WHERE id_bahagian = $val ORDER BY unit ");
while(list($id, $name)=mysql_fetch_array($result)){
echo "<option value=\"$id\" >$name</option> \n" ;
}
}
echo "</select>\n";
?>

hello...this is my code..when i submit, it will take the value of id into the database...so,how to store the name into the database...how to get the value of text...

javascript...auto select..

yoyorock — Sun, 31 May 2009 08:15:26 +0800

<select size="3" id="brand" onChange="auto_select()">
</select> |
<select size="5" id="model" style="width:150px">
</select>
<script language="javascript">
alert(navigator.appName);
var arr = new Array();
arr[0] = new Array("HP","HP1234","HPDV5228TX","HPDV2001TX");
arr[1] = new Array("ASUS","A8H","F3S");
arr[2] = new Array("Acer","Aspire4530","Aspire4935","Aspire3810T","TravelMate6493");
var IE = false;
var FF = false;
if (navigator.appName.indexOf("Microsoft") == 0) {
IE = true;
} else if (navigator.appName.indexOf("Netscape") == 0) {
FF = true;
}
function auto_select() {
while(document.getElementById("model").length > 0) {
document.getElementById("model").remove(0);
}
var si = document.getElementById("brand").selectedIndex;
if (FF) {
for (i = 1; i < arr[si].length; i++) {
document.getElementById("model").add(new Option(arr[si][i],arr[si][i]),null);
}
} else {
var newOption;
for (i = 0; i < arr[si].length; i++) {
newOption = document.createElement("option");
newOption.text = newOption.value = arr[si][i];
document.getElementById("model").add(newOption);
}
}
}
function initial() {
if (FF) {
for (i = 0; i < arr.length; i++) {
document.getElementById("brand").add(new Option(arr[i][0],arr[i][0]),null);
}
} else {
var newOption;
for (i = 0; i < arr.length; i++) {
newOption = document.createElement("option");
newOption.text = newOption.value = arr[i][0];
document.getElementById("brand").add(newOption);
}
}
document.getElementById("brand").options[0].selected = true;
}
initial();
auto_select();
</script>

In this examples,if the user enter the brand,it automatically display the model...so,how to do if when the model already automatically loaded,another field also automatically select according to model..for examples when we select the brand,it will be display the model and after that it will display the spec of the model...

Query...

yoyorock — Wed, 27 May 2009 12:04:46 +0800

$query='SELECT * FROM pengguna,komputer WHERE pengguna.id_pengguna=komputer.pc_id AND komputer.pc_id=pengguna.id_pengguna AND pc_jenama LIKE "'.$pc_jenama.'%" AND LIMIT $eu, $limit ';

What wrong with this query??

php code

yoyorock — Tue, 26 May 2009 10:30:18 +0800

// print table
$data = '<table class="data" border="1" cellpadding="3" cellspacing="0" >
<tr>
<th>Bil</th>
<th>Jenama PC</th>
<th>Model</th>
<th>No PC</th>
<th>No Kunci</th>
<th>No Siri CPU</th>
<th>nama</th>
<th></th>
</tr>
';

# 2 change/add columns name
while($row = mysql_fetch_assoc($result)) {

$data .= "\n<tr>
\n\t<td> $row[no_pekerja]</td>
\n\t<td> $row[pc_jenama] </td>
\n\t<td> $row[pc_model]</td>
\n\t<td> $row[no_pc] </td>
\n\t<td> $row[no_kunci]</td>
\n\t<td> $row[no_siri_cpu] </td>
\n\t<td> $row[nama]</td>
\n\t<td><a href=viewmaklumat.php>View</a></td>
\n</tr>
";
}
$data .= "\n</table>\n";

This is my code..how can i put the below code into the above bold code??

<a href="viewmaklumat.php?pc_id=<?php echo $array['pc_id']; ?>&id_pengguna=<?php echo $array['id_pengguna']; ?>">View</a>

next and previous page using php

yoyorock — Mon, 25 May 2009 16:49:38 +0800

Next and previous page using php..any idea??

update data using php and javascript

yoyorock — Sun, 24 May 2009 10:17:59 +0800

<select name="jenama" size="1" id="brand" onChange="auto_select()">
</select> | <select name="model" size="1" id="model" style="width:150px"></select>
<script language="javascript">
navigator.appName;
var arr = new Array();
arr[0] = new Array("HP","HP1234","HPDV5228TX","HPDV2001TX");
arr[1] = new Array("ASUS","A8H","F3S");
arr[2] = new Array("ACER","Aspire4530","Aspire4935","Aspire3810T","TravelMate6493");
var IE = false;
var FF = false;
if (navigator.appName.indexOf("Microsoft") == 0) {
IE = true;
} else if (navigator.appName.indexOf("Netscape") == 0) {
FF = true;
}
function auto_select() {
while(document.getElementById("model").length > 0) {
document.getElementById("model").remove(0);
}
var si = document.getElementById("brand").selectedIndex;
if (FF) {
for (i = 1; i < arr[si].length; i++) {
document.getElementById("model").add(new Option(arr[si][i],arr[si][i]),null);
}
} else {
var newOption;
for (i = 0; i < arr[si].length; i++) {
newOption = document.createElement("option");
newOption.text = newOption.value = arr[si][i];
document.getElementById("model").add(newOption);
}
}
}
function initial() {
if (FF) {
for (i = 0; i < arr.length; i++) {
document.getElementById("brand").add(new Option(arr[i][0],arr[i][0]),null);
}
} else {
var newOption;
for (i = 0; i < arr.length; i++) {
newOption = document.createElement("option");
newOption.text = newOption.value = arr[i][0];
document.getElementById("brand").add(newOption);
}
}
document.getElementById("brand").options[0].selected = true;
}
initial();
auto_select();
</script>

i want to update data in sql that have list menu that are using javascript code..how can i display the original data in the list menu before update??how to combine with php code??

automatic select

yoyorock — Wed, 20 May 2009 10:19:57 +0800

hello..i want to ask a question...how to select automatically the value of list menu when i select other value of list menu..for example the first list menu is about the brand of the laptop and the second list menu is about the model of laptop...so, when i click on the brand of the laptop such as HP,i want it to automatic select the model of HP laptop...who can help me??