How to Connect and Insert Record to MYSQL using PHP?
Answer Posted / 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 |
Post New Answer View All Answers
What is 301 redirects in php? When are we used 301 redirects in our projects?
can we pass variable in array to traverse it?
Given a string=”me,I,myself”; .Using javascript only create an array out of this string and then send a POST request to the url “record.php” without reloading the page. The post key parameters should be n1,n2 and n3 respectively.
what is main difference between array_push and array_pop?
How can i know that how many user are visited to my page in php?
Is there any way to open notepad within php?
How can get all database name using Php and Sql?
How can call any javascript function without saying onclick, onchange, onblur etc events in php?
What is the best way to make wordpress plugin
Which keyword is alias for count keyword in php?
Given a string=”me,I,myself”; .Using javascript only create an array out of this string and then send a POST request to the url “record.php” without reloading the page. The post key parameters should be n1,n2 and n3 respectively.
Which framework is best in php among Smarty, Cakephp, Joomla, Drupal, Zend or Something else...? If any then Why?
I am attempting to work on a game panel with multi-server support, so in one of the pages there is a dropdown menu with servers on it, this is the part i am having issues with is server 1 is chosen i need access to the username running a script to server 1 chosen i need a script that will realize its been chosen and pop up below with a username thats associated with it because the users differ on each server so i choose server 1 i need a code to pull from the db and choose the user associated with the said server please help..
How can export database using php code?
How can manage theme in php?