Skip to main content

Insert records to database using PHP

Today i am going to write a program to Insert records into the table in Database.

<?php

 $conn =mysqli_connect('servername','username','password','databasename');

 if(!$conn)
{
 die('Connection failed!'.mysqli_error($conn));
 }
$sql = "INSERT INTO tablename('sno','name','pwd') VALUES('101','Richy','Richy123')";
 
 if(mysqli_query($conn,$sql))

echo "Record Inserted";
 }
else

echo mysql_error();
}
?>
------------------------------------------------------------- Note: When we using XAMPP or WAMP, servername = localhost, username = root, password is empty.

Comments

Popular posts from this blog

PHP program to convert word to digit

<?php function word_digit($word) {     $warr = explode(';',$word);     $result = '';     foreach($warr as $value){         switch(trim($value)){             case 'zero':                 $result .= '0';                 break;             case 'one':                 $result .= '1';                 break;             case 'two':                 $result .= '2'; ...

PHP script to delete a specific value from an array using array_filter() function

< ?php $colors = array('key1' => 'Red', 'key2' => 'Green', 'key3' => 'Black'); $given_value = 'Black'; print_r($colors); $new_filtered_array = array_filter($colors, function ($element) use ($given_value) {      return ($element != $given_value); }       print_r($filtered_array);       print_r($new_filtered_array); ?>