five_z 0 Report post Posted January 17, 2008 aku nak tanya, klu aku nak import text file ke phpmyadmin macam mana ye. aku dah try tapi kuar error la. so apa2 yang tau minta tolong k Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted January 18, 2008 Test fail tu fail database ker?mintak contoh text file tu boleh? Quote Share this post Link to post Share on other sites
five_z 0 Report post Posted January 18, 2008 text file tu aku amik dari excel n convert to text file, dalam tu ada field nama, ic n kelas. dalam tu ada maklumat dalam 10 org. bleh paham tak? bila aku upload textfile to ke phpmyadmin dia kuar error. tolong yea Quote Share this post Link to post Share on other sites
sYah_Is 0 Report post Posted January 20, 2008 (edited) Basic Page tu nak buat fail html dll spt dalam senarai tu.Fail html tak perlu pun server kalau nak tengok, guna browser dah cukup.Bila tak guna server page tu akan 'kaku' boleh baca sahaja.Melainkan kalau campur dgn skrip lain spt javascript.Dynamic Page nak buat fail spt PHP, ASP dllFail nie kena guna web server baru boleh run.Boleh sambung ke database. Bila dah boleh sambung ke DBmaka fail nie jadi dinamik, ada respon, dsb.Jadi, kalau nak buat page yang dinamik, guna menu Dynamic Page.Cara lain nak buat page, klik kanan dalam rungan SITE > New FileTaip nama fail yang kita nak buat : test.php --> jadi dinamik.Kalau taip --> test.html jadi statikok.***********************Fail Form<html><body><form action="test.php" method="post">Nama: <input type="text" name="nama" /> <br />No KP: <input type="text" name="nokp" /> <br /><input type="submit" value="Hantar"/></form></body></html>Fail Test.php<html><body>Selamat datang <?php echo $_POST["nama"]; ?>.<br />No KP anda ialah: <?php echo $_POST["nokp"]; ?>.</body></html>Macam tu ker?****************Tentang coding nak sambung ke database, kalau ko follow tutorial nie dengan betul, boleh tengok coding dia dalam Dreamweaver juga.Klik jer Tab Code.ok.Ooo...baru la aku faham bezanye 2.. So, kalu gune basic page untuk buat form yang boleh submit data ke database xleh la kan??kan?Iye..mcam ni la. Time kasih. Eh,nak taye satu lg.fail form n test.php buat suku2 ke coding atau sambung terus ek dlam satu fail? Hehe..sory la pro. Aku lupe dah. Edited January 20, 2008 by sYah_Is Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted January 20, 2008 Fail form dengan fail php tu suku2Fail form buat basic page html pun tak per. Quote Share this post Link to post Share on other sites
Han Abr 0 Report post Posted January 20, 2008 Brader PowerRootTongkatAli, Saya pun menghadapi masalah yang sama macam sYah Is. saya rasa mySQL saya yang ada problemlah.. bila nak buat connecton db kat dreamweaver keluar yang nie..Help me.." 1)there is no testing server running on the server machine.2) the testing server specified for this site does not map the http://localhost/_mmserverscripts/MMHTTPDB.php URL. verify that the URL Prefix maps to the root of the site." Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted January 20, 2008 Nie masalah setup site yang tak betul.Dah tengok contoh video yang saya buat tu.Cuba setup site dalam dreamweaver dengan betul.Satu lagi, pastikan web server is running. Quote Share this post Link to post Share on other sites
drparasite 0 Report post Posted January 31, 2008 biasa kalau sql x running kenaper ek..tlg Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted January 31, 2008 Biasanya kalau kita install Apache, PHP, MySql dan phpmyadmin menggunakan pakej spt XAMPP, WAMP atau EasyPHP dengan betul, SQL akan running tanpa masalah.Apa yang biasa berlaku masalah apache tak boleh running disebabkan PORT 80 telah digunakan oleh service lain spt IIS.Samada matikan service port 80 atau tukar apache ke port 8080 Quote Share this post Link to post Share on other sites
drparasite 0 Report post Posted January 31, 2008 Biasanya kalau kita install Apache, PHP, MySql dan phpmyadmin menggunakan pakej spt XAMPP, WAMP atau EasyPHP dengan betul, SQL akan running tanpa masalah.Apa yang biasa berlaku masalah apache tak boleh running disebabkan PORT 80 telah digunakan oleh service lain spt IIS.Samada matikan service port 80 atau tukar apache ke port 8080Tq brother power Quote Share this post Link to post Share on other sites
areef_ariaty 0 Report post Posted February 2, 2008 as'kum bro powerroot!bila nk smbung tutorial database...forum dh ok...x saba nak tau kisah slnjutnya...saya msh byk konpius lg nih....ssh jgk nk bt website nie... Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted February 2, 2008 akan disambung... tapi apa yang konfius tu. Quote Share this post Link to post Share on other sites
cyberfly 1 Report post Posted February 5, 2008 Cikgu,harap cikgu blh terangkan terperinci skit pasal filter dlm recordset tu.terutamanya untuk update dan delete.mcmamna dreamweaver tu leh identify record mana yg nak diubah,dan hendak didelete dlm senarai record yg byk. Quote Share this post Link to post Share on other sites
ifwan 0 Report post Posted February 5, 2008 try jangan tak try LATIHAN DATABASE ... sambungan dari atas.DELETE DATA-2Fail confirmdel.php=================================Inilah bentuk fail confirmdel.php yang perlu dibuat.Rajah 1: Fail Confirm Delete (confirmdel.php)1. Insert FormInsert > Form > Form2. Tambah hidden field ke dalam formKlik dalam form kemudian Insert > Form > Hidden FieldKlik ikon hidden field > Properties > tukar nama kepada hidden13. Buat Table dan masukkan maklumat seperti dalam Rajah 1.4. Binding Recordset.Application > Binding > + > RecordsetRajah 2:5. Binding Recordset ke hidden field Ikut step seperti dalam rajah 3.1. klik ikon hidden2. klik ikon 'lightning bolt'3. dalam dynamic data > klik id4, klik OK.Rajah 3: Binding hidden fieldAkhir sekali tambah logic untuk delete rekod.>Application > Server Behaviour > Recordset atauWindow > Server Behaviors> klik + > Delete Record> simpan fail.Rajah 4: Delete rekodCara nak uji:1. preview fail deldata.php2. klik Delete (kolum terakhir)3. masuk ke fail confirmdel.php4. klik butang Delete Recordok.==============akan bersambung ke Edit Data / Edit Recordsalam saudara...pertama sekali, inilah forum terbaik pernah saya jumpa dimana saudara powerroot sanggup meluangkan masa utk membimbing rakan2 lain dalam pembinaan database..tahniah sy ucapkn..saudara, alhamdulillah..setakat ini saya berjaya sepenuhnya mengikut segala tunjuk ajar serta bimbingan sehingga capai pada tahap ini..apakan daya, sy akhirnya tersangkut di bahagian ini dimana merujuk pada RAJAH1: fail confirm deletepada row 6 column kedua bawah {rsDel.price} dimana kelihatan satu butang DELETE RECORD dihasilkan..oleh hal dmikian, saya tdk jumpa bahagian tutorial anda yg membimbing bagaimana utk membuat butang tersebut.boleh kah saudara membimbing kami/atau mengulang lebih terperinci bahagian DELETE DATA -2 ini..terima kasih byk2 sgt atas kesudian atau kerelaan saudara membimbing kami satu persatu latihan ini..besar pahala tu..insyaallah..jasa sahabat powerroot amat saya hargai skian dr saya..wasalam Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted February 5, 2008 Kebelakangan ni saya agak jarang masuk dan post di sini sebab sekarang saya sudah ada banyak kerja kat makmal komputer kerana student MLVK dah mula masuk.Walaupun begitu saya selalu tengok forum dan cuba selesaikan kalau ada masalah. Cuma lambat la sikit. Harap maafOK. Quote Share this post Link to post Share on other sites
artakus 0 Report post Posted February 13, 2008 Cikgu, mcm mane nk buat 2 search dlm satu page?Cth : No. Id : ___________ [search] Nama Staf : ___________ [search]Harap cikgu blh reply secepat mungkin. TQ. Quote Share this post Link to post Share on other sites
SHiDi 0 Report post Posted February 13, 2008 (edited) Cikgu, mcm mane nk buat 2 search dlm satu page?Cth : No. Id : ___________ [search] Nama Staf : ___________ [search]Harap cikgu blh reply secepat mungkin. TQ. Saya nak tolong jawab boleh? Boleh la ek? Please................. Nak buat dua search sekali boleh. Pastikan cuma satu form je tau. Input nak berapa pun tak kisah, tapi form mesti satu sahaja.Dengan anggapan kau gunakan SQL, kau boleh gunakan keyword AND. ContohSELECT * FROM table_name WHERE no_id='no_id' AND nama_staf='nama_staf' Edited February 13, 2008 by SHiDi Quote Share this post Link to post Share on other sites
bio_energy 0 Report post Posted February 14, 2008 (edited) Masalah disini search tu nk digunakan salah satu shj.Samada nak guna search no_id atau nama.dan kedua2 nya link yang berlainan. b/p : artakus Edited February 14, 2008 by bio_energy Quote Share this post Link to post Share on other sites
SHiDi 0 Report post Posted February 14, 2008 (edited) Masalah disini search tu nk digunakan salah satu shj.Samada nak guna search no_id atau nama.dan kedua2 nya link yang berlainan. b/p : artakus Huh sampai dua nickname kau guna?Nak suruh user pilih salah satu senang je, gunakan radio buttonEDIT: Link berlainan? Maksud kau action ke? Kenapa nak guna lain-lain. Action tu kat biasanya pergi ke server side scripting files. Buat je filter kat situ. Edited February 14, 2008 by SHiDi Quote Share this post Link to post Share on other sites
songoten86 0 Report post Posted February 18, 2008 Nak tanye sket bule?? dulu aku pkai phptriad..aku ada wat sistem surat..by using phptriad tu sistem aku sume ok..functionnye sume jln..baru2 ni aku baru la nk kenal mengenal ngan xampp nih..tak bape reti nk guna..phptriad tade pon kene letak passw0rd or watever la...xampp ni kene plak..da try godek2 n at last phm jgk..problemnye skarang..bila run akunye sistem using xampp..byk function yg tak jd..ade tak sesape yg bole tgkkn sistem aku?? tp masalahnye sistem aku tak diuploadkn lg kt web..hehe..ni 1 of d problem.. <?php include("CON_SQL.INC"); require("util.inc"); include("config.php"); ob_start(); session_start(); if(!isset($hari) or !isset($bulan) or !isset($tahun)) {     $hari  = date("d");     $bulan = date("m");     $tahun  = date("Y"); }     //menunjukkan data mengenail alamat ip pengguna     $ip = $_SERVER['REMOTE_ADDR']; ob_start(); session_start(); $katanama = $_SESSION['katanama']; if($_SESSION['logged'] ==NULL) { header("location:login.php"); exit; }    include("header2.php");     // Maklumat Pemohon         $sql="SELECT*FROM admin WHERE nostaff = '$nostaff'";             $result=mysql_query($sql);               if ($mydata=mysql_fetch_array($result))         {         $vnama= $mydata["namastaff"];         $vnostaff =$mydata["nostaff"];         $vjawatan=$mydata["jawatan"];                  }         echo "<h1><font color=black><u> Carian Mengikut No Rujukan</u></h1>"; OpenTable(); echo "<center><tt><font size=3>Sila masukkan No Rujukan:</tt>"; ?> <script language="JavaScript" type="text/JavaScript"> <!-- function MM_preloadImages() { //v3.0   var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();     var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)     if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } //--> </script> <? echo "<FORM name=\"form1\" action=\"$PHP_SELF\" method=\"post\">       <table><tr>       <td><tt><font size=3>No Rujukan: </tt></td>       <td><input type=text name=\"carian\" size=15></td>            <td><input type=\"Submit\" name=\"cari\" value=\"Cari\"></td></tr>       </table>       </FORM></center>"; CloseTable(); echo "<br>"; if ($cari) {   tajuk("Senarai Surat");     OpenTable();     global $PHP_SELF;     $pageLimit = 10;     $table = "infosurat";     if (empty($offSet)) {$offSet = 0;}     $sql="SELECT * FROM $table where norujukan LIKE '$carian'";     $result=mysql_query($sql);     if ($mydata=mysql_fetch_array($result))     {       print  ("<table border=1 width=100% cellpadding = 3>");       print  ("<tr><th width=\"6%\"><tt><font size=3>No Rujukan</tt></th><th width=\"15%\"><tt><font size=3>Tarikh Terima</tt></th><th width=\"40%\"><tt><font size=3>Perkara</tt></th>               ");       do       {       //nak keluarkan nama bilik         $ttnorujukan = $mydata["norujukan"];       $sql1="SELECT norujukan FROM infosurat WHERE norujukan = '$ttknorujukan'";             $result1=mysql_query($sql1);             list($tkodbilik)=mysql_fetch_row($result1);                    //nak keluarkan nama pemohon         $ttnostaff = $mydata["nostaff"];       $sql2="SELECT namastaff FROM admin WHERE nostaff = '$ttnostaff'";             $result2=mysql_query($sql2);             list($tnamastaff)=mysql_fetch_row($result2);                     ?><tr bgcolor="lightblue"><td><tt><font size=3><a href="infosurat.php?tnorujukan=<? printf ($mydata["norujukan"]);  ?>" onMouseOver="window.status='STepS';       return true"><?php printf ($mydata["norujukan"]);?></a></tt></td>         <? printf ("<td><tt><font size=3>%s</tt></td><td><tt><font size=3>%s</tt></td>                 </tr>",                 $mydata["tarikhterima"],$mydata["perkara"]);                       } while ($mydata=mysql_fetch_array($result));       print ("</table>");       mysql_free_result($result);       nav($offSet,$table);     }     else {echo "<blink><font size=3 color=red>Maaf tiada Rekod...</font></blink>";}     CloseTable(); } ?> <script type="text/javascript">   function cetak(){       window.print()     }   function kembali(form){     window.location="laporan2.php";     }       </script>           <?             echo "<input type=\"button\" name=\"Submit2\" value=\"KEMBALI\" onClick=\"kembali()\">";       include("ufooter.php");         ?> <script type="text/javascript">   function kembali(form){     window.location="menucarian.php";     }       </script>ada pape problem tak ngan coding search nih?? aku pakai phptriad runkan coding nih ok jek..pakai xampp tak jln plak..tade kuar error pon..tp takda output..camne yek? Quote Share this post Link to post Share on other sites
songoten86 0 Report post Posted February 18, 2008 (edited) Cikgu, mcm mane nk buat 2 search dlm satu page?Cth : No. Id : ___________ [search] Nama Staf : ___________ [search]Harap cikgu blh reply secepat mungkin. TQ. ermm..kalo wat select statement yg berlainan bagi stiap button search bole gak kn??..contonhye..kalo tekan button search utk cari No.Id..gune la code SELECT * FROM table_name WHERE no_id='no_id' kalo tekan button search utk cari nama staff gune la code SELECT * FROM table_name WHERE nama_staff='nama_staff' nama button tu wat la lain2..cari1 ngan cari2.. if ($cari1) { Â Â SELECT * FROM table_name WHERE no_id='no_id' } else if($cari2) { Â Â SELECT * FROM table_name WHERE nama_staff='nama_staff' }ni suggestion jekk..kalo salah..tlg btulkn yek otai2..kami budak baru blajar jgk. heee~. Edited February 18, 2008 by songoten86 Quote Share this post Link to post Share on other sites
drparasite 0 Report post Posted February 21, 2008 masalah dgn delete n update..aku follow step b step tutorial ni tp yg mmeningkn kepala ialah kenapa bila aku delete jd t delete smua data,aku nk delete 1 jer..kes ni jgk mlibatkan update..hrp faham dgn soalan..tolong pro..TQ Quote Share this post Link to post Share on other sites
SHiDi 0 Report post Posted February 21, 2008 masalah dgn delete n update..aku follow step b step tutorial ni tp yg mmeningkn kepala ialah kenapa bila aku delete jd t delete smua data,aku nk delete 1 jer..kes ni jgk mlibatkan update..hrp faham dgn soalan..tolong pro..TQDah letak WHERE statement? Quote Share this post Link to post Share on other sites
drparasite 0 Report post Posted February 21, 2008 Dah letak WHERE statement?kat mn 2? Quote Share this post Link to post Share on other sites
Tae-Bo 0 Report post Posted February 21, 2008 kat mn 2?DELETE FROM tableName WHERE kod_id='$kod_id'bkn cmtu ke?? aku pon br blja jgk..sry klau slh Quote Share this post Link to post Share on other sites