php-database connection

Question

I am not able to connect my php code with the mysql database in localhost.Here is my php code:

  <? php
     echo "hi";
     $con=mysql_connect("localhost","root","*********");
     if(!$con)
     {
          die('could not connect'.mysql_error());
     }
     mysql_select_db("my_db",$con);
     mysql_query("insert into my_table(firstname,idnumber) values ('$_post[firstname]','$_post[idnumber]')");
     echo "'hi ur name is ('$_post[firstname]')";
     mysql_close($con);
     ?>

What should i do? and also when i am running the php code it is also not echoing the "hi" statement {echo "hi"}. Is that a connection problem?

I got the result. Now whenever am entering the data in the form,the table shows a row is updated but the fields have 0..not the entered data.

Also, google for 'sql injection' - your code is vulnerable to it and you'd might as well learn to avoid issues like these. — Repox
– Repox, Commented Oct 24, 2011 at 6:57
As an aside also consider using PDO instead. You get a lot for free if you use them. — Devraj
– Devraj, Commented Oct 24, 2011 at 6:58
i just installed sql.I have no idea about PDO and 'sql injection'. Will they solve the connection problem? — sd1517
– sd1517, Commented Oct 24, 2011 at 7:09

KV Prajapati · Accepted Answer · 2011-10-24 07:14:45Z

3

<?php  //No space between ? and php

?>

Try,

<?php

 $con=mysql_connect("localhost","root","*********") or die(mysql_error());
 mysql_select_db("my_db",$con) or die(mysql_error());

 $result=mysql_query("insert into my_table (firstname,idnumber) values ('$_post[firstname]','$_post[idnumber]')");
 if($result)
    //success
 else
    //not success
?>

edited Oct 24, 2011 at 7:14

answered Oct 24, 2011 at 6:53

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Luchian Grigore Over a year ago

That was the answer I was just about to give, but I refreshed the page right before :)

Chali · Accepted Answer · 2011-10-24 06:56:02Z

0

please check

short_open_tag = On in your php.ini

answered Oct 24, 2011 at 6:56

Chali

1,1083 gold badges12 silver badges18 bronze badges

4 Comments

sd1517 Over a year ago

it was off. I chnaged it to on state.What is this usually used for?

Chali Over a year ago

when you make in "ON" you can use short tags like <? ?> and if it is OFF you have to write php tags in full tags like follows <?php ?>

Chali Over a year ago

just noticed in your code <? php there is a space between <? and php it cound be fatal error when runs on apache

sd1517 Over a year ago

That i just rectified.But same problem still prevails.

chandoo · Accepted Answer · 2011-10-24 07:35:36Z

0

if you running on xampp. just weather your engine is running mysql or not, and check the syntax to be more clear Ex: mysql_query("insert into my_table(firstname,idnumber) values ('". $_post['firstname']."','.".$_post[idnumber]."')");

Like this.

answered Oct 24, 2011 at 7:35

chandoo

1,3382 gold badges21 silver badges34 bronze badges

Comments

NeoStar · Accepted Answer · 2011-10-24 08:10:13Z

0

Try<?php echo "Hello"?>, If this wont print hello then there is a problem with your PHP installed in your local machine. Also try this

<? php
 $con=mysql_connect("localhost","root","*********")  or die(mysql_error());
 if(!$con)
 {
      die('could not connect'.mysql_error());
 }
 mysql_select_db("my_db",$con);
 mysql_query("insert into my_table(firstname,idnumber) values ('Name','12')") or die(mysql_error());
 mysql_close($con);
 ?>

The above code should insert Name and id into your database table.

answered Oct 24, 2011 at 8:10

NeoStar

357 bronze badges

2 Comments

sd1517 Over a year ago

I guess there is a configuration issue.It is not echoing any string.Can you suggest me what to deal with that.

NeoStar Over a year ago

Well did it echo hello when u tried <?php echo "Hello"?>?? If not reinstall php

Collectives™ on Stack Overflow

php-database connection

4 Answers 4

1 Comment

4 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

4 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related