My First PHP didn't work!

maman · #1 (**permalink**) 22-10-2004, 04:26 PM

File 1

<HTML>
<BODY>
<form method="post" action="datain.php">
First name:<input type="Text" name="first"><br>
Last name:<input type="Text" name="last"><br>
Nick Name:<input type="Text" name="nickname"><br>
E-mail:<input type="Text" name="email"><br>
Salary:<input type="Text" name="salary"><br>
<input type="Submit" name="submit" value="Enter information">
</form>
</HTML>

File 2

<HTML>
<?php
$db = mysql_connect("localhost", "root","");
mysql_select_db("learndb",$db);
$sql = "INSERT INTO personnel (firstname, lastname, nick, email, salary)
VALUES ('$first','$last','$nickname','$email','$salary')" ;
$result = mysql_query($sql);
echo "Thank you! Information entered.\n";
?>
</HTML>

Why the mysql didn't add row?
It that is becoz i am using phpdev for installing phpmyadmin & apache?

pls advise

lcf · #2 (**permalink**) 22-10-2004, 05:49 PM

your first PHP is so complex.

Do you get any error message? Make sure the database is connected.

Also, your PHP file does not grab the input value at all. Please refer to "PHP Manual - Variables from outsite PHP" [ http://my2.php.net/variables.external ]

Also your SQL query is not correct, try to replace this line:

PHP Code:


			
$sql = "INSERT INTO personnel (firstname, lastname, nick, email, salary)

VALUES ('$first','$last','$nickname','$email','$salary')";

With this line:

PHP Code:


			
$sql = "INSERT INTO personnel (firstname, lastname, nick, email, salary)

VALUES ('" . $first . "','" . $last . "','" . $nickname . "','" . $email ."','" . $salary . "')";

Hope this helps.

infeeneetee · #3 (**permalink**) 22-10-2004, 09:31 PM

please paste the errors here...

mysticmind · #4 (**permalink**) 22-10-2004, 11:06 PM

aku rasa ini mungkin ada kaitan dengan php register globaf = off.
sebab versi terkini register global tuh off by default!.

try test paparkan data dalam bentuk biasa saja dulu...
echo "$first $last $nickname";

kalau output dari form tuh tak berjaya keluar.. so cubalah test :
$satu = $_POST['first'];
baru gunakan var dia..

aku pun rasa susah lepas register global nih off.. bila aku enablekan semula dalam php ini.. aku pikir2 better aku start learn semula dengan register global off

infeeneetee · #5 (**permalink**) 22-10-2004, 11:54 PM

hah ado kemungkinan

Gemp-X · #6 (**permalink**) 23-10-2004, 01:07 AM

lebih selamat kita guna $_POST array nih, pergantungan kepada register global akan memudahkan penggodam menjalankan aktiviti

sebelum masukkan data dalam mysql, jangan lupa escape string tu dulu menggunakan addslashes($string), atau pun mysql_escape_string($string)

Gemp-X · #7 (**permalink**) 23-10-2004, 01:12 AM

cara yang boleh dilakukan, sekiranya register global on,kalo kita malas nak buat

PHP Code:


			
$nama=$_POST['nama'];

$email=$_POST['email'];

kita boleh guna "variable variable"
letak kod ni kat ataaas skali..

PHP Code:


			
foreach ($_POST as $key => $value){

$$key = $value;

}

Khairul_Izwan · #8 (**permalink**) 26-10-2004, 09:59 AM

raser macam taq tue tak betul...sebab <html> tak boleh ada sebelum php taq..kena ader selepas....kiranya macam nie ler....

<?
echo "hai.";
?>

<html>
<head>
........

lcf · #9 (**permalink**) 27-10-2004, 02:30 AM

PHP code can be any where in the page. But a good programming practise is put all php code above HTML code.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How come he doesn't have to work???	RB388	Member Introductions	14	10-01-2007 11:53 PM
check my work	punithan	Websites Review and Suggestion	6	29-06-2005 07:20 PM
Don't want to pay to work at home?	gold2006	Job Vacancies	1	08-04-2005 03:03 PM
Will this tips work?	List	Mamak Stall	6	18-10-2004 02:09 AM
How this work ???	koisempoi	Website Programming	4	04-06-2004 04:31 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)