Clecotech

Delete Data from Database Table in Mysql using PHP: <?php$con = mysql_connect(“localhost”,”root”,”root”);if (!$con)  {  die(‘Could not connect: ‘ . mysql_error());  }mysql_select_db(“db_name”, $con);mysql_query(“DELETE FROM Persons…

Insert Data into Database Table in MySql using PHP:<?php$con = mysql_connect(“localhost”,”root”,”root”);mysql_select_db(“db_name”, $con);mysql_query(“INSERT INTO Persons (FirstName, LastName, Age)VALUES (‘Angry’, ‘Ashu’, ’35’)”); mysql_query(“INSERT INTO Persons (FirstName,…

Create table in MySql using PHP: <?php $con = mysql_connect(“localhost”,”root”,”root”); mysql_select_db(“db_name”, $con); $sql = “CREATE TABLE Persons ( FirstName varchar(15), LastName varchar(15), Age int…

Deleting Database in MySql using PHP: <? $sql = “DROP DATABASE testDB2”; $connection = @mysql_connect(“localhost”,”rot”,”root”)or die(mysql_error()); $result = @mysql_query($sql,$connection) or die(mysql_error()); if ($result) {…

Create New Database in My Sql using PHP: <?php $sql = “CREATE database sexybabe_db”; $connection = mysql_connect(“localhost”,”root”,”root”); $query = mysql_query ($sql, $connection) or die(mysql_error());…

List Database and tables in PHP: <?php $connection = @mysql_connect(“localhost”,”root”,”root”) or die(mysql_error()); $dbs = @mysql_list_dbs($connection) or die(mysql_error()); $db_list = “<ul>”; $i = 0; while…

Establishing a Connection to MySql using PHP: <?  $connection = @mysql_connect(“localhost”, “root”, “root”) or die(mysql_error()); if($connection) { echo “Connection success!”; } ?>

Creating the Form: Start out by creating a one-field form. You can create a form to upload as many files as you like after…

Deleting Files:Be very careful when using the unlink() function because once you’ve deleted a file, it’s gone for good. Example:<?php$new_file = “e:/ashu.txt”;$success = unlink($new_file)…

Renaming Files:Like the copy() function, the rename() function just needs to know the original filename and a new filename. In this case, you’re just…