ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
   
 
Categories  >>  Code Snippets  >>  Scripts_Markup Code  >>  PHP Code
 
 


  

 
 PHP Code interview questions  PHP Code Interview Questions
 JSP Code interview questions  JSP Code Interview Questions
 ASP Code interview questions  ASP Code Interview Questions
 CGI Perl Code interview questions  CGI Perl Code Interview Questions
 JavaScript Code interview questions  JavaScript Code Interview Questions
 VB Script Code interview questions  VB Script Code Interview Questions
 Shell Script Code interview questions  Shell Script Code Interview Questions
 Python Code interview questions  Python Code Interview Questions
 WinRunner Code interview questions  WinRunner Code Interview Questions
 HTML DHTML XHTML Code interview questions  HTML DHTML XHTML Code Interview Questions
 XML interview questions  XML Interview Questions
 Scripts_Markup Code AllOther interview questions  Scripts_Markup Code AllOther Interview Questions
Question 
How to Connect and Insert Record to MYSQL using PHP?
 Question Submitted By :: Solidcube
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to Connect and Insert Record to MYSQL using PHP?
Answer
# 1		 $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 ?    14 Yes 5 No
Satyajit Das
 
  Re: How to Connect and Insert Record to MYSQL using PHP?
Answer
# 2		 <?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 ?    18 Yes 7 No
Mukesh Bisht
 
 
 
  Re: How to Connect and Insert Record to MYSQL using PHP?
Answer
# 3		 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
Sudhanshu
 
  Re: How to Connect and Insert Record to MYSQL using PHP?
Answer
# 4		 <?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
Anirban Paul
 
  Re: How to Connect and Insert Record to MYSQL using PHP?
Answer
# 5		 <?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
Ra-j-an
 
  Re: How to Connect and Insert Record to MYSQL using PHP?
Answer
# 6		 <?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 ?    0 Yes 0 No
Pinal
 

 
 
 
Other PHP Code Interview Questions
 
  Question Asked @ Answers
 
How many frameworks are in php?  1
1)how i get the current system time using php?  22
If i have an array $string = array(1,2,6,2,9,6,7,3,1,2); How can i get only unique values from it? Array ( [0] => 1 [1] => 2 [2] => 6 [4] => 9 [6] => 7 [7] => 3 )  1
I have array like $array = array(1, "hello", 1, "world", "hello"); if i want the following output then how can i do this? Array ( [1] => 2 [hello] => 2 [world] => 1 ) NIIT2
What is meant by 404 errors in php? NIIT2
Which framework is best in php among Smarty, Cakephp, Joomla, Drupal, Zend or Something else...? If any then Why? Hcl1
Hi I have a dynamic dropdown reading in data from a MQSql database, I need to refresh just the dropdown (not the whole page) for any new values in the database. I am trying to use the getElementById in javascript but I have no idea how to get it to refresh. Does any one have an examples or any ideas how this can be done? Regards Srilanka_3  4
What is main difference between Cookie and Cache? NIIT3
What is used of phpinfo() function in php?  1
How to Connect and Insert Record to MYSQL using PHP?  6
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  1
How can get current system time continuously without refresh of page?  1
 
For more PHP Code Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com