♫ INSERT & DELETE DATA IN DB:

write php code and save it as dbinsert.php



<?php

$dbname="databasename";

$dbc=mysql_connect("localhost","root","") or die("cannt connect to database");

$dbs=mysql_select_db($dbname,$dbc) or die("cannt select database");

$sql="insert into tablename(username,password) values('tanim4','tanimpassword4')";

mysql_query($sql) or die("error in query".$mysql_error());

?>


write php code and save it as dbdelete.php

<?php

$dbname="databasename";

$dbc=mysql_connect("localhost","root","") or die("cannt connect to database");

$dbs=mysql_select_db($dbname,$dbc) or die("cannt select database");

$sql="delete from tablename where username='tanim' ";

mysql_query($sql) or die("error, query failed".$mysql_error());

?>