biskut merry 1 Report post Posted June 27, 2008 (edited) salamaku nk mintak tolong ngan abang2 n akak2 sume..cmni cite nye..aku ade wat satu sistem,guna php..1st time gune php..baru2 nk blajar..huhusistem yg aku wat adalah sistem permohonan kerja..simple je..tp disebabkan aku ni baru je nk berjinak-jinak ngan php mySQLni jadi aku perlukan pertolongan dari abang2 n akak sume yg tau pasal php mySQL ni..harap ade yg sudi menghulurkan bantuan.. Edited July 3, 2008 by biskut_merry Quote Share this post Link to post Share on other sites
SHiDi 0 Report post Posted June 27, 2008 Dengan anggapan kau ada menggunakan database. Buat satu column sebagai penanda, contoh nama column, processed. Nilai untuk column tu adalah boolean. Kiranya belum letakkan 0, kalau sudah 1.Ni pendapat aku la kan Quote Share this post Link to post Share on other sites
luv 0 Report post Posted June 27, 2008 (edited) Dengan anggapan kau ada menggunakan database. Buat satu column sebagai penanda, contoh nama column, processed. Nilai untuk column tu adalah boolean. Kiranya belum letakkan 0, kalau sudah 1.Ni pendapat aku la kan sambungan dr idea shidi.. pastu ko select la cmni<?php $query="SELECT processed FROM <dbname> WHERE processed=\"0\""; $query=mysql_query($query); for($j=1; $j <= $row=mysql_fetch_assoc($query); $j++) {} echo "<a href=\"process.php\">New($j)"; ?>ok? kalau aku salah, betulkn la.. agak lupe ckit dah..echo "<a href=\"process.php\">New($j)"; <-- bermaksud akan btahu berapa byk permohonan yg masih blom diproses. mcm email kt yahoo. die bgtahu Inbox(10). ade fhm? gud luck! Edited June 27, 2008 by luv Quote Share this post Link to post Share on other sites
SHiDi 0 Report post Posted June 27, 2008 (edited) <?php $query="SELECT processed FROM <dbname> WHERE processed=\"0\""; $query=mysql_query($query); for($j=1; $j <= $row=mysql_fetch_assoc($query); $j++) {} echo "<a href=\"process.php\">New($j)"; ?> ok? kalau aku salah, betulkn la.. agak lupe ckit dah.. Rasa ada silap SQL kau tu. Bukan ke patutnya: SELECT processed FROM table_name WHERE processed = 0 Dan berdasarkan code kau tu, kau nak kira berapa yang belum diuruskan, kan? Kenapa nak buat camtu? Pada pendapat aku kurang efficient. Aku rasa baik guna SQL syntax: SELECT COUNT(*) FROM table_name WHERE processed = 0Sekadar pendapat Edited June 27, 2008 by SHiDi Quote Share this post Link to post Share on other sites
rasberry 0 Report post Posted June 27, 2008 mintak tolong bagi idea leh la ye tak.. Quote Share this post Link to post Share on other sites
luv 0 Report post Posted June 27, 2008 Rasa ada silap SQL kau tu. Bukan ke patutnya:SELECT processed FROM table_name WHERE processed = 0 Dan berdasarkan code kau tu, kau nak kira berapa yang belum diuruskan, kan? Kenapa nak buat camtu? Pada pendapat aku kurang efficient. Aku rasa baik guna SQL syntax: SELECT COUNT(*) FROM table_name WHERE processed = 0Sekadar pendapat ha`ah.. idea kat tuh lagik bagus, xpayah penin kpala.. sori bro, sudah lupe cara menulisnye.. ahahahaha.. Quote Share this post Link to post Share on other sites
biskut merry 1 Report post Posted June 27, 2008 (edited) Dengan anggapan kau ada menggunakan database. Buat satu column sebagai penanda, contoh nama column, processed. Nilai untuk column tu adalah boolean. Kiranya belum letakkan 0, kalau sudah 1.Ni pendapat aku la kan untuk kes aku ni, aku ade gune 2 database..satu untk admin pnye username n password...satu lagi untuk simpan mklumat pemohon..so aku kn tmbh satu column baru dkt table maklumat pemohon..tp aku xtau cmne nk wat tok nilai boolean ni..klu ble nk ko tunjuk kan cara..klu boleh bg detail sket sbb aku xtau cmne nk wat..xpaham.. aku ni baru je nk blaja wat bende ni..aku xpaham cmne nk wat boolean ni..cmne nk set bile belom 0, bila sudah 1..sory byk tnye..aku budak baru blajar.. sambungan dr idea shidi.. pastu ko select la cmni<?php $query="SELECT processed FROM <dbname> WHERE processed=\"0\""; $query=mysql_query($query); for($j=1; $j <= $row=mysql_fetch_assoc($query); $j++) {} echo "<a href=\"process.php\">New($j)"; ?>ok? kalau aku salah, betulkn la.. agak lupe ckit dah..echo "<a href=\"process.php\">New($j)"; <-- bermaksud akan btahu berapa byk permohonan yg masih blom diproses. mcm email kt yahoo. die bgtahu Inbox(10). ade fhm? gud luck!proses.php...ape yg aku kn tulis tok proses.php ni?pe2 pn trime kasih byk2 sbb anda berdua sudi membantu.. Edited June 27, 2008 by biskut_merry Quote Share this post Link to post Share on other sites
ejoe 0 Report post Posted June 27, 2008 untuk kes aku ni, aku ade gune 2 database..satu untk admin pnye username n password...satu lagi untuk simpan mklumat pemohon..so aku kn tmbh satu column baru dkt table maklumat pemohon..tp aku xtau cmne nk wat tok nilai boolean ni..klu ble nk ko tunjuk kan cara..klu boleh bg detail sket sbb aku xtau cmne nk wat..xpaham.. aku ni baru je nk blaja wat bende ni..aku xpaham cmne nk wat boolean ni..cmne nk set bile belom 0, bila sudah 1..bukan 2 database la bro..2 tablebtw masa nak add field 1 lg tu ko kat phpmyadmin pilih datatype BOOL or TINTINT(1) Quote Share this post Link to post Share on other sites
biskut merry 1 Report post Posted June 28, 2008 ok2 aku phm da nk wat penanda tu cmna..huhu..semalam aku lupe..skang aku da igt konsep boolean..boolean cuma ade 2 nilai je kn..0 n 1..true or false..yes or no..same cam progming gk..huhu..thanks bro.. Quote Share this post Link to post Share on other sites
biskut merry 1 Report post Posted June 29, 2008 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use nearape maksud error ni? cmne nk fix? Quote Share this post Link to post Share on other sites
Cho Chang 0 Report post Posted June 29, 2008 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use nearngko nie gna mySql yang cmmd prompt tu ker??? walooooo Quote Share this post Link to post Share on other sites
biskut merry 1 Report post Posted June 29, 2008 ngko nie gna mySql yang cmmd prompt tu ker??? walooooo aku gune mySQL yg dalam wampp..emm..ko taux nape jadi cmni n cmne nk fix..thanks coz sudi membalas.. Quote Share this post Link to post Share on other sites
ejoe 0 Report post Posted June 29, 2008 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use nearape maksud error ni? cmne nk fix? SQL ko problem..paste kat sini code SQL ko tu Quote Share this post Link to post Share on other sites
Cho Chang 0 Report post Posted June 30, 2008 SQL ko problem..paste kat sini code SQL ko tua'aa ko try kasi kitaorg tngok ko nya script... mana tau leh membantu hehehe Quote Share this post Link to post Share on other sites
biskut merry 1 Report post Posted June 30, 2008 (edited) salam..ini kod nye<?php require_once('Connections/aku.php'); ?> <?php function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue; switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) { $insertSQL = sprintf("INSERT INTO maklumat_pemohon (nama, i/c_no, alamat, telefon_no, start_date, end_date, edu_level, course, IPT) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['nama'], "text"), GetSQLValueString($_POST['ic_no'], "int"), GetSQLValueString($_POST['alamat'], "text"), GetSQLValueString($_POST['telefon_no'], "int"), GetSQLValueString($_POST['start_date'], "date"), GetSQLValueString($_POST['end_date'], "date"), GetSQLValueString($_POST['edu_level'], "text"), GetSQLValueString($_POST['course'], "text"), GetSQLValueString($_POST['IPT'], "text")); mysql_select_db($database_aku, $aku); $Result1 = mysql_query($insertSQL, $aku) or die(mysql_error()); $insertGoTo = "view_detail.php"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo)); } ini pn same gk <?php require_once('Connections/aku.php'); ?> <?php function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue; switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) { $updateSQL = sprintf("UPDATE maklumat_pemohon SET nama=%s, i/c_no=%s, alamat=%s, telefon_no=%s, start_date=%s, end_date=%s, edu_level=%s, course=%s, IPT=%s, proses=%s WHERE bil=%s", GetSQLValueString($_POST['nama'], "text"), GetSQLValueString($_POST['ic_no'], "int"), GetSQLValueString($_POST['alamat'], "text"), GetSQLValueString($_POST['telefon_no'], "int"), GetSQLValueString($_POST['start_date'], "date"), GetSQLValueString($_POST['end_date'], "date"), GetSQLValueString($_POST['edu_level'], "text"), GetSQLValueString($_POST['course'], "text"), GetSQLValueString($_POST['IPT'], "text"), GetSQLValueString($_POST['proses'], "int"), GetSQLValueString($_POST['bil'], "int")); mysql_select_db($database_aku, $aku); $Result1 = mysql_query($updateSQL, $aku) or die(mysql_error()); $updateGoTo = "view_detail.php"; if (isset($_SERVER['QUERY_STRING'])) { $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?"; $updateGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $updateGoTo)); } $colname_Recordset1 = "-1"; if (isset($_GET['bil'])) { $colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['bil'] : addslashes($_GET['bil']); } mysql_select_db($database_aku, $aku); $query_Recordset1 = sprintf("SELECT * FROM maklumat_pemohon WHERE bil = %s", $colname_Recordset1); $Recordset1 = mysql_query($query_Recordset1, $aku) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); ?>thanks Edited June 30, 2008 by biskut_merry Quote Share this post Link to post Share on other sites
Cho Chang 0 Report post Posted July 1, 2008 mak aiiii.... camna nak trace nihhhh.... abg amin tlong2 la tgok huhuh :wacho: Quote Share this post Link to post Share on other sites
amin007 1 Report post Posted July 2, 2008 (edited) mak aiiii.... camna nak trace nihhhh.... abg amin tlong2 la tgok huhuh :wacho:ada juga orang memanggil nama aku yerterpaksalah aku tolongdari apa yang aku tengok biskut_merry buat... $Result1 = mysql_query($insertSQL, $aku) or die(mysql_error()); ... $Result1 = mysql_query($updateSQL, $aku) or die(mysql_error()); masalahnya apa akan jadi kalau mysql_query() gagal dilaksanakan, dia akan keluar mesej kematian -> die(mysql_error()) lepas kematian dia akan disoal -> mysql_error() soalannya You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near jadi pulak masalah biskut_merry tak bawa bekalan yang mengcukupi (maklumat tak lengkap) memang laa nak kena rotan budak ni disebabkan kesian, kod ni perlu ditambah agar sebab nak bug ada banyak cara nak bug, tapi aku lebih suka pakai cara ni ... $Result1 = mysql_query($insertSQL, $aku) or die(mysql_error()."<hr>$insertSQL<hr>"); ... $Result1 = mysql_query($updateSQL, $aku) or die(mysql_error()."<hr>$updateSQL<hr>");jadi lepas tu barulah betulkalau mati pun, kena soal, tak kisah sebab bekalan mengcukupi.error in your SQL syntax maksudnya sql ko tu ada masalah sintakmacam mana aku nak semak kalau sqlnya aku tak tahu bentuk macam mana???ini cara yang paling mudah nak semak sql betul ker takada cara lain tapi ... Edited July 2, 2008 by amin007 Quote Share this post Link to post Share on other sites
biskut merry 1 Report post Posted July 2, 2008 salam..time kasih amin kerna sudi membantu..aku da try tmbah code yg ko bg tu tp xjadi jgk r..die kuar error1. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/c_no, alamat, telefon_no, start_date, end_date, edu_level, course, IPT) VAL' at line 1INSERT INTO maklumat_pemohon (nama, i/c_no, alamat, telefon_no, start_date, end_date, edu_level, course, IPT) VALUES ('dfdsfdsfs', 23124214, 'cxvdsvsafda', 123413113, '20020203', '20020505', 'gdsgfhk', 'trerujejw', 'gsdfsgswergw')2. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/c_no=2147483647, alamat='wsdfdsfdsfsdfdfsfddfsfsdsdfsdfdsfdfsfdfsdf', telefon_n' at line 1UPDATE maklumat_pemohon SET nama='sadsfaf', i/c_no=2147483647, alamat='wsdfdsfdsfsdfdfsfddfsfsdsdfsdfdsfdfsfdfsdf', telefon_no=123413113, start_date='2008-06-02', end_date='2008-06-30', edu_level='dsfdsfdsfdgf', course='trerujejw', IPT='gsdfsgswergw', proses=1 WHERE bil=1harap amin dpt tolong tgk kn skali lagi..time kasih Quote Share this post Link to post Share on other sites
SHiDi 0 Report post Posted July 2, 2008 Nama field kau memang i/c no ke? Quote Share this post Link to post Share on other sites
biskut merry 1 Report post Posted July 2, 2008 Nama field kau memang i/c no ke?yupp.. Quote Share this post Link to post Share on other sites
BasicCX 27 Report post Posted July 2, 2008 Sila la tukar field utk ic daripada i/c_no kepada ic_no Quote Share this post Link to post Share on other sites
biskut merry 1 Report post Posted July 2, 2008 Sila la tukar field utk ic daripada i/c_no kepada ic_nothanks bro..da jadi da..kirenye klu untk name field tu mmg xleh gune ' / ' la ek?time kasih.. Quote Share this post Link to post Share on other sites
amin007 1 Report post Posted July 2, 2008 (edited) thanks bro..da jadi da..kirenye klu untk name field tu mmg xleh gune ' / ' la ek?time kasih.. apasal laa ko pilih nama medan i/c_no??? satu cara lain1) tak payah tulis nama medan kat insert INSERT INTO maklumat_pemohon VALUES ('dfdsfdsfs', 23124214, 'cxvdsvsafda', 123413113, '20020203', '20020505', 'gdsgfhk', 'trerujejw', 'gsdfsgswergw') 2) buat kurungan [] atau `` INSERT INTO maklumat_pemohon (nama, [i/c_no], alamat, telefon_no, start_date, end_date, edu_level, course, IPT) VALUES ('dfdsfdsfs', 23124214, 'cxvdsvsafda', 123413113, '20020203', '20020505', 'gdsgfhk', 'trerujejw', 'gsdfsgswergw') INSERT INTO maklumat_pemohon (nama, `i/c_no`, alamat, telefon_no, start_date, end_date, edu_level, course, IPT) VALUES ('dfdsfdsfs', 23124214, 'cxvdsvsafda', 123413113, '20020203', '20020505', 'gdsgfhk', 'trerujejw', 'gsdfsgswergw')cubalah dulu , tengok apa jadi hehehe.setakat yang aku test pada mssql dan mysql macam jadi.tapi apa pun, gunalah nama yang senang sikit.paling kurang guna simbol underscore _ , jangan pakai simbol lainkalau boleh pakai huruf A hingga Z lagi baik Edited July 2, 2008 by amin007 Quote Share this post Link to post Share on other sites
biskut merry 1 Report post Posted July 2, 2008 apasal laa ko pilih nama medan i/c_no??? satu cara lain1) tak payah tulis nama medan kat insert INSERT INTO maklumat_pemohon VALUES ('dfdsfdsfs', 23124214, 'cxvdsvsafda', 123413113, '20020203', '20020505', 'gdsgfhk', 'trerujejw', 'gsdfsgswergw') 2) buat kurungan [] atau `` INSERT INTO maklumat_pemohon (nama, [i/c_no], alamat, telefon_no, start_date, end_date, edu_level, course, IPT) VALUES ('dfdsfdsfs', 23124214, 'cxvdsvsafda', 123413113, '20020203', '20020505', 'gdsgfhk', 'trerujejw', 'gsdfsgswergw') INSERT INTO maklumat_pemohon (nama, `i/c_no`, alamat, telefon_no, start_date, end_date, edu_level, course, IPT) VALUES ('dfdsfdsfs', 23124214, 'cxvdsvsafda', 123413113, '20020203', '20020505', 'gdsgfhk', 'trerujejw', 'gsdfsgswergw')cubalah dulu , tengok apa jadi hehehe.setakat yang aku test pada mssql dan mysql macam jadi.tapi apa pun, gunalah nama yang senang sikit.paling kurang guna simbol underscore _ , jangan pakai simbol lainkalau boleh pakai huruf A hingga Z lagi baiksalamtime kasih diatas penerangan anda..sebelom ni aku ty gk gune ' ' tp xleh gk..itu yg pening tuh..da la aku ni baru je main ngan php n sql ni..td aku da ubah nama i/c_no tu jadi ic_no n tambah coding "<hr>$insertSQL<hr>" n alhamdulillah jadi..thanks sume.. Quote Share this post Link to post Share on other sites
amin007 1 Report post Posted July 3, 2008 salamtime kasih diatas penerangan anda..sebelom ni aku ty gk gune ' ' tp xleh gk..itu yg pening tuh..da la aku ni baru je main ngan php n sql ni..td aku da ubah nama i/c_no tu jadi ic_no n tambah coding "<hr>$insertSQL<hr>" n alhamdulillah jadi..thanks sume.. kalau ko guna tanduk satu '' memanglah ada masalah,contoh macam nilah katakan kita guna echopembolehubah -> $siapa_saya1) echo ' $siapa_saya'2) echo " $siapa_saya"3) echo ' '.$siapa_saya.' '4) echo " ".$siapa_saya." "cuba ko masukkan $siapa_saya =' said's ';mesti keluar error cara nak setel macam ni aje $siapa_saya =' said\'s ';tapi leceh laa, tu pasal kalau boleh elak guna ' tapi pakai `nak tahu tanda ` yang ada tanda ~ juga sebelah kiri keyboard 1 & !jadi dari pandangan mata ko orang asal nampak senget sebelahdah betul laa tukalau yang tegak tu, susah nak jamin Quote Share this post Link to post Share on other sites