Inserting Data Into a MySQL Database using PHP

Good post for those new to php/mysql. Glad to see regular posts after a long inactivity. Please continue posting regularly if not frequently.

Hello there.
Just found your site. Great job!
I like it much.
look here http://live.com

Hello
Just found your site. !
I like it and thanks .

nice tutorial

Here is my code:
when ran, it gives the error “error updating database”
Please help!!

html file
————–
Members Search

Enter Member Information:
ID:

First Name:

Last Name:

Phone Number:

Php file
————-
$fname = $_POST['FirstName'];
$lname = $_POST['LastName'];
$phone = $_POST['PhoneNumber'];

mysql_connect(“localhost”, “bookorama”, “bookorama123″) or die (‘Error: no db connection ‘ . mysql_error());
mysql_select_db(“test”);

$query=”INSERT INTO members (id, firstname, lname, phone)VALUES (‘NULL’, ‘”.$fname.”‘, ‘”.$lname.”‘, ‘”.$phone.”‘)”;
mysql_query($query) or die (‘error updating database’);
echo “database was updated with: ” .$fname.” “.$lname.” “.$phone;

// close connection
mysql_close();

@John
the error is :
error updating database

hi!
when i submit the form a blank page appear and nothing is being updated in mysql database,where could i be wrong

thanx!

keep getting error database not updated, any suggestions?
Here’s my code, seems right?

Nice code.
It works very well.

Great article, one more thing can u plz show me how to use a login form to get data from mysql…. would be of immense help….thanx yet again…!

Where can i download the whole code?????

I am trying this out and getting a blank page too. My form is at:

http://www.tccnotary.com/newclients.php

Right now my script is only attempting to write the submitted order date (the first field) to the database. Once I know that works I can work on the other fields. My script, insert.php, is:

Anyone? Anyone?

All the helpers appear to have left.

Do you mean Martijn’s code or my code? Or both?

Please can you kindly send the query for insserting into the database using php? because i tried the one written here but the report that I got was that there was an error in line 7 which I tried all tha I could but it still dosent work.

Please is there a web site or page that I can download the whole code????????????????????????

Please take a good look at this query that I wrote.

Is there anything missing?? Yet I still recieve this (Parse error: parse error, unexpected ‘;’ in C:\wamp\www\root\update.php on line 7).

Please I need your help Here …thanks so Far

very nice and useful example gud work keep it up …

I cannot seem to get the database to update or post. Please Help. Here’s my code.

[
<?php
//Verrify Session
session_start();
if(!session_is_registered(myusername)){
header("location:index.php?id=accessdenied");
}

// Rest of Page
require_once ("functions.php");
connect();
mysql_select_db("news")or die("cannot select DB");

// Table Selection - Via URL
$table = $_GET['table'];

// Defining The Form Data
$form_subject = $_GET['subject'];
$form_date = $_GET['date'];
$form_column = $_GET['column'];
$form_preview_post = $_GET['preview_post'];
$form_full_post = $_GET['full_post'];

// Defining Who It Was Posted By
$session_name = $_SESSION['myusername'];

$sql=”INSERT INTO `$table`(`subject`, `date`, `category`, `preview`, `post`)VALUES(`$form_subject`, `$form_date`, `$form_column`, `$form_preview_post`, `$form_full_post`)”;
mysql_db_query($sql);

/*
if($result){
echo “Successful”;
echo “”;
echo “Back to main page“;
}
else {
echo “ERROR”;
}*/
?>
]

Hey I am having the same problem as Amir, I keep getting the “die” message “error updating database”.

I’m guessing mismatched column names with the database? but I’ve double checked about a zillion times lol. sorry to be a pain…

Thanks for your help.

hi..thanks for the code..while i m clicking on ‘Update database’ button, the output is
$Fname=$_Post['Fname']; $Lname=$_POST[['Lname']; mysql_connect(“localhost”,”abcd”,”1234″) or die(‘Error’ .mysql_error()); mysql_select_db(“test1″); $query=”INSERT INTO test1(ID,Fname,Lname) VALUES (‘NULL’,'”.$Fname.”‘, ‘”.$LName”)”; mysql_query($query)or die (‘Error updating database’); echo “Database Updated with: “.Fname.” “.LName.; mysql_close();

My code for update.php( i m using the same code as mentioned above: -

Untitled Document

$Fname=$_Post['Fname'];
$Lname=$_POST[['Lname'];
mysql_connect(“localhost”,”abcd”,”1234″) or die(‘Error’ .mysql_error());
mysql_select_db(“test1″);
$query=”INSERT INTO test1(ID,Fname,Lname) VALUES (‘NULL’,'”.$Fname.”‘, ‘”.$LName”)”;
mysql_query($query)or die (‘Error updating database’);

echo “Database Updated with: “.Fname.” “.LName.;
mysql_close();

hey there!

everything was working proper until the update.php part or the 3rd part!

it works half way thou,

it send info to the info to the server, but only the field, not the info shows either on the server or in the update.php
example name: john

on my server and .php file will show name: “empty or blank”

that start to happen i was trying to fix the update.php file, i went to server and add two more names as in the beginning of the tutorial and then when i used the database.php file to see if updates the only filed showing was the phone number , first and last name was “black”

what went wrong?

update

Hey John,

thankx so much! it works perfectly now,
just for future developers i will add this,
my code wasnt working first, instead
POST
i typed
post

second!
on my form.php i mistyped again,
instead PHON i typed FHON;

problem solved now! thanks John code is great!
now moving to Log in part…hehe

I did this, but i get

No Database Selected. as my error.

What could the problem be? I have checked my PHPmyAdmin and the correct db_xxxxx is there, as is the table.

I checked the process log in phpmyadmin as well, and it shows database ‘none’ in the ‘Kill’ process.

Hi Guys, Great tutorial, however keep coming up with an error:

The following is for update.php but i have used filename newcustomer.php
Parse error: parse error on line 11 (begins with $query=”INSERT INTO)

Hi Guys, I need a little help.

I am trying to do something “simple” that is collect emails for an e-bulletin signup with the form post method in flash to write to a mysql database using php.

MYSQL version is 5.0.32
PHP Version is 5.2.6
I am using Action Script 2.0 in Flash

Here is my php:

And here is my actionscript:

function sendEmail(email)
{
var _loc1 = new LoadVars();
_loc1.email = email;
_loc1.onLoad = function (ok)
{
submit_btn.enabled = true;
};
_loc1.sendAndLoad(“http://realityla.com/form.php”, _loc1, “POST”);
gotoAndStop(2);
} // End of the function
stop ();
userPath = email_txt;
userPath.onSetFocus = function ()
{
userPath.text = “”;
};
submit_btn.onRelease = function ()
{
indexOfAt = email_txt.text.indexOf(“@”);
lastIndexOfDot = email_txt.text.lastIndexOf(“.”);
if (indexOfAt != -1 && lastIndexOfDot != -1)
{
if (lastIndexOfDot < indexOfAt)
{
message.text = “please verify your email.”;
}
else
{
var _loc2 = email_txt.text;
this.enabled = false;
sendEmail(_loc2);
} // end else if
}
else
{
message.text = “please enter correct email address”;
} // end else if
};

MYSQL version is 5.0.32
PHP Version is 5.2.6
I am using Action Script 2.0 in Flash

Maybe I am just tired, but it’s not working. Help please!!!

// Connects to your Database
$host=”mysql.realityla.com”; //Host Name
$username = ”coryjames”; //mysql user name
$password =”mark1045”; //mysql password $db_name =”tms” ;//database name $tbl_name =”employee” ; //Table Name

mysql_connect(”mysql.realityla.com”, “coryjames”, “mark1045”) or die(mysql_error());
mysql_select_db(”ebulletin”) or die(mysql_error());

$email = $_POST['email'];

$query =”INSERT INTO $email (email) VALUES (‘$email’)”;

$result = mysql_query($query) or die(’Error updating database’);

if($result){
echo “successfull”;
echo “”;
}
else {
echo “ERROR”;
}
mysql_close();
?>

I’m trying to write data and time using PHP but am not having any luck. This is the code I use:

$sql = “update contacts set ” . “address=’$address’, ” . “address2= ‘$address2′,” . “city= ‘$city’,” . “state= ‘$state’,” . “zip= ‘$zip’,” . “country= ‘$country’,” . “officephone= ‘$officephone’,” . “homephone= ‘$homephone’,” . “fax = ‘$fax’” . “whensubmitted= NOW(),” . “WHERE id LIKE ‘$recordid’ “;

I get an error with the whensubmitted= NOW() command.

Can anyone help?

hi! everyone i have made a register page in php which will collect data in a form from user and store it in mysql db .My prob is that on clicking the submit button i get a blank page n a blank record is created in db .
i hav checked the code so many times but to no gud please help me iam a newbie.iam posting the code below:<?php
if(isset($_POST['user'])&&isset($_POST['pass']))
{

if(strlen($_POST['user'])<4)

echo”Username Must Be More Than 4 Characters.”;

elseif(strlen($_POST['pass'])<6)

echo”password must be more than 6 characters.”;

elseif($_POST['user']==$_POST['pass'])

echo”username and password cannot be same”;

else
{
include(“register.php”);

$firstname=$_POST['fname'];
$lastname=$_POST['lname'];
$username=mysql_real_escape_string($_POST['user']);
$password=$_POST['pass'];
$sex=$_POST['sex'];
$occupation=$_POST['occupation'];
$city=$_POST['city'];
$state=$_POST['state'];
$country=$_POST['country'];
$phno=$_POST['phno'];
$emailid=$_POST['email'];
$comment=$_POST['comment'];

$sqlcheckforduplicate=”SELECT user FROM userinfo WHERE user=’$username’;”;

if(mysql_num_rows(mysql_query($sqlcheckforduplicate))==0)
{

$sqlreguser=”INSERT INTO userinfo(firstname,lastname,user,pass,sex,occupation,city,state,country,phno,eid,comment)VALUES(‘”.$firstname.”‘,’”.$lastname.”‘,’”.$username.”‘,’”.$password.”‘,’”.$sex.”‘,’”.$occupation.”‘,’”.$city.”‘,’”.$state.”‘,’”.$country.”‘,’”.$phno.”‘,’”.$emailid.”‘,’”.$comment.”‘);”);

$query= mysql_query($sqlreguser) or die(“error in query:$sqlreguser”.mysql_error());

$dbh=”register”;
mysql_close($dbh);

echo”$query”;
if($query)
{
echo”You are Registered and can now Login”;
$formusername=$username;

header(“location:home.php”);
}
}

else
{
echo”The username you have choosen is already taken.please try another one.”;

$formusername=$username;
}

}
}

else
{
echo”You could not be registered because of missing data.”;
}
?>

Hi,

I was wondering if there is a way to merge the php code and the form into 1 single php code ? The reason why I ask is that I want to put the update dabase funtion into a php block for smf/tinyportal. Is this doable ?

Thank you ^^

Well !!!
Very good post …………….
Please please Please post it’s sequels too……….

Hi,

I have a doubt in uploading image to database and also in retriew. Plz send any example or any reference site

Thank you

very fine !

Hi – I am totally new to PHP. I am taking an on-line class and have an assignment to create a form with a customer number and current meter reading. Once the user hits ‘submit’ I add this data to my table. Problem is I am getting a “Null values not allowe in column or variable” error. There is a date field and another text field I am not filling. Do I need to put something in the other two fields? Any help would be appreciated.

the ECHO STATEMENT is WRONG………………BULL SHET!!!!!

this is the right ECHO statement just Copy and paste!

echo “Database Updated Width: “.$Fname.”,”.$Lname.”,”.$Phon;

I am also an idiot.

It didnt worked out i m still struck in inserting data in sql table using php……..

I have a table in the database which records the grades a student has scored. I need the rows from this table to be like columns on the output. Please help Iam stack.

The table is like this

Student_ID Course_code Assessment_grade End_of_semester Avg

So what i need is to take the Course_code field contents and output them as fields. and the averages to be under their respective courses.

for example

Student_ID ICT2301 ICT2302 ICT2303

BICTQW90 67 67 89

i tried about 10 sites before i could figure out what was wrong with my code. your site helped me figure it out. thx

// my code
//

have database update error too

Dears,
i need the way how to insert images & video clips into mysql database & then to retrieve the images & video clips on an html page in separate tags. Please if someone can help me please help me out.
Thankx in advance.

Thanks for the tutorial. Learned a lot! Next thing I want to learn is how to email the data from the form and at the same time put it in the database. Do you have a sample of this in php?

I’m trying to put make the date look like 2010/02/22. But this error keeps popping up.

Warning: Division by zero in /home3/oneworo2/public_html/update.php on line 5

Warning: Division by zero in /home3/oneworo2/public_html/update.php on line 5
Thank you Ricardo. One of our staff will contact you to finalize your booking on 201020. For inquiries, please note your booking reference number: . You can contact us at 00971 4 3372010.

This is the code I use.

<?php
$Name = $_POST['Name'];
$Email = $_POST['Email'];
$Phone = $_POST['Phone'];
$TourDate = $_POST['year'].”/”.$_POST_['month'].”/”.$_POST['day'];
$Adults = $_POST['Adults'];
$Children = $_POST['Children'];
$Tours = $_POST['Tours'];
$Others = $_POST['Others'];
$Comments = $_POST['Comments'];

thank you for sharing, this is just what i was looking for.

Hi! This script is excatly what i need; however, it doesn’t work for me.. i get a 500 Internal Server Error!! (i replaced all my hosting/db info with ****) here’s my save_data.php code:

<?php
$TicketID = $_POST['TicketID'];
$TicketType = $_POST['TicketType'];
$FirstName = $_POST['FirstName'];
$LastName = $_POST['LastName'];
$DateTicketBought = $_POST['DateTicketBought'];
$Location = $_POST['Location'];
$Events = $_POST['Events'];
$Arena = $_POST['Arena'];

mysqli_connect ("********", "*******", "********") or die ("Unable to connect, Sorry. Try again later.")
mysqli_select_db ("20010722009-1")

$query="INSERT INTO r2m_tickets (TicketID, FirstName, LastName, DateTicketBought, Location, Events, Arena)VALUES ('".$TicketID."', '".$FirstName."', '".$LastName."', '".$DateTicketBought."', '".$Location."', '".$Events."', '".$Arena."')";
mysqli_query($query) or die ('Error Updating Database. Try Again Later');

echo "Successful! Database updated with the following information: “.$TicketID.” “.$FirstName.” “.$LastName.” “.$DateTicketBought.” “.$Location.” “.$Events.” “.$Arena.”";
?>

Here’s my form.php code:

Update Database

Update info in Database ‘*********’, Table ‘******’

Ticket ID:

Ticket Type:

First Name:

Last Name:

Date Ticket Was Bought

Location:

Event(s):

Arena(s):

this was very helpful thanks. straight forward for a beginer like me to follow

There is an error on line 11 and after a few hours i would like someone else help please

It is vert helpful website for problem solving
thanks,

Nice tutorial!
really helped me!!
thanks a lot!!

hello

i have a student regstration in groupes
i want to ensure if that student who write his information to insert is already exist in any groupe or not
if he exist display a form of the groupes to change his groupe to any group he wants

i need your help plz

hi i did a form with select tag, which need to choose multiple options, but when i connect the php code to database the selected options were not been displayed…. the column itself is not accepted whereas othr fields get submitted. kindly help me to insert datas into database for php using tag, multiple options.I am a beginner.

Hey, John.

I followed your tutorial, and everything was perfect, however, after clicking submit nothing appears in mySQL database. A new row appears as though their SHOULD be the data there, but the tables cells are empty.. WHAAAAATTTT could possibly be making me want to vomit??? haha.. help me out, man..

heres my source:

there is a bug in your code.. i find it unprofessional.. because after i reload the page after submitting the form, the page seems to re-enter the same data into my database.. can u give me a solution? without involving session token? Thank you.

Great tutorial, thank for sharing

I get error message in my update.php as follows

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/jmbecoo4/public_html/testmysql/update.php on line 10

Can you help me please.

My program is as follows.

Table editing

i get this error PLEASE HELP !!!
Parse error: parse error, expecting `’,” or `’;” in C:\wamp\www\update.php on line 8

and here is my code:

help me out!!!!!
<?php include("dbconnect.php");
$connect=mysql_pconnect($host,$user,$password) or die (include ("error.php"));
mysql_select($data_base) or die ('cannot select data base'.mysql_error());
$name_1=addaslashes($name);
$phone_1=addaslashes($phone);
$query="INSERT INTO medisam (name,phone) VALUES ('".$name."','".$phone."')";
$result=mysql_query($query) or die (include ("error.php"));
…………………………………..
i used the code above and is not working.

it agood

Good post for those new to php/mysql. Glad to see regular posts after a long inactivity. Please continue posting regularly if not frequently.

please.I want to insert the data in my table which has a similar field as the other table of my database both tables are in the same database so I want the code which will help me to check if the data entered is the equal/the same as the other which is in the other table.
thanks

John,
this is my code and I am getting an error on the closing ?> could you help me

hello, i keep getting this error….

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\xampp\htdocs\website\update.php on line 11

line 11 is:

$query=”INSERT INTO property (idProperty, propertyName, propertyType, propertyDescription, propertyPrice, roomsAvailable) VALUES (‘”.$propid”‘, ‘”.$propname”‘, ‘”.$proptype”‘, ‘”.$propdescri”‘, ‘”.$propprice”‘, ‘”.$propavail”‘)”;

what am i doing wrong? :S
any help would be really appriciated.

This code sample and tutorial does not work. Don’t waste your time with it.

Dear All Programmar

Please help me for some command Use Bye PHP and SQL or PhpMyAdmin
I want one Table from all rows call whene i search
My command now use
case “Inbox”:
$Maddress=$_POST['Maddress'];
$bodyPanText=array(“$Maddress”);
$SQL=”select * from massage_upi where maddress=’$Maddress’ “;
$result=mysql_query($SQL,$con);
if($result):

if (mysql_num_rows):
$bodyPanText=array(“massage/massage_show.php”);

else:
$bodyPanText=array(
“Invalid user ID ; Push Carret ID”,
“”,”id_from.inc.tpl.php”);
endif;

else:
$bodyPanText=array(“Fail to execute query :”.mysql_error($con));;

endif;
break;
But when use this command this time show one rows and one information
i want when search this time all information show this table

Please Help me

With Thanks
Nurmohammad

thanks now i have to test it

Hi John and all the coders and newbies here,
i would like to know if this form could enter also together with the text, a blob entry (picture). Did someone try it? And should the “enctype” attribute of the form be changed in this case.

I am having problem in inserting data .. php show successful enty but when i go to mysql phpmyadmin ..there is no data inserted … any one can tell the problem? i have recently installed ODBC plugin for mysql

i have followed what this page instructed,but everytime i press the update i keep getting a black web page and the database does not even get updated. please help

admin.html

Category Name:
Description  :

update.php

<?php
$cat_name =$_post['cat_name'];
$cat_desc =$_post['cat_desc'];

mysql_connect ("localhost","root","babez@123") or die ('Error :'.mysql_error());
mysql_select_db("emusic");

$query="INSERT INTO tbl_category(cat_id,cat_name,cat_description,cat_image) values('Null',' .$cat_name ',' .$cat_desc ','NULL')";

mysql_query($query) or die ('Error, updating database');
echo "Database Updated With: ".$cat_name .cat_desc";
<?

Hi Friend!
Here is also a link that is related to the problem. It is step by step tutorial. easy and simple.
http://developerqueries.blogspot.com/2012/03/php-form-tutorial-stored-client.html

I just searching this kind of things in search engines. My searching was ending here. Keep up your good work. I bookmarked it for general updates.
html5 media player| youtube html5 player