Display Data And Send To Textfield In Php

June 12, 201015 yr

macam mana nak papar data (cth : Medan 'nama') lepas tu boleh klik jadi input pada textfield...dalam php...
harap dapat membantu...

TQ

Quote

Report

June 12, 201015 yr

jadikan je nama tu sebagai link..
pastu kat conditionnye tu buat la if link clicked { tukar text link tu kpd textfield }

nak lagi best guna ajax. Aku ada jumpe satu tutorial yang mcm tu tapi x ingat katner.
Kalo jumpe nanti aku post balik..

ataupun tunggu je otai2 javascript/ajax reply.. Hehe...

Quote

Report

June 12, 201015 yr

Author

macam mana yerk?..bole bagi contoh tak?

Quote

Report

June 14, 201015 yr

Try tgk laman web nih.. kot2 dapat idea ke..

http://www.yvoschaap.com/weblog/ajax_inline_instant_update_text_20/

atau yang ni

http://dbachrach.com/blog/2007/01/create-flickr-like-editing-fields-using-ajax-css/

Edited June 14, 201015 yr by dans kam

Quote

Report

June 16, 201015 yr

Author

[quote name='dans kam' date='14 June 2010 - 02:54 PM' timestamp='1276498482' post='1036714']
Try tgk laman web nih.. kot2 dapat idea ke..

http://www.yvoschaap.com/weblog/ajax_inline_instant_update_text_20/

atau yang ni

http://dbachrach.com/blog/2007/01/create-flickr-like-editing-fields-using-ajax-css/

[/quote]

Quote

Report

June 20, 201015 yr

Author

dah tengok..tapi tak jumpa jawapan...ada sesapa bole bantu...

Quote

Report

June 21, 201015 yr

xfaham daa...camne ekkkk

Quote

Report

June 21, 201015 yr

ini contoh yg mudah yg aku buat. Harap2 ko bleh dapat idea..

Fail [b]link2textfield.php[/b]

[code]
<?php
if(isset($_GET['editid']) && $_GET['editid']!=''){
$edittext = "<form><textarea>bla bla bla</textarea><button>Submit</button></form>";
}
else{
$edittext = "<a href='link2textfield.php?editid=2'>bla bla bla</a>";
}

echo "<h1>Test Text link to Textfield</h1>";
echo $edittext;
?>
[/code]

apa yg code tu buat ialah. Kalo user klik link tu, ia akan bertukar kepada textarea..

daripada situ ko bleh edit la pape yg patut k(ganti value2 tertentu drp db, etc).. tag form tu pun aku buat ala kadar je tu. just supaya dpt show result utk ko dpt idea..

Semoga membantu ko sikit sebanyak..

ps: ini contoh php biasa yg x guna ajax..

Edited June 21, 201015 yr by dans kam

Quote

Report

June 23, 201015 yr

Author

[quote name='dans kam' date='22 June 2010 - 12:08 AM' timestamp='1277136489' post='1038212']
ini contoh yg mudah yg aku buat. Harap2 ko bleh dapat idea..

Fail [b]link2textfield.php[/b]

[code]
<?php
if(isset($_GET['editid']) && $_GET['editid']!=''){
$edittext = "<form><textarea>bla bla bla</textarea><button>Submit</button></form>";
}
else{
$edittext = "<a href='link2textfield.php?editid=2'>bla bla bla</a>";
}

echo "<h1>Test Text link to Textfield</h1>";
echo $edittext;
?>
[/code]

apa yg code tu buat ialah. Kalo user klik link tu, ia akan bertukar kepada textarea..

daripada situ ko bleh edit la pape yg patut k(ganti value2 tertentu drp db, etc).. tag form tu pun aku buat ala kadar je tu. just supaya dpt show result utk ko dpt idea..

Semoga membantu ko sikit sebanyak..

ps: ini contoh php biasa yg x guna ajax..
[/quote]

Ok..apa yang saya buat ialah...saya mempunyai 2 page(form.php dan search.php)

form.php
[code]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Surat lantikan
</title>

<link href="../../css/colortextfield.css" rel="stylesheet" type="text/css" />
</head>

<body>

<form action="cetaksurat.php" method="post" name="form1" class="style1" id="form1">
<table width="741" border="1" align="center" class="surat">

<tr bgcolor="#999999" class="style1">
<td height="49" colspan="2" valign="top"><div align="center"><font size="4" face="Verdana, Arial, Helvetica, sans-serif"><strong>Pelantikan
sebagai Ketua Pengawas</strong></font><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><br />
 </font><font size="4" face="Verdana, Arial, Helvetica, sans-serif"><strong><font size="2">(Bukan
Kakitangan SPA)</font> </strong></font><font size="2" face="Verdana, Arial, Helvetica, sans-serif"></font><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><br />
</font></div></td>
</tr>
<tr class="style1">
<td height="44" colspan="2" valign="top"><font size="2" face="Arial, Helvetica, sans-serif"><font color="#000099" face="Verdana, Arial, Helvetica, sans-serif"><strong>Sila
lengkapkan maklumat dibawah</strong> :-<br />
</font></font></td>
</tr>
<tr class="style1">
<td width="273" height="27" valign="top"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif"><span class="style1">Rujukan
surat : </span></font></strong></td>
<td width="452" valign="top"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif">
<label>
<input name="txtrujukan" type="text" class="textfieldcolor" id="txtrujukan" />
</label>
</font></strong></td>
</tr>
<tr class="style1">
<td height="26" valign="top"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif"><span class="style1">Tarikh
surat : </span></font></strong></td>
<td valign="top"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif">
<select name="select">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select>
hb
<select name="select2">
<option>Januari</option>
<option>Februari</option>
<option>Mac</option>
<option>April</option>
<option>Mei</option>
<option>Jun</option>
<option>Julai</option>
<option>Ogos</option>
<option>September</option>
<option>Oktober</option>
<option>November</option>
<option>Disember</option>
</select>
Bulan
<select name="select3">
<option>2000</option>
<option>2001</option>
<option>2002</option>
<option>2003</option>
<option>2004</option>
<option>2005</option>
<option>2006</option>
<option>2007</option>
<option>2008</option>
<option>2009</option>
<option>2010</option>
<option>2011</option>
<option>2012</option>
<option>2013</option>
<option>2014</option>
<option>2015</option>
<option>2016</option>
<option>2017</option>
<option>2018</option>
<option>2019</option>
<option>2020</option>
</select>
Tahun </font></strong></td>
</tr>
<tr class="style1">
<td height="27" valign="top"><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Gelaran
:</strong></font></td>
<td valign="top"><select name="selectgelaran" id="selectgelaran">
<option>Tuan</option>
<option>Puan</option>
<option>Encik</option>
<option>Cik</option>
</select></td>
</tr>
<tr class="style1">
<td height="27" valign="top"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif"><span class="style1">Nama
Ketua/Pengawas </span>:</font></strong></td>
<td valign="top"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="txtpengawas" type="text" class="textfieldcolor" id="txtpengawas" />
<A HREF="javascript:void(0)"onclick="window.open('../../pengawas/search.php',
'welcome','width=600,height=400')">
Cari</A></font></strong></td>
</tr>
<tr class="style1">
<td height="27" valign="top"><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Melalui
: </strong></font></td>
<td valign="top"><select name="Selectmelalui" id="Selectmelalui">
<option>Ketua Pengarah</option>
<option>Pengarah</option>
<option>Setiausaha Bahagian</option>
<option>Ketua Bahagian</option>
<option>Ketua Seksyen</option>
<option>Pengetua</option>
<option>Guru Besar</option>
</select></td>
</tr>
<tr class="style1">
<td height="27" valign="top"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif">Nama
Jabatan :</font></strong></td>
<td valign="top"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="txtjab" type="text" class="textfieldcolor" id="txtjab" />
cari </font></strong></td>
</tr>
<tr class="style1">
<td height="27" valign="top"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif"><span class="style1">Alamat
bertugas : </span></font></strong></td>
<td valign="top"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="txtalamat" type="text" class="textfieldcolor" id="txtalamat" />
cari </font></strong></td>
</tr>
<tr class="style1">
<td height="27" valign="top"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif">Peperiksaan
: </font></strong></td>
<td><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif"><span class="style3">
<input name="txtpep" type="text" class="textfieldcolor" id="txtpep" />
cari </span></font></strong></td>
</tr>
<tr class="style1">
<td height="27" valign="top"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif">Tarikh
Peperiksaan :</font></strong></td>
<td><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif">
<select name="select4">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select>
hb
<select name="select5">
<option>Januari</option>
<option>Februari</option>
<option>Mac</option>
<option>April</option>
<option>Mei</option>
<option>Jun</option>
<option>Julai</option>
<option>Ogos</option>
<option>September</option>
<option>Oktober</option>
<option>November</option>
<option>Disember</option>
</select>
Bulan
<select name="select6">
<option>2000</option>
<option>2001</option>
<option>2002</option>
<option>2003</option>
<option>2004</option>
<option>2005</option>
<option>2006</option>
<option>2007</option>
<option>2008</option>
<option>2009</option>
<option>2010</option>
<option>2011</option>
<option>2012</option>
<option>2013</option>
<option>2014</option>
<option>2015</option>
<option>2016</option>
<option>2017</option>
<option>2018</option>
<option>2019</option>
<option>2020</option>
</select>
Tahun </font></strong></td>
</tr>
<tr class="style1">
<td height="27" valign="top"><p class="style1"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif">Nama
pusat peperiksaan :</font></strong></p></td>
<td><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif"><span class="style1">
<input name="txtpusat" type="text" class="textfieldcolor" id="txtpusat" />
cari </span></font></strong></td>
</tr>
<tr class="style1">
<td height="40" valign="top"><p class="style1"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif">Alamat
Pusat :</font></strong></p></td>
<td valign="top"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="txtalamatp" type="text" class="textfieldcolor" id="txtalamatp" />
cari</font></strong></td>
</tr>
<tr class="style1">
<td height="30" valign="top"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif"><span class="style1">
<input type="submit" name="Submit" value="Proses" />
</span></font></strong></td>
<td><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></strong></td>
</tr>
<tr class="style1">
<td height="24"><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif">  </font></strong></td>
<td><strong><font color="#333333" size="2" face="Verdana, Arial, Helvetica, sans-serif"> </font></strong></td>
</tr>
</table>
</form>
</body>
</html>

[/code]

search.php

[code]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Search Contacts</title>
<style type="text/css" media="screen">
ul li{
list-style-type:none;
}
.style1 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
</style>
</head>

<body>
<h3 class="style1">Cari Nama Pengawas </h3>
<form action="search.php?go" method="post" name="searchform" class="style1" id="searchform">
<input type="text" name="name">
<input type="submit" name="submit" value="Search">
<span class="style1">
<?php

if(isset($_POST['submit'])){
if(isset($_GET['go'])){
//if(preg_match("/[A-Z | a-z]+/", $_POST['name'])){
$name=$_POST['name'];

//connect to the database
$db=mysql_connect (localhost, root,xxx) or die ('I cannot connect to the database because: ' . mysql_error());

//-select the database to use
$mydb=mysql_select_db(peperiksaan);

//-query the database table
$sql="SELECT Nama, Namajab FROM pengawas WHERE Nama LIKE '%" . $name . "%' OR KP LIKE '%" . $name ."%'";

//-run the query against the mysql query function
$result=mysql_query($sql);

//-count results

$numrows=mysql_num_rows($result);

echo "<p>" .$numrows . " results found for " . stripslashes($name) . "</p>";

//-create while loop and loop through result set
while($row=mysql_fetch_array($result)){

$Nama =$row['Nama'];
$Namajab=$row['Namajab'];
$KP=$row['KP'];

//-display the result of the array

echo "<ul>\n";
echo "<li>" . "<a href=\"search.php?id=$KP\">" .$Nama . " " . $Namajab . "</a></li>\n";
echo "</ul>";
}
}
else{
echo "<p>Sila masukkan Nama Pengawas </p>";
}
}
//}

if(isset($_GET['by'])){
$letter=$_GET['by'];

//connect to the database
$db=mysql_connect (localhost, root, xxx) or die ('I cannot connect to the database because: ' . mysql_error());

//-select the database to use
$mydb=mysql_select_db(peperiksaan);

//-query the database table
$sql="SELECT Nama, Namajab FROM pengawas WHERE Nama LIKE '%" . $letter . "%' OR KP LIKE '%" . $letter ."%'";

//-run the query against the mysql query function
$result=mysql_query($sql);

//-count results
$numrows=mysql_num_rows($result);

echo "<p>" .$numrows . " results found for " . $letter . "</p>";

//-create while loop and loop through result set
while($row=mysql_fetch_array($result)){

$Nama =$row['Nama'];
$Namajab=$row['Namajab'];
$KP=$row['KP'];

//-display the result of the array

echo "<ul>\n";
echo "<li>" . "<a href=\"search.php?id=$KP\">" .$Nama . " " . $Namajab. "</a></li>\n";
echo "</ul>";
}
}

if(isset($_GET['id'])){
$contactid=$_GET['id'];

//connect to the database
$db=mysql_connect (localhost, root, xxxx) or die ('I cannot connect to the database because: ' . mysql_error());

//-select the database to use
$mydb=mysql_select_db(peperiksaan);

//-query the database table
$sql="SELECT * FROM pengawas ORDER BY Nama ASC";

//-run the query against the mysql query function
$result=mysql_query($sql);

//-create while loop and loop through result set
while($row=mysql_fetch_array($result))
{

$Nama =$row['Nama'];
//$KP=$row['KP'];
//$alamat=$row['alamat'];
$Namajab=$row['Namajab'];

//-display the result of the array

echo "<ul>\n";
echo "<li>" . $Nama . " " . $Namajab . "</li>\n";
//echo "<li>" . $alamat . "</li>\n";
//echo "<li>" . "<a href=mailto:" . $Namajab . ">" . $Namajab . "</a></li>\n";
echo "</ul>";
}
}

?>
</span>
</form>
</body>
</html>

[/code]

kat form.php saya ada link carian yang mana bila klik dia akan papar new window (pop up window)

[code]
<input name="txtpengawas" type="text" class="textfieldcolor" id="txtpengawas" />
<A HREF="javascript:void(0)"onclick="window.open('../../pengawas/search.php',
'welcome','width=600,height=400')">
Cari</A></font></strong>
[/code]

kat search.php...saya akan masukkan input carian..bila jumpa dia akan papar nama pengawas dan boleh klik,bila klik nama pengawas tersebut dia akan masukkan pada textfield di form.php.

itu yang tak tau mcm mana nak buat...tolong sesapa boleh membantu dan ada idea...TQ

Quote

Report

June 23, 201015 yr

[quote name='sue_irna' date='23 June 2010 - 04:34 PM' timestamp='1277282089' post='1038522']
Ok..apa yang saya buat ialah...saya mempunyai 2 page(form.php dan search.php)

kat form.php saya ada link carian yang mana bila klik dia akan papar new window (pop up window)

[code]
<input name="txtpengawas" type="text" class="textfieldcolor" id="txtpengawas" />
<A HREF="javascript:void(0)"onclick="window.open('../../pengawas/search.php',
'welcome','width=600,height=400')">
Cari</A></font></strong>
[/code]

kat search.php...saya akan masukkan input carian..bila jumpa dia akan papar nama pengawas dan boleh klik,bila klik nama pengawas tersebut dia akan masukkan pada textfield di form.php.

itu yang tak tau mcm mana nak buat...tolong sesapa boleh membantu dan ada idea...TQ
[/quote]

00oo0oooo mcm tu sbnrnye...

Kalo guna popup ni sy xtau la pulak mcmane. X pernah buat.. Memang [b]kene tunggu otai php untuk jbwkan[/b]..

Mungkin boleh guna javascript rasanye. Guna id. tapi aku xtau mcmane. hehe..

Tapi kalo x guna popup(satu page search biasa), kita boleh je letak iduser(drp query db) kat url
[code]<a href='form.php?iduser=2'>Ahmad Bin Labu</a>[/code]
Lepas klik link tu, kat form.php tu buat query guna $_GET['iduser'] utk dapatkan maklumat nama tersebut dan seterusnya isi ke textfield form tu.

[b]Tapikan... Sekadar nak tanya jer..[/b]
Nape buat guna popup? nape x letak search tu kat fail form tu jugak? leh guna [url="http://www.dezinerfolio.com/2007/07/19/simple-javascript-accordions/"]accordion[/url] utk hidekan form tu dulu. Bila klik pautan borang baru form muncul.

Maaf la kalo masih x dpt membantu..
Harap otai2 php boleh bantu kawan kita ni..

Quote

Report

June 23, 201015 yr

Author

saya guna pop-up window tu sbb itu yang pernah saya nampak...macam isi tarikh lahir kat borang..kat tepi textfield tu ada kalendar...bole pilih tarikh lepas tu dia akan paparkan pada textfield..mcm tu la konsep dia...

guna accordian?...mcm mana yerk?..bole tunjuk ke? tak kisahla nak pakai php..yang penting boleh berfungsi.

Quote

Report

June 24, 201015 yr

[quote name='sue_irna' date='23 June 2010 - 10:07 PM' timestamp='1277302036' post='1038567']
saya guna pop-up window tu sbb itu yang pernah saya nampak...macam isi tarikh lahir kat borang..kat tepi textfield tu ada kalendar...bole pilih tarikh lepas tu dia akan paparkan pada textfield..mcm tu la konsep dia...

guna accordian?...mcm mana yerk?..bole tunjuk ke? tak kisahla nak pakai php..yang penting boleh berfungsi.
[/quote]

Boleh guna javascript...kalau nk contoh boleh contact YM atau skype...

[email protected]
FerazieSkype

Quote

Report

June 24, 201015 yr

dh berapa hari x selesai lagi ke
google inplace editing

Quote

Report

June 25, 201015 yr

[quote name='Kuzie' date='24 June 2010 - 03:33 PM' timestamp='1277364803' post='1038666']
Boleh guna javascript...kalau nk contoh boleh contact YM atau skype...

[email protected]
FerazieSkype
[/quote]

Kalau yang mcm kalendar pop up tu memang guna javascritp.
Try contact Bro Kuzie. Mane tau dia dapat bantu..

Edited June 25, 201015 yr by dans kam

Quote

Report

June 26, 201015 yr

[quote name='dans kam' date='25 June 2010 - 10:58 AM' timestamp='1277434716' post='1038811']
Kalau yang mcm kalendar pop up tu memang guna javascritp.
Try contact Bro Kuzie. Mane tau dia dapat bantu..
[/quote]

Dah dapat contact..jgn risau kalau dapat jalan penyelesaian semua persoalan, result akan di post disini....

Quote

Report

June 27, 201015 yr

[code]
<?php

mysql_connect('localhost','root','');
mysql_select_db('contoh');
$mydb=mysql_select_db('contoh');
$myid = $_GET['id'];

//connect to the database
$db=mysql_connect ('localhost', 'root', '') or die ('I cannot connect to the database because: ' . mysql_error());
$mydb=mysql_select_db('contoh');
$sql="SELECT * FROM pengawas WHERE Nama LIKE '" . $myid . "' ";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);

$Nama = $row['Nama'];
$Namajab = $row['Namajab'];
$alamat = $row['alamat'];

?>
<input name="<?php echo $Nama; ?>" id="<?php echo $Nama; ?>" value="<?php echo $Nama; ?>" />
<input name="<?php echo $Namajab; ?>" id="<?php echo $Namajab; ?>" value="<?php echo $Namajab; ?>" />
<input name="<?php echo $alamat; ?>" id="<?php echo $alamat; ?>" value="<?php echo $alamat; ?>" />
[/code]

Kod terlalu panjang so aku kecikkan jadi camni la kot....
contoh kat atas bila string ($_GET['id']) akan dihantar ke page ni dan code sql akan search dalam database.
texfield akan mewakili row yang mana kita pilih dalam database...
Payah nk terang harap faham...hehehe...

p/s:code kat atas xde security untuk sql injection...just simple coding..

Quote

Report

Display Data And Send To Textfield In Php

Featured Replies

Join the conversation

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)

Chrome (Desktop)

Safari (iOS 16.4+)

Safari (macOS)

Edge (Android)

Edge (Desktop)

Firefox (Android)

Firefox (Desktop)