Simple insert statment

Question

0.00/5 (No votes)

See more:

I am attempting to connect a mysql database to a php code. This is the first time i am using php. I have used everything i know. the following code is only to check if the connection is working well. This is a part of the code where the php code is. It is inside the easy php folder and i have a database with the name "tennis". the connection has no password.

PHP

<?php
		$con = mysql_connect("localhost","root","");
		if (!$con)die('Could not connect: ' . mysql_error());
		mysql_select_db("tennis", $con);
		mysql_query("INSERT INTO users VALUES ('user', 'password', 'Male', 'full name', 'email@yahoo.com');");
		mysql_close($con);
	?>

when i open it in chrome i don't see any row added in mysql.

Posted 2-May-12 0:04am

Neville Nazerane

Add a Solution

5 solutions

Solution 1

You should always check the return value of the mysql_ functions (e.g. mysql_select_db, mysql_query) and call mysql_error on failure (see, for instance, the code sample at mysql_select_db documentation page[^].

Posted 2-May-12 0:16am

CPallini

Updated 2-May-12 0:18am

v2

Comments

Neville Nazerane 2-May-12 7:12am

i am unable to view anything i echo so i can't test it. this php code is inside a html code.... in the head tags... but i barely see an echo at all so i dont even know if it is being called

Solution 2

PHP

mysql_query("INSERT INTO users VALUES ('user', 'password', 'Male', 'full name', 'email@yahoo.com');");

In the above line u should not use (;) in the query string check the link click .

Posted 2-May-12 0:55am

Loke.mysore

Updated 2-May-12 18:14pm

v3

Comments

Neville Nazerane 2-May-12 7:13am

i have removed it i can still not see any progress. i can't even see an echo that i set before any of this code.

Loke.mysore 2-May-12 7:19am

As mentioned in the solution 1 use the mysql_error() method get error and echo it and tell us the error.

Mohibur Rashid 2-May-12 19:37pm

Would you explain what could went wrong with ; in the sql query?

and why are you suggesting mysql_real_escape_string to support your statement?

Loke.mysore 3-May-12 0:27am

Its my mistake and sorry for that, Instead of giving link to the mysql_query i gave it to mysql_real_escape_string.
And i updated the link.

http://www.php.net/manual/en/function.mysql-query.php Its is written in this website "The query string should not end with a semicolon." now i tried with semicolon , Its working.
I think they mean that semicolon is not required because mysql_query() will not support multiple queries.

Mohibur Rashid 3-May-12 1:12am

yup, that is so :)

Solution 4

as cPallini says check your return value all the time.

C++

    $con = mysql_connect("localhost","root","");
    if (!$con)die('Could not connect: ' . mysql_error());
    mysql_select_db("tennis", $con);
    $ret=mysql_query("INSERT INTO users VALUES ('user', 'password', 'Male', 'full name', 'email@yahoo.com');",$con);
    if(!ret)
            {
             echo mysql_error($con);;
            }
            mysql_close($con);
?>

a bit suggestion if required also put the name of the fields to confirm your insertion column name

Posted 2-May-12 13:45pm

Mohibur Rashid

Solution 5

Before going to code in php try to get basic knowledge GET and POST after that create a dummy page in php with select statement and runs that before writing the query read mysql rules and syntax. Then you will get it easy to handle the output.

Never code directly from middle if new in any language.

Posted 2-May-12 18:48pm

Abhishek Banerjee (A Web Developer)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Neville Nazerane · Accepted Answer · 2012-05-02T03:46:00

Solution 3

As i said i was using easy php and i just did not know where to open the file from thats all.

Posted 2-May-12 3:46am

Neville Nazerane