Cam Ner Nak Masukkan Database..

nozariza1111 · September 28, 2004

AKUM..sy nak mnta tlg sgt..kpd mrk yg dpt bntu,bntulah sy.cam ner nak masukkan database yang siap dicreate dlm phpmyadmin ke dlm dreamweaver.sy kna buat sist.pdaftrn pelajar praktikal scra online.sy dh buntu..tlg sy..time kasihh.

putra · October 3, 2004

Saya rasa awak nak link kan database tu ngan skrip awak yg pakai dreamweaver tu ek..

Ni contoh nye.. ni fail connect_db.php saya.

#######

<html>

<head>

<title>Connect To The Database</title>

</head>

<?php

$dbcnx = @mysql_connect("localhost","root","");

if(!mysql_select_db("UPEN"))

{

echo("<p>Unable To Locate to The Putra Database at This Time.<p>");

exit();

}

else

{

echo("<p>Success To Connect to The Database Putra.<p>");

}

?>

</body>

</html>

######

kat atas tu skrip nak tgk ader ke conection ngan database.. kalau kat atas database saya nama UPEN..

nozariza1111 · October 7, 2004

Time kasih kat putra..nnti sy cuba buat.klau ada apa2 nnti sy tnya lg lehh...

nozariza1111 · October 7, 2004

sy dah cuba buat mcm kode awk 2...tp x success.maknanya x der connection lah ngn database sy tu yerr...mcm ner tuu

badai_707 · October 8, 2004

ko guna java ke php?aku cadangkan ko guna jer phpmaker. ko up apache dl, than install php maker.. senang jer nak link phpmaker ngan phpmyadmin guna interface.ko edit la interface n coding guna dreamveawer or frontpage..siap untuk dihidangkan..

muhamadnasron · October 8, 2004

aku rasa si badai ni dah salah paham...

si noraniza nih dah create siap2 db.. just nak link db from dreamweaver jerk.. tak gitu...

kalu nak diikutkan, dah betul la koding si putra nuuu...

maybe ko tak define site dlm dreamweaver tuh kot...

ko pakai dw version apa?

kalu mx, leh dapat connection terus tak from dw masa ko define tuh?

badai_707 · October 8, 2004

hehe, aku salah faham ker..sori la terkonpius

muhamadnasron · October 8, 2004

lupa nak tanya.. kalu ko wat cam koding si putra tu, ada tak dia echo apape? ada tak dia print apape kat page ko? maksud aku, koding dia tuh akan print status kat page ko samada dapat connect or not.... kalu takde apape print/echo, maknanya mmg takde la tuh....

wallahua'lam..

nozariza1111 · October 9, 2004

TQ kat badai n nasron..mjurlah nasron ada bgthu kat badai yg dia 2 dh slh fhm..iza cuma nak link jer skrg nie..

iza buat koding putra tu,keluar print status:

Unable To Locate to The borang_praktikal Database at This Time.

camne tu..iza mmg guna dreamweaver MX..nak define site tu cam ne lak..srrylah byk btnya..

Edited October 9, 2004 by nozariza1111

muhamadnasron · October 9, 2004

cit.. kat putra ko tak cakap tq lak... hahahaha..... apa la ko nih.. pilih bulu ke..

nozariza1111 · October 9, 2004

apalah awk nie..nasron.x nmpak ke kat ats..awal2 lg sy dh ucap thankz utk putra tau..awk je yg x nmpak..x baik tau kate kat sy cam tu..x caya tgk lah kat ats 2..

nozariza1111 · October 9, 2004

so..cam ner sy nak connection database tu..tlglah sy..

muhamadnasron · October 9, 2004

jap.. tgh wat tutor utk ko nih..

nozariza1111 · October 9, 2004

ok..skrg dah success dah connection database.maknanya dah ada connectionlah..mslh skrg cam ne nak paparkan database pulak bila user dah masukkan data.

nozariza1111 · October 12, 2004

sape2 leh tlg tak..sy dah buat interface utk user masukkan data..bila user tekan'hantar'..cam ne nak biar data yg dhantar tu,disimpan ke tmpat utk admin check..utk admin check data dah ada..

melayujb · October 12, 2004

Saya ingin minta bantuan anda semua..ada sesapa yang tau

Sejarah database / pengkalan data?

Apa software itu bina database?

Apa kebaikan dan kekurangan database?

melayujb · October 12, 2004

Tolong email saya secepat mungkin atau call 013-6962290 plssssssss

nozariza1111 · October 12, 2004

ai..melayujb..ala internet kn luas..carilah.

muhamadnasron · October 12, 2004

sape2 leh tlg tak..sy dah buat interface utk user masukkan data..bila user tekan'hantar'..cam ne nak biar data yg dhantar tu,disimpan ke tmpat utk admin check..utk admin check data dah ada..
←

alahai.. aku tak paham la plak mende yg ko nak ni.... simpan utk admin check??

admin check data dah ada??

penin la aku...

tp.. kalo ko nak tau data masuk or not, ko pakai la third party software for mysql.. leh edit data realtime... cth : mysql-front

nozariza1111 · October 13, 2004

Ala..srrylah.pening pulak c nasron nie..cam nie sy dah buat interface utk user masukkan data..selepas user tekan 'hantar'..macammane kode dia nak dia terus tersimpan kat tempt simpanan data...

muhamadnasron · October 14, 2004

ooo.. nak masuk dalam db... hmmm. fisrt establish connection.... then, wat sql command lah...

camni cthnue :

<?PHP
$connection=mysql_connect("localhost","root","pwdAku")or die('Pengkalan Data Tidak dapat disambung. Hubungi Pengurus Sistem !');
$db=mysql_select_db("bayaran",$connection)or die(mysql_error());
?>
<?PHP

$fname  = $_POST['fname'];
$lname  = $_POST['lname'];
$creditcard                = $_POST['creditcard'];


$sql= "INSERT INTO user (fname,lname,creditcard) VALUES ('$fname','$lname', '$creditcard')";
$sql_result=mysql_query($sql,$connection)or die(mysql_error());
echo('Cayalah ! Data Berjaya Dimasukkan.');
mysql_close($connection);
?>

ok... sebenarnya, code ni kene latak kat page slps kita klik "hantar" pada page sblm ni... kat page ni baru kita wat insert statment....

fname, lname dan creditcard tuh adalah nama txtbox pada form page sblm nih... ok ke? paham?

wallahua'lam

nozariza1111 · October 18, 2004

x brpa nak fhmlah nasron..code 2 nak ltak kat page lainlah yer..cthnya sy buat kode utk user masukkan data dlm file index.html,jd utk code yg awk kasi tu letak dlm file input.php lah yer..gi2 ke..sy nak try buat nie..

psychoX · October 18, 2004

Kod sebelum tu yang ada form tu.. 


<form name="form1" method="post" action="nasron.php">
  <p>
    <input type="text" name="fname">
  </p>
  <p> 
    <input type="text" name="lname">
  </p>
  <p> 
    <input type="text" name="creditcard">
  </p>
  <p>&nbsp;</p>
  <p>
    <input type="submit" name="Submit" value="Submit">
  </p>
  <p>&nbsp; </p>
</form>

pastu baru di ikuti proses oleh fail nasron.php . rujuk jawapan sedara nasron tu..

muhamadnasron · October 19, 2004

haa...thanks psychoX... cam tu la...

kat page user keyin info tuh, ko guna yg psychox bg tuh... pastu action dia ko panggil fail nasron.php .... kat fail nasron.php tuh, ko letak la command sql insert yg aku bg kat atas tuh...

ni cara yg mudah.. pakai 2 page.. ada satu lagi cara yg agak "kompleks" sikit... pakai self.. takyah panggil fail lain.. tp wat masa nih, ko pakai yg ni dulu.. once ko dah leh grab yg ni, bgtau, kitorang yg lain leh ajar yg advance tu punya.. lagi simple keje ko jadik...

ok.. wallahua'lam

nozariza1111 · October 19, 2004

thankz psyhoX n nasron..sy dh buat 2 page mcm korg ajar..tp bila user masukkan data n klik 'hantar'..x kuar apa pun..page tu kosong aje..

Edited October 19, 2004 by nozariza1111

Sign In

Cam Ner Nak Masukkan Database..

Recommended Posts

nozariza1111 0

Share this post

Link to post

Share on other sites

putra 1

Share this post

Link to post

Share on other sites

nozariza1111 0

Share this post

Link to post

Share on other sites

nozariza1111 0

Share this post

Link to post

Share on other sites

badai_707 0

Share this post

Link to post

Share on other sites

muhamadnasron 0

Share this post

Link to post

Share on other sites

badai_707 0

Share this post

Link to post

Share on other sites

muhamadnasron 0

Share this post

Link to post

Share on other sites

nozariza1111 0

Share this post

Link to post

Share on other sites

muhamadnasron 0

Share this post

Link to post

Share on other sites

nozariza1111 0

Share this post

Link to post

Share on other sites

nozariza1111 0

Share this post

Link to post

Share on other sites

muhamadnasron 0

Share this post

Link to post

Share on other sites

nozariza1111 0

Share this post

Link to post

Share on other sites

nozariza1111 0

Share this post

Link to post

Share on other sites

melayujb 0

Share this post

Link to post

Share on other sites

melayujb 0

Share this post

Link to post

Share on other sites

nozariza1111 0

Share this post

Link to post

Share on other sites

muhamadnasron 0

Share this post

Link to post

Share on other sites

nozariza1111 0