Hi, I recently created a mysql database using phpmyadmin. I then proceeded to make a form to insert data into the database, but the problem is that the form is only able to insert one record, and then if I try inserting another record, the new one is not seen in the database. There is no error messages seen in the form when entering a new record.
Heres the code for the form -
<html>
-
<head>
-
</head>
-
<center>
-
<form method="post" action="script.php">
-
<input type="hidden" name="id" value="null">
-
<table>
-
<tr><td align="left">Name</td>
-
<td><input type="text" name="name"></td>
-
</tr>
-
<tr><td align="left">Telephone</td>
-
<td><input type="text" name="telephone" size="20"></td>
-
</tr>
-
<tr><td align="left">Birthday</td>
-
<td><input type="text" name="birthday" size="20"></td>
-
</tr>
-
<tr><td colspan="2">
-
<p align="center">
-
<input type="submit" value="Enter record">
-
</td>
-
</tr>
-
</table>
-
</form>
-
</center>
-
</html>
-
And Heres the code for the php script -
<?
-
$DBhost = "localhost";
-
$DBuser = "username";
-
$DBpass = "password";
-
$DBName = "database name";
-
$table = "table name";
-
-
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");
-
-
@mysql_select_db("$DBName") or die("Unable to select database $DBName");
-
-
$sqlquery = "INSERT INTO $table VALUES('$id','$name','$telephone','$birthday')";
-
-
$results = mysql_query($sqlquery);
-
-
mysql_close();
-
-
print "<html><body><center>";
-
print "<p>You have just entered this record<p>";
-
print "Name : $name<br>";
-
print "Telephone : $telephone<br>";
-
print "Birthday :$birthday";
-
print "</body></html>";
-
?>
5  2002 
$sqlquery = "INSERT INTO $table VALUES('$id','$name','$telephone','$birthday')";
Did you create a $_POST Array to Collect the VALUES? I didn't see it on the Script.php.
No I did not use an array in this case, but instead submitted each value individually.
No I did not use an array in this case, but instead submitted each value individually.
Change your results line to - $results =mysql_query($sqlquery) or die("Error : ".mysql_error());
Also don't forget to make use of the poor man's debugger( echo, printf, or whatever you call those things in PHP).
No I did not use an array in this case, but instead submitted each value individually.
Please you may better to read here.
Get the HTML form elements to variables. I think Now you might know what is $_POST.
- $name=$_POST['name'];
-
$telephone=$_POST['telephone'];
-
$birthday=$_POST['birthday'];
Pass The varibales to the MySQL Queary String. - $sqlquery = "INSERT INTO sample_table (name,telephone,birthday)
-
VALUES (
-
'$name', '$telephone', '$birthday'
-
);";
-
I didn't add the id formelement (may be it is the PK of your Table Structure). Actually value for that, has set up as Null. Still Only a String value. Its not same as the NULL on MySQL.
How is your Table Structure goes?
Your id column must be declared with auto_increment property. If u dont want to add id to your db by manually..
Kind Regards...
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Greg Ofiesh |
last post by:
Anyone who can help,
I have two tables T1 and T2. T1 has fields K1 and F2 and T2 has fields
K2 and F1. F1 is the foreign key relating to K1 and F2 is the foreign
key relating to K2.
My...
|
by: Chris Dixon |
last post by:
I am using a SQL Server 7 databaes with an Access 2000 front-end.
I have a form where after the user inserts a record the screen
refreshes to display a completely different record (without any...
|
by: veerapureddy |
last post by:
Hai everybody,
i like to insert some records into database from html form by entering data.my problem is how can i check , whether a record is available in database about a particular...
|
by: dav3 |
last post by:
Alright folks I am in need of a lil guidance/assistance here. I have a program which reads in a txt file. This txt file contains lines of the form
January 3, 2007, 85.8
Now each line of the txt...
|
by: Question123 |
last post by:
Hi
i have one database table Table1.which contains almost 20000000 recordes.
record to this table are inserted through storedprocedure. storedprocedure takes parameter as
"value",
Beginningdate,...
|
by: jmartmem |
last post by:
Greetings,
I have an ASP page with a 5x5 table embedded inside an Insert Record Form. This table contains several fields (mostly drop down list menus) and is used for corporate timekeeping (users...
|
by: AlexanderDeLarge |
last post by:
Hi!
I got a problem that's driving me crazy and I'm desperately in need of help.
I'll explain my scenario:
I'm doing a database driven site for a band, I got these tables for their discography...
|
by: rando1000 |
last post by:
Okay, here's my situation. I need to loop through a file, inserting records based on a number field (in order) and if the character in a certain field = "##", I need to insert a blank record.
...
|
by: javediq143 |
last post by:
Hi All,
This is my first post in this forum. I'm developing a CMS for my latest website. This CMS is also in PhP & MySQL. I'm done with the ADD section where the Admin can INSERT new records in...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
