Interested to Buy Any Domain ? << Click Here >> for more details...
How to Connect and Insert Record to MYSQL using PHP?
- 6 Answers
- 15730 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mukesh bisht
<?php
//var_dump($_POST);
//die();
$link=mysql_connect("localhost","root","");
$db=mysql_select_db("emp",$link);
$id=$_POST['id'];
$name=$_POST['name'];
$age=$_POST['age'];
$phone=$_POST['phone'];
$salary=$_POST['salary'];
$address=$_POST['address'];
$query="insert into db(id,name,age,phone,salary,address)
values
('".$id."','".$name."','".$age."','".$phone."','".$salary."'
,'".$address."')";
//echo $query;
mysql_query($query);
echo "<B></B>DATA ADDED SUCCESSFULLY<B></B>";
?>
| Is This Answer Correct ? | 22 Yes | 8 No |
Answer / satyajit das
$conn = mysql_connect("localhost","root","");
mysql_select_db("database_name",$conn); // Connection....
if($hh){
$res = mysql_query("insert into `table`(`all
paramaeters of table`)values('','','')");
}
$res1 = mysql_query("select * from `table`");
// Insert Module....
| Is This Answer Correct ? | 16 Yes | 6 No |
Answer / pinal
<?php
$Con = mysql_connect("$vHostName","$vUserName","$vPassword");
if(!$Con ) {
die("<html><script language = 'Javascript'>alert('unable
to connecet to the db ... bcause'". mysql_error().
")</script></html>");
}
mysql_select_db("$dbName",$Con);
?>
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sudhanshu
To
Connect="$dblink=mysql_connect("127.0.0.1","mediamagick","mediamagick");
$db_conn=mysql_select_db("mediamagick_italy",$dblink)or
die("could not connect");"
And To Insert = "Select (Field Names) values (values to
insert )";
| Is This Answer Correct ? | 4 Yes | 5 No |
Answer / anirban paul
<?php
->connection parts-------
mysql_connect("<webser-name>","user-name","password-name");
mysql_select_db("<database-name>");
->insertion parts--------
$r=mysql_query("insert into <table-name> values(fild
name)");
if($r)
{
print "<h1>insert successfully";
}
else
{
print"<h1>insert not successfully";
}
| Is This Answer Correct ? | 3 Yes | 6 No |
Answer / ra-j-an
<?php
$dbCon = mysql_connect("$vHostName","$vUserName","$vPassword");
if(!$dbCon ) {
die("<html><script language = 'Javascript'>alert('unable
to connecet to the db ... bcause'". mysql_error().
")</script></html>");
}
mysql_select_db("$dbName",$dbCon);
?>
| Is This Answer Correct ? | 2 Yes | 5 No |
hi sir actually i use now day's ajax but i m having problem my opinion i thing this code is right becuse i make code for my side validation with ajax in php so but it is not run complete i m posting my code pls confirm and clear my some mistake and return send me with informatiom what was error so next time i will be care fully so i m sending u but replay so quick because tomorrow i have to present it some where,frist one is index.php and second is show.php show.php is database connectivity for testing
What is used of serialize and unserialize in php?
what is main difference between array_push and array_pop?
How can get current system time continuously without refresh of page?
What is used of phpinfo() function in php?
how to validation ajax in php with database actually i use here it give some time erroe so pls tell how to do right and second think is that textfeild phone number it accept only int value not charecter so tell me both and my code is that so check it then send after correction
How can restrict user to type upto 8 characters in textbox in php?
Hey, any expert here can help me to creat php code. I want php code to calculate like below. input :12 April 1974 then perform this calculation: 12 + 4 + 1974 = 1990 1 + 9 + 9 + 0 = 19 1 + 9 = 10 1 + 0 = 1(final answer) this code i just want to used to share the personality from date of birth. The input come from user, base on user input, then php will calculate like above, and, the final answer will use do display the person attitude. example, final answer = 1, display patient person final answer = 2, will display hard working person
How can get all database name using Php and Sql?
What is difference between ksort and krsort in php?
How to Connect and Insert Record to MYSQL using PHP?
Is there any way to open notepad within php?
PHP Code 
