Jump to content
Sign in to follow this  
Followers 0
nozariza1111

Cam Ner Nak Masukkan Database..

By nozariza1111, in Pengkalan Data

Recommended Posts

muhamadnasron    0

muhamadnasron
Posted

tak kuar apape?

ayat 'Cayalah ! Data Berjaya Dimasukkan.' pon takde??

data masuk ke tak dalam db? ko dah cek db?

musykil...

kalo ko ikut molek, sure jadik... tak de masalah koding tuh.. mesti ko ada silap memana... sbb kalo error, dia akan kuar error mesej sbbb ada command mysql_error() kat situh.. ko biar betul.. first time nih page kosong jerk... ko ni.... ish....

Share this post

Link to post
Share on other sites

nozariza1111    0

nozariza1111
Posted (edited)

nie skrg kuar error nie pulak

:Parse error: parse error, unexpected '=' in c:\web\input.php on line 14

nie cth yg awk buat:

$fname = $_POST['fname'];

$lname = $_POST['lname'];

$creditcard = $_POST['creditcard'];

yg sy buat:

$no_ic =$_POST['no_ic'];<-----nielah line 14

Edited by nozariza1111

Share this post

Link to post
Share on other sites

nozariza1111    0

nozariza1111
Posted (edited)

ok..thankz kt smua yg byk bntu..yg nasron bg tu..sy dh jadi buat..x de error lg..mslh nyer skrg.. kita nak check data yg tlh d masukkan user,cthnya file view.php yg memaparkn data yg tlh dmsukkan..mslh nyer skrg mklumat yg dmasukkan user x de..hnya ada field dia aje..yg mane silap ye..arap dpt mbantu.TQ

Edited by nozariza1111

Share this post

Link to post
Share on other sites

psychoX    6

psychoX
Posted (edited)

nama kan form ni form.php

<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>

<form name="form1" method="post" action="proses.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>




</body>
</html>
kod yang ke dua namakan ia sebagai proses.php 
<?PHP
//connection ke database

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

//membaca apa yang dihantar dari form 

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

//memasukkan data ke dalam database guna perintah INSERT
$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);
?>
kalau awak pakai phptriad .. default user dia "root" dan password dia "" . oleh itu dkt connection tu nanti tinggalkan kosong ruang password 
$connection=mysql_connect("localhost","root","")or die('Pengkalan Data Tidak dapat disambung. Hubungi Pengurus Sistem !');

create database dalam phpmyadmin sebagai bayaran

lepas tu buat table nama dia user.. dalam table ada tiga field iaitu fname, lname dan creditcard

fname setkan sebagai varchar

lname setkan sebagai varchar

creditcard setkan sebagai int

try and error..

kalau data yg di masukkan tu tak de .. beerti .. perintah INSERT dan connection tu tak jalan..

Edited by psychoX

Share this post

Link to post
Share on other sites

muhamadnasron    0

muhamadnasron
Posted

mmm...aku rasa jwpn ko ni tak menepati kehendak soklan la... psycho.. ahakss....

aku rasa, minah tu dah leh insert dah.. just that dia nak wat satu page utk papar maklumat dari db dia kot....

wallahua'lam....

*quick hint:

connection dah ok...

insert statement dah ok...

so skrg just twist sikit koding tu, buat SELECT statement lak...

umpukkan data yg ko dah select tu ke dalam satu var, and then echo kan var tu dalam textbox....

nak detail, ym aku sbb susah nak explain sinih..

Share this post

Link to post
Share on other sites

psychoX    6

psychoX
Posted

ok cam ni nasron .. aku dah test script tu.. mmg dah ok. dan kuar

Cayalah ! Data Berjaya Dimasukkan.

aku hairan napa nor kuar kan kenyataan

"sy dah blh insert data tp bila sy check...data tu x ada yg ada cuma field dia..nak buat mcmne tu.."

tu aku balik umah .. aku testing script tu balik dan connect ke db balik guna phptriad.. ok je.. data masuk dalam field..

mungkin nor bleh guna kut script tu .. cut paste. atau bandingkan ngan script yang nor buat... bukan ketinggalan perkembangan.. tongue.gif

Share this post

Link to post
Share on other sites

nozariza1111    0

nozariza1111
Posted

Askum...sy nak ucapkn ribuan terima kasih byk2 kat semua yg bntu sy buat sistem nie..sy dah berjaya buat dan insyaAllah x de apa2 mslh lg..Tp sy arap warga2 putera.com akan bantu sy lg..jika sy ada persoalan yer..time kasih byk2!!

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
Sign in to follow this  
Followers 0
Go To Topic Listing
×
×
  • Create New...