{"id":179,"date":"2016-06-20T06:38:59","date_gmt":"2016-06-20T06:38:59","guid":{"rendered":"http:\/\/symbioticindia.in\/docu\/?p=179"},"modified":"2016-06-20T06:38:59","modified_gmt":"2016-06-20T06:38:59","slug":"creating-simple-crudcreate-read-update-delete-in-php","status":"publish","type":"post","link":"http:\/\/symbioticindia.in\/docu\/2016\/06\/20\/creating-simple-crudcreate-read-update-delete-in-php\/","title":{"rendered":"Creating Simple CRUD(Create , Read , Update , Delete) in php"},"content":{"rendered":"

In this tutorial we are going to discuss about simple CRUD<\/a>(Create , Read , Update , Delete)<\/b> PHP operations , these are some of the basic things of PHP web application , Records are insert , select update and delete using PHP and MySQL, Creating a Simple Insert, Select, Update and Delete using PHP with MySQL Database is easy task. learning a crud operations is the first way to understand this is a simple and easy tutorial i have posted for beginners, let’s have a look.<\/p>\n

\"Simple<\/a><\/div>\n

<\/a><\/p>\n\n\n\n
\n
Download Script<\/a><\/span><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Database Design and Table <\/strong>which are used in this tutorial
\nDatabase name : dbtuts
\nTable name : users
\nTable Columns : first_name , last_name , user_city<\/p>\n

Copy-Paste the following sql schema in your MySql database to create database and table.<\/p>\n

CREATE<\/span> DATABASE<\/span> `<\/span>dbtuts`<\/span> ;<\/span>\r\nCREATE<\/span> TABLE<\/span> `<\/span>dbtuts`<\/span>.<\/span>`<\/span>users`<\/span> (<\/span>\r\n`<\/span>user_id`<\/span> INT<\/span>(<\/span> 10<\/span> )<\/span> NOT<\/span> NULL<\/span> AUTO_INCREMENT PRIMARY<\/span> KEY<\/span> ,<\/span>\r\n`<\/span>first_name`<\/span> VARCHAR<\/span>(<\/span> 25<\/span> )<\/span> NOT<\/span> NULL<\/span> ,<\/span>\r\n`<\/span>last_name`<\/span> VARCHAR<\/span>(<\/span> 25<\/span> )<\/span> NOT<\/span> NULL<\/span> ,<\/span>\r\n`<\/span>user_city`<\/span> VARCHAR<\/span>(<\/span> 45<\/span> )<\/span> NOT<\/span> NULL<\/span>\r\n)<\/span> ENGINE<\/span> =<\/span> InnoDB<\/span>;<\/span><\/code><\/pre>\n
Database Configuration :
\ndbconfig.php<\/b><\/p>\n
<?php<\/span>\r\n$host<\/span> =<\/span> \"localhost\"<\/span>;<\/span>\r\n$user<\/span> =<\/span> \"root\"<\/span>;<\/span>\r\n$password<\/span> =<\/span> \"\"<\/span>;<\/span>\r\n$datbase<\/span> =<\/span> \"dbtuts\"<\/span>;<\/span>\r\nmysql_connect(<\/span><\/span>$host<\/span>,<\/span>$user<\/span>,<\/span>$password<\/span>)<\/span>;<\/span>\r\nmysql_select_db(<\/span><\/span>$datbase<\/span>)<\/span>;<\/span>\r\n?><\/span><\/span><\/code><\/pre>\n
 <\/p>\n
Create : Insert New Records<\/h2>\n
For providing user interface for the database insert, we should create a form, containing all the fields the users table has, except user_id which is auto generated numeric field. And, HTML code of ADD form will be as follows.
\nadd_data.php<\/b><\/p>\n
<!DOCTYPE html PUBLIC \"-\/\/W3C\/\/DTD XHTML 1.0 Transitional\/\/EN\" \"http:\/\/www.w3.org\/TR\/xhtml1\/DTD\/xhtml1-transitional.dtd\"><\/span><\/span>\r\n<<\/span>html<\/span> xmlns<\/span>=<\/span>\"<\/span>http:\/\/www.w3.org\/1999\/xhtml\"<\/span><\/span>><\/span><\/span><\/span>\r\n<<\/span>head<\/span>><\/span><\/span><\/span>\r\n<<\/span>meta<\/span> http-equiv<\/span>=<\/span>\"<\/span>Content-Type\"<\/span><\/span> content<\/span>=<\/span>\"<\/span>text\/html; charset=<\/span>utf-8\"<\/span><\/span> \/><\/span><\/span><\/span>\r\n<<\/span>title<\/span>><\/span><\/span><\/span>CRUD<\/span> Operations With PHP<\/span> and<\/span> MySql -<\/span> By Cleartuts<\/<\/span>title<\/span>><\/span><\/span><\/span>\r\n<<\/span>link<\/span> rel<\/span>=<\/span>\"<\/span>stylesheet\"<\/span><\/span> href<\/span>=<\/span>\"<\/span>style.css\"<\/span><\/span> type<\/span>=<\/span>\"<\/span>text\/css\"<\/span><\/span> \/><\/span><\/span><\/span>\r\n<\/<\/span>head<\/span>><\/span><\/span><\/span>\r\n<<\/span>body<\/span>><\/span><\/span><\/span>\r\n<<\/span>center<\/span>><\/span><\/span><\/span>\r\n\r\n<<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>header\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>content\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>label<\/span>><\/span><\/span><\/span>CRUD<\/span> Operations With PHP<\/span> and<\/span> MySql -<\/span> By Cleartuts<\/<\/span>label<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n<<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>body\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>content\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>form<\/span> method<\/span>=<\/span>\"<\/span>post\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>table<\/span> align<\/span>=<\/span>\"<\/span>center\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span> align<\/span>=<\/span>\"<\/span>center\"<\/span><\/span>><\/span><\/span><\/span><<\/span>a<\/span> href<\/span>=<\/span>\"<\/span>index.php\"<\/span><\/span>><\/span><\/span><\/span>back to main page<\/<\/span>a<\/span>><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span>><\/span><\/span><\/span><<\/span>input<\/span> type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> name<\/span>=<\/span>\"<\/span>first_name\"<\/span><\/span> placeholder<\/span>=<\/span>\"<\/span>First Name\"<\/span><\/span> required<\/span> \/><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span>><\/span><\/span><\/span><<\/span>input<\/span> type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> name<\/span>=<\/span>\"<\/span>last_name\"<\/span><\/span> placeholder<\/span>=<\/span>\"<\/span>Last Name\"<\/span><\/span> required<\/span> \/><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span>><\/span><\/span><\/span><<\/span>input<\/span> type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> name<\/span>=<\/span>\"<\/span>city_name\"<\/span><\/span> placeholder<\/span>=<\/span>\"<\/span>City\"<\/span><\/span> required<\/span> \/><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span>><\/span><\/span><\/span><<\/span>button<\/span> type<\/span>=<\/span>\"<\/span>submit\"<\/span><\/span> name<\/span>=<\/span>\"<\/span>btn-save\"<\/span><\/span>><\/span><\/span><\/span><<\/span>strong<\/span>><\/span><\/span><\/span>SAVE<\/span><\/<\/span>strong<\/span>><\/span><\/span><\/span><\/<\/span>button<\/span>><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>table<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>form<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n\r\n<\/<\/span>center<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>body<\/span>><\/span><\/span><\/span><\/code><\/pre>\n
On the top of the html<\/code> tag we need to put PHP code that handle database connection and insert new records into to the user table , So the code is as follow :
\nput the following php insert code just above starting <\/code>tag<\/p>\n
<?php<\/span>\r\ninclude_once<\/span> 'dbconfig.php'<\/span>;<\/span>\r\nif<\/span>(<\/span>isset(<\/span><\/span>$_POST<\/span>[<\/span>'btn-save'<\/span>]<\/span>)<\/span>)<\/span>\r\n{<\/span>\r\n \/\/ variables for input data\r\n<\/span> $first_name<\/span> =<\/span> $_POST<\/span>[<\/span>'first_name'<\/span>]<\/span>;<\/span>\r\n $last_name<\/span> =<\/span> $_POST<\/span>[<\/span>'last_name'<\/span>]<\/span>;<\/span>\r\n $city_name<\/span> =<\/span> $_POST<\/span>[<\/span>'city_name'<\/span>]<\/span>;<\/span>\r\n \/\/ variables for input data\r\n<\/span> \r\n \/\/ sql query for inserting data into database\r\n<\/span> \r\n        $sql_query<\/span> =<\/span> \"INSERT INTO users(first_name,last_name,user_city) VALUES('$first_name','$last_name','$city_name')\"<\/span>;<\/span>\r\n mysql_query(<\/span><\/span>$sql_query<\/span>)<\/span>;<\/span>\r\n        \r\n        \/\/ sql query for inserting data into database\r\n<\/span> \r\n}<\/span>\r\n?><\/span><\/span><\/code><\/pre>\n
above html form will look like :<\/p>\n
\"Simple<\/a><\/div>\n
 <\/p>\n
Read : Retrieveng Records From Table<\/h2>\n
After data insert we need to retrieve all the records from users table :
\nRetrieveng Records From users table<\/b>
\nfollowing is the php code for selecting records from table.<\/p>\n
$sql_query=<\/span>\"SELECT * FROM users\"<\/span>;<\/span>\r\n$result_set=<\/span>mysql_query(<\/span>$sql_query)<\/span>;<\/span><\/code><\/pre>\n
Using the following while() loop we can fetch all the records from users table. For example<\/p>\n
<?php<\/span>\r\n$sql_query<\/span>=<\/span>\"SELECT * FROM users\"<\/span>;<\/span>\r\n$result_set<\/span>=<\/span>mysql_query(<\/span><\/span>$sql_query<\/span>)<\/span>;<\/span>\r\nwhile<\/span>(<\/span>$row<\/span> =<\/span> mysql_fetch_array(<\/span><\/span>$result<\/span>)<\/span>)<\/span>\r\n{<\/span>\r\n    ?><\/span><\/span>\r\n    <!--Add HTML code here to display records.--><\/span><\/span>\r\n    <?php<\/span>\r\n}<\/span>\r\n?><\/span><\/span><\/code><\/pre>\n
After that, list of database records will be displayed to the browser, as shown below. And, this list contains icons to trigger update and delete operations for each record.
\nindex.php<\/b><\/p>\n
<?php<\/span>\r\ninclude_once<\/span> 'dbconfig.php'<\/span>;<\/span>\r\n?><\/span><\/span>\r\n<!DOCTYPE html PUBLIC \"-\/\/W3C\/\/DTD XHTML 1.0 Transitional\/\/EN\" \"http:\/\/www.w3.org\/TR\/xhtml1\/DTD\/xhtml1-transitional.dtd\"><\/span><\/span>\r\n<<\/span>html<\/span> xmlns<\/span>=<\/span>\"<\/span>http:\/\/www.w3.org\/1999\/xhtml\"<\/span><\/span>><\/span><\/span><\/span>\r\n<<\/span>head<\/span>><\/span><\/span><\/span>\r\n<<\/span>meta<\/span> http-equiv<\/span>=<\/span>\"<\/span>Content-Type\"<\/span><\/span> content<\/span>=<\/span>\"<\/span>text\/html; charset=<\/span>utf-8\"<\/span><\/span> \/><\/span><\/span><\/span>\r\n<<\/span>title<\/span>><\/span><\/span><\/span>CRUD<\/span> Operations With PHP<\/span> and<\/span> MySql -<\/span> By Cleartuts<\/<\/span>title<\/span>><\/span><\/span><\/span>\r\n<<\/span>link<\/span> rel<\/span>=<\/span>\"<\/span>stylesheet\"<\/span><\/span> href<\/span>=<\/span>\"<\/span>style.css\"<\/span><\/span> type<\/span>=<\/span>\"<\/span>text\/css\"<\/span><\/span> \/><\/span><\/span><\/span>\r\n<\/<\/span>head<\/span>><\/span><\/span><\/span>\r\n<<\/span>body<\/span>><\/span><\/span><\/span>\r\n<<\/span>center<\/span>><\/span><\/span><\/span>\r\n\r\n<<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>body\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>content\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>table<\/span> align<\/span>=<\/span>\"<\/span>center\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>th<\/span> colspan<\/span>=<\/span>\"<\/span>5\"<\/span><\/span>><\/span><\/span><\/span><<\/span>a<\/span> href<\/span>=<\/span>\"<\/span>add_data.php\"<\/span><\/span>><\/span><\/span><\/span>add data here.<\/span><\/<\/span>a<\/span>><\/span><\/span><\/span><\/<\/span>th<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>th<\/span>><\/span><\/span><\/span>First Name<\/<\/span>th<\/span>><\/span><\/span><\/span>\r\n    <<\/span>th<\/span>><\/span><\/span><\/span>Last Name<\/<\/span>th<\/span>><\/span><\/span><\/span>\r\n    <<\/span>th<\/span>><\/span><\/span><\/span>City Name<\/<\/span>th<\/span>><\/span><\/span><\/span>\r\n    <<\/span>th<\/span> colspan<\/span>=<\/span>\"<\/span>2\"<\/span><\/span>><\/span><\/span><\/span>Operations<\/<\/span>th<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <?php<\/span>\r\n $sql_query<\/span>=<\/span>\"SELECT * FROM users\"<\/span>;<\/span>\r\n $result_set<\/span>=<\/span>mysql_query(<\/span><\/span>$sql_query<\/span>)<\/span>;<\/span>\r\n while<\/span>(<\/span>$row<\/span>=<\/span>mysql_fetch_row(<\/span><\/span>$result_set<\/span>)<\/span>)<\/span>\r\n {<\/span>\r\n  ?><\/span><\/span>\r\n        <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n        <<\/span>td<\/span>><\/span><\/span><\/span><?php<\/span> echo<\/span> $row<\/span>[<\/span>1<\/span>]<\/span>;<\/span> ?><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n        <<\/span>td<\/span>><\/span><\/span><\/span><?php<\/span> echo<\/span> $row<\/span>[<\/span>2<\/span>]<\/span>;<\/span> ?><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n        <<\/span>td<\/span>><\/span><\/span><\/span><?php<\/span> echo<\/span> $row<\/span>[<\/span>3<\/span>]<\/span>;<\/span> ?><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n  <<\/span>td<\/span> align<\/span>=<\/span>\"<\/span>center\"<\/span><\/span>><\/span><\/span><\/span><<\/span>a<\/span> href<\/span>=<\/span>\"<\/span>javascript:edt_id('<?php<\/span> echo<\/span> $row<\/span>[<\/span>0<\/span>]<\/span>;<\/span> ?><\/span><\/span>')\"<\/span><\/span>><\/span><\/span><\/span><<\/span>img<\/span> src<\/span>=<\/span>\"<\/span>b_edit.png\"<\/span><\/span> align<\/span>=<\/span>\"<\/span>EDIT\"<\/span><\/span> \/><\/span><\/span><\/span><\/<\/span>a<\/span>><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n        <<\/span>td<\/span> align<\/span>=<\/span>\"<\/span>center\"<\/span><\/span>><\/span><\/span><\/span><<\/span>a<\/span> href<\/span>=<\/span>\"<\/span>javascript:delete_id('<?php<\/span> echo<\/span> $row<\/span>[<\/span>0<\/span>]<\/span>;<\/span> ?><\/span><\/span>')\"<\/span><\/span>><\/span><\/span><\/span><<\/span>img<\/span> src<\/span>=<\/span>\"<\/span>b_drop.png\"<\/span><\/span> align<\/span>=<\/span>\"<\/span>DELETE\"<\/span><\/span> \/><\/span><\/span><\/span><\/<\/span>a<\/span>><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n        <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n        <?php<\/span>\r\n }<\/span>\r\n ?><\/span><\/span>\r\n    <\/<\/span>table<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n\r\n<\/<\/span>center<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>body<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>html<\/span>><\/span><\/span><\/span><\/code><\/pre>\n
Output : <\/b><\/p>\n
\"PHP<\/a><\/div>\n
 <\/p>\n
Update : Update MySQL Records.<\/h2>\n
to complete this operation with each record we can use edit icon that displayed with each record as shown above screenshot on clicking this icon for the specified row the page will jump to theedit_data.php<\/b> with the specified row and details which are to be edited are filled up in the below form , and it will look like.<\/p>\n
\"PHP<\/a><\/div>\n
For that we need to fetch the selected row from users table by using SELECT<\/b> Query and the QueryString which are set in the edit_data.php<\/b> url with edit_id=value.<\/p>\n
if<\/span>(<\/span>isset(<\/span><\/span>$_GET<\/span>[<\/span>'edit_id'<\/span>]<\/span>)<\/span>)<\/span>\r\n{<\/span>\r\n $sql_query<\/span>=<\/span>\"SELECT * FROM users WHERE user_id=\"<\/span>.<\/span>$_GET<\/span>[<\/span>'edit_id'<\/span>]<\/span>;<\/span>\r\n $result_set<\/span>=<\/span>mysql_query(<\/span><\/span>$sql_query<\/span>)<\/span>;<\/span>\r\n $fetched_row<\/span>=<\/span>mysql_fetch_array(<\/span><\/span>$result_set<\/span>)<\/span>;<\/span>\r\n}<\/span><\/code><\/pre>\n
if<\/span>(<\/span>isset(<\/span><\/span>$_POST<\/span>[<\/span>'btn-update'<\/span>]<\/span>)<\/span>)<\/span>\r\n{<\/span>\r\n \/\/ variables for input data\r\n<\/span> $first_name<\/span> =<\/span> $_POST<\/span>[<\/span>'first_name'<\/span>]<\/span>;<\/span>\r\n $last_name<\/span> =<\/span> $_POST<\/span>[<\/span>'last_name'<\/span>]<\/span>;<\/span>\r\n $city_name<\/span> =<\/span> $_POST<\/span>[<\/span>'city_name'<\/span>]<\/span>;<\/span>\r\n \/\/ variables for input data\r\n<\/span> \r\n \/\/ sql query for update data into database\r\n<\/span> $sql_query<\/span> =<\/span> \"UPDATE users SET first_name='$first_name',last_name='$last_name',user_city='$city_name' WHERE user_id=\"<\/span>.<\/span>$_GET<\/span>[<\/span>'edit_id'<\/span>]<\/span>;<\/span>\r\n        mysql_query(<\/span><\/span>$sql_query<\/span>)<\/span>;<\/span>\r\n \/\/ sql query for update data into database\r\n<\/span>}<\/span><\/code><\/pre>\n
edit_data.php<\/b><\/p>\n
<?php<\/span>\r\ninclude_once<\/span> 'dbconfig.php'<\/span>;<\/span>\r\nif<\/span>(<\/span>isset(<\/span><\/span>$_GET<\/span>[<\/span>'edit_id'<\/span>]<\/span>)<\/span>)<\/span>\r\n{<\/span>\r\n $sql_query<\/span>=<\/span>\"SELECT * FROM users WHERE user_id=\"<\/span>.<\/span>$_GET<\/span>[<\/span>'edit_id'<\/span>]<\/span>;<\/span>\r\n $result_set<\/span>=<\/span>mysql_query(<\/span><\/span>$sql_query<\/span>)<\/span>;<\/span>\r\n  $fetched_row<\/span>=<\/span>mysql_fetch_array(<\/span><\/span>$result_set<\/span>)<\/span>;<\/span>\r\n}<\/span>\r\nif<\/span>(<\/span>isset(<\/span><\/span>$_POST<\/span>[<\/span>'btn-update'<\/span>]<\/span>)<\/span>)<\/span>\r\n{<\/span>\r\n \/\/ variables for input data\r\n<\/span> $first_name<\/span> =<\/span> $_POST<\/span>[<\/span>'first_name'<\/span>]<\/span>;<\/span>\r\n $last_name<\/span> =<\/span> $_POST<\/span>[<\/span>'last_name'<\/span>]<\/span>;<\/span>\r\n $city_name<\/span> =<\/span> $_POST<\/span>[<\/span>'city_name'<\/span>]<\/span>;<\/span>\r\n \/\/ variables for input data\r\n<\/span> \r\n \/\/ sql query for update data into database\r\n<\/span> $sql_query<\/span> =<\/span> \"UPDATE users SET first_name='$first_name',last_name='$last_name',user_city='$city_name' WHERE user_id=\"<\/span>.<\/span>$_GET<\/span>[<\/span>'edit_id'<\/span>]<\/span>;<\/span>\r\n        mysql_query(<\/span><\/span>$sql_query<\/span>)<\/span>)<\/span>;<\/span>\r\n \/\/ sql query for update data into database \r\n<\/span>}<\/span>\r\n?><\/span><\/span>\r\n\r\n<<\/span>html<\/span>><\/span><\/span><\/span>\r\n<<\/span>head<\/span>><\/span><\/span><\/span>\r\n<<\/span>meta<\/span> http-equiv<\/span>=<\/span>\"<\/span>Content-Type\"<\/span><\/span> content<\/span>=<\/span>\"<\/span>text\/html; charset=<\/span>utf-8\"<\/span><\/span> \/><\/span><\/span><\/span>\r\n<<\/span>title<\/span>><\/span><\/span><\/span>CRUD<\/span> Operations With PHP<\/span> and<\/span> MySql -<\/span> By Cleartuts<\/<\/span>title<\/span>><\/span><\/span><\/span>\r\n<<\/span>link<\/span> rel<\/span>=<\/span>\"<\/span>stylesheet\"<\/span><\/span> href<\/span>=<\/span>\"<\/span>style.css\"<\/span><\/span> type<\/span>=<\/span>\"<\/span>text\/css\"<\/span><\/span> \/><\/span><\/span><\/span>\r\n<\/<\/span>head<\/span>><\/span><\/span><\/span>\r\n<<\/span>body<\/span>><\/span><\/span><\/span>\r\n<<\/span>center<\/span>><\/span><\/span><\/span>\r\n\r\n<<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>body\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>content\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>form<\/span> method<\/span>=<\/span>\"<\/span>post\"<\/span><\/span>><\/span><\/span><\/span><\r\n    <<\/span>table<\/span> align<\/span>=<\/span>\"<\/span>center\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span>><\/span><\/span><\/span><<\/span>input<\/span> type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> name<\/span>=<\/span>\"<\/span>first_name\"<\/span><\/span> placeholder<\/span>=<\/span>\"<\/span>First Name\"<\/span><\/span> value<\/span>=<\/span>\"<\/span><?php<\/span> echo<\/span> $fetched_row<\/span>[<\/span>'first_name'<\/span>]<\/span>;<\/span> ?><\/span><\/span>\"<\/span><\/span> required<\/span> \/><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span>><\/span><\/span><\/span><<\/span>input<\/span> type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> name<\/span>=<\/span>\"<\/span>last_name\"<\/span><\/span> placeholder<\/span>=<\/span>\"<\/span>Last Name\"<\/span><\/span> value<\/span>=<\/span>\"<\/span><?php<\/span> echo<\/span> $fetched_row<\/span>[<\/span>'last_name'<\/span>]<\/span>;<\/span> ?><\/span><\/span>\"<\/span><\/span> required<\/span> \/><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span>><\/span><\/span><\/span><<\/span>input<\/span> type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> name<\/span>=<\/span>\"<\/span>city_name\"<\/span><\/span> placeholder<\/span>=<\/span>\"<\/span>City\"<\/span><\/span> value<\/span>=<\/span>\"<\/span><?php<\/span> echo<\/span> $fetched_row<\/span>[<\/span>'user_city'<\/span>]<\/span>;<\/span> ?><\/span><\/span>\"<\/span><\/span> required<\/span> \/><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <<\/span>button<\/span> type<\/span>=<\/span>\"<\/span>submit\"<\/span><\/span> name<\/span>=<\/span>\"<\/span>btn-update\"<\/span><\/span>><\/span><\/span><\/span><<\/span>strong<\/span>><\/span><\/span><\/span>UPDATE<\/span><\/<\/span>strong<\/span>><\/span><\/span><\/span><\/<\/span>button<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>table<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>form<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n\r\n<\/<\/span>center<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>body<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>html<\/span>><\/span><\/span><\/span><\/code><\/pre>\n
 <\/p>\n
Delete : Delete Records From MySQL Table.<\/h2>\n
By clicking on delete icon of any specified user record, the users id will set to the URL QueryString of the page and the QueryString index.php?delete_id=any_value<\/b> if set the Sql Query DELETE<\/b> will be executed by if(isset($_GET[‘delete_id’]))<\/b> function , and delete statement is as follow :<\/p>\n
if<\/span>(<\/span>isset(<\/span><\/span>$_GET<\/span>[<\/span>'delete_id'<\/span>]<\/span>)<\/span>)<\/span>\r\n{<\/span>\r\n $sql_query<\/span>=<\/span>\"DELETE FROM users WHERE user_id=\"<\/span>.<\/span>$_GET<\/span>[<\/span>'delete_id'<\/span>]<\/span>;<\/span>\r\n mysql_query(<\/span><\/span>$sql_query<\/span>)<\/span>;<\/span>\r\n header(<\/span><\/span>\"Location: $_SERVER[PHP_SELF]\"<\/span>)<\/span>;<\/span>\r\n}<\/span><\/code><\/pre>\n
put the above delete php code in index.php<\/b> file above data insert code .
\nnow there is CRUD operations are completed.
\nthats’ it<\/p>\n
Complete CRUD Script<\/p><\/blockquote>\n
dbconfig.php<\/b><\/p>\n
<?php<\/span>\r\n$host<\/span> =<\/span> \"localhost\"<\/span>;<\/span>\r\n$user<\/span> =<\/span> \"root\"<\/span>;<\/span>\r\n$password<\/span> =<\/span> \"\"<\/span>;<\/span>\r\n$datbase<\/span> =<\/span> \"dbtuts\"<\/span>;<\/span>\r\nmysql_connect(<\/span><\/span>$host<\/span>,<\/span>$user<\/span>,<\/span>$password<\/span>)<\/span>;<\/span>\r\nmysql_select_db(<\/span><\/span>$datbase<\/span>)<\/span>;<\/span>\r\n?><\/span><\/span><\/code><\/pre>\n
index.php<\/b><\/p>\n
<?php<\/span>\r\ninclude_once<\/span> 'dbconfig.php'<\/span>;<\/span>\r\n\r\n\/\/ delete condition\r\n<\/span>if<\/span>(<\/span>isset(<\/span><\/span>$_GET<\/span>[<\/span>'delete_id'<\/span>]<\/span>)<\/span>)<\/span>\r\n{<\/span>\r\n $sql_query<\/span>=<\/span>\"DELETE FROM users WHERE user_id=\"<\/span>.<\/span>$_GET<\/span>[<\/span>'delete_id'<\/span>]<\/span>;<\/span>\r\n mysql_query(<\/span><\/span>$sql_query<\/span>)<\/span>;<\/span>\r\n header(<\/span><\/span>\"Location: $_SERVER[PHP_SELF]\"<\/span>)<\/span>;<\/span>\r\n}<\/span>\r\n\/\/ delete condition\r\n<\/span>?><\/span><\/span>\r\n\r\n<!DOCTYPE html PUBLIC \"-\/\/W3C\/\/DTD XHTML 1.0 Transitional\/\/EN\" \"http:\/\/www.w3.org\/TR\/xhtml1\/DTD\/xhtml1-transitional.dtd\"><\/span><\/span>\r\n<<\/span>html<\/span> xmlns<\/span>=<\/span>\"<\/span>http:\/\/www.w3.org\/1999\/xhtml\"<\/span><\/span>><\/span><\/span><\/span>\r\n<<\/span>head<\/span>><\/span><\/span><\/span>\r\n<<\/span>meta<\/span> http-equiv<\/span>=<\/span>\"<\/span>Content-Type\"<\/span><\/span> content<\/span>=<\/span>\"<\/span>text\/html; charset=<\/span>utf-8\"<\/span><\/span> \/><\/span><\/span><\/span>\r\n<<\/span>title<\/span>><\/span><\/span><\/span>CRUD<\/span> Operations With PHP<\/span> and<\/span> MySql -<\/span> By Cleartuts<\/<\/span>title<\/span>><\/span><\/span><\/span>\r\n<<\/span>link<\/span> rel<\/span>=<\/span>\"<\/span>stylesheet\"<\/span><\/span> href<\/span>=<\/span>\"<\/span>style.css\"<\/span><\/span> type<\/span>=<\/span>\"<\/span>text\/css\"<\/span><\/span> \/><\/span><\/span><\/span>\r\n<<\/span>script<\/span> type<\/span>=<\/span>\"<\/span>text\/javascript\"<\/span><\/span>><\/span><\/span><\/span>\r\nfunction<\/span> edt_id(<\/span><\/span>id)<\/span>\r\n{<\/span>\r\n if<\/span>(<\/span>confirm(<\/span><\/span>'Sure to edit ?'<\/span>)<\/span>)<\/span>\r\n {<\/span>\r\n  window.<\/span>location.<\/span>href=<\/span>'edit_data.php?edit_id='<\/span>+<\/span>id;<\/span>\r\n }<\/span>\r\n}<\/span>\r\nfunction<\/span> delete_id(<\/span><\/span>id)<\/span>\r\n{<\/span>\r\n if<\/span>(<\/span>confirm(<\/span><\/span>'Sure to Delete ?'<\/span>)<\/span>)<\/span>\r\n {<\/span>\r\n  window.<\/span>location.<\/span>href=<\/span>'index.php?delete_id='<\/span>+<\/span>id;<\/span>\r\n }<\/span>\r\n}<\/span>\r\n<\/<\/span>script<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>head<\/span>><\/span><\/span><\/span>\r\n<<\/span>body<\/span>><\/span><\/span><\/span>\r\n<<\/span>center<\/span>><\/span><\/span><\/span>\r\n\r\n<<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>header\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>content\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>label<\/span>><\/span><\/span><\/span>CRUD<\/span> Operations With PHP<\/span> and<\/span> MySql -<\/span> <<\/span>a<\/span> href<\/span>=<\/span>\"<\/span>http:\/\/cleartuts.blogspot.com\"<\/span><\/span> target<\/span>=<\/span>\"<\/span>_blank\"<\/span><\/span>><\/span><\/span><\/span>By Cleartuts<\/<\/span>a<\/span>><\/span><\/span><\/span><\/<\/span>label<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n\r\n<<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>body\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>content\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>table<\/span> align<\/span>=<\/span>\"<\/span>center\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>th<\/span> colspan<\/span>=<\/span>\"<\/span>5\"<\/span><\/span>><\/span><\/span><\/span><<\/span>a<\/span> href<\/span>=<\/span>\"<\/span>add_data.php\"<\/span><\/span>><\/span><\/span><\/span>add data here.<\/span><\/<\/span>a<\/span>><\/span><\/span><\/span><\/<\/span>th<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>th<\/span>><\/span><\/span><\/span>First Name<\/<\/span>th<\/span>><\/span><\/span><\/span>\r\n    <<\/span>th<\/span>><\/span><\/span><\/span>Last Name<\/<\/span>th<\/span>><\/span><\/span><\/span>\r\n    <<\/span>th<\/span>><\/span><\/span><\/span>City Name<\/<\/span>th<\/span>><\/span><\/span><\/span>\r\n    <<\/span>th<\/span> colspan<\/span>=<\/span>\"<\/span>2\"<\/span><\/span>><\/span><\/span><\/span>Operations<\/<\/span>th<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <?php<\/span>\r\n $sql_query<\/span>=<\/span>\"SELECT * FROM users\"<\/span>;<\/span>\r\n $result_set<\/span>=<\/span>mysql_query(<\/span><\/span>$sql_query<\/span>)<\/span>;<\/span>\r\n while<\/span>(<\/span>$row<\/span>=<\/span>mysql_fetch_row(<\/span><\/span>$result_set<\/span>)<\/span>)<\/span>\r\n {<\/span>\r\n  ?><\/span><\/span>\r\n        <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n        <<\/span>td<\/span>><\/span><\/span><\/span><?php<\/span> echo<\/span> $row<\/span>[<\/span>1<\/span>]<\/span>;<\/span> ?><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n        <<\/span>td<\/span>><\/span><\/span><\/span><?php<\/span> echo<\/span> $row<\/span>[<\/span>2<\/span>]<\/span>;<\/span> ?><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n        <<\/span>td<\/span>><\/span><\/span><\/span><?php<\/span> echo<\/span> $row<\/span>[<\/span>3<\/span>]<\/span>;<\/span> ?><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n  <<\/span>td<\/span> align<\/span>=<\/span>\"<\/span>center\"<\/span><\/span>><\/span><\/span><\/span><<\/span>a<\/span> href<\/span>=<\/span>\"<\/span>javascript:edt_id('<?php<\/span> echo<\/span> $row<\/span>[<\/span>0<\/span>]<\/span>;<\/span> ?><\/span><\/span>')\"<\/span><\/span>><\/span><\/span><\/span><<\/span>img<\/span> src<\/span>=<\/span>\"<\/span>b_edit.png\"<\/span><\/span> align<\/span>=<\/span>\"<\/span>EDIT\"<\/span><\/span> \/><\/span><\/span><\/span><\/<\/span>a<\/span>><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n        <<\/span>td<\/span> align<\/span>=<\/span>\"<\/span>center\"<\/span><\/span>><\/span><\/span><\/span><<\/span>a<\/span> href<\/span>=<\/span>\"<\/span>javascript:delete_id('<?php<\/span> echo<\/span> $row<\/span>[<\/span>0<\/span>]<\/span>;<\/span> ?><\/span><\/span>')\"<\/span><\/span>><\/span><\/span><\/span><<\/span>img<\/span> src<\/span>=<\/span>\"<\/span>b_drop.png\"<\/span><\/span> align<\/span>=<\/span>\"<\/span>DELETE\"<\/span><\/span> \/><\/span><\/span><\/span><\/<\/span>a<\/span>><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n        <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n        <?php<\/span>\r\n }<\/span>\r\n ?><\/span><\/span>\r\n    <\/<\/span>table<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n\r\n<\/<\/span>center<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>body<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>html<\/span>><\/span><\/span><\/span><\/code><\/pre>\n
add_data.php<\/b><\/p>\n
<?php<\/span>\r\ninclude_once<\/span> 'dbconfig.php'<\/span>;<\/span>\r\nif<\/span>(<\/span>isset(<\/span><\/span>$_POST<\/span>[<\/span>'btn-save'<\/span>]<\/span>)<\/span>)<\/span>\r\n{<\/span>\r\n \/\/ variables for input data\r\n<\/span> $first_name<\/span> =<\/span> $_POST<\/span>[<\/span>'first_name'<\/span>]<\/span>;<\/span>\r\n $last_name<\/span> =<\/span> $_POST<\/span>[<\/span>'last_name'<\/span>]<\/span>;<\/span>\r\n $city_name<\/span> =<\/span> $_POST<\/span>[<\/span>'city_name'<\/span>]<\/span>;<\/span>\r\n \/\/ variables for input data\r\n<\/span>\r\n \/\/ sql query for inserting data into database\r\n<\/span> $sql_query<\/span> =<\/span> \"INSERT INTO users(first_name,last_name,user_city) VALUES('$first_name','$last_name','$city_name')\"<\/span>;<\/span>\r\n \/\/ sql query for inserting data into database\r\n<\/span> \r\n \/\/ sql query execution function\r\n<\/span> if<\/span>(<\/span>mysql_query(<\/span><\/span>$sql_query<\/span>)<\/span>)<\/span>\r\n {<\/span>\r\n  ?><\/span><\/span>\r\n  <<\/span>script<\/span> type<\/span>=<\/span>\"<\/span>text\/javascript\"<\/span><\/span>><\/span><\/span><\/span>\r\n  alert(<\/span><\/span>'Data Are Inserted Successfully '<\/span>)<\/span>;<\/span>\r\n  window.<\/span>location.<\/span>href=<\/span>'index.php'<\/span>;<\/span>\r\n  <\/<\/span>script<\/span>><\/span><\/span><\/span>\r\n  <?php<\/span>\r\n }<\/span>\r\n else<\/span>\r\n {<\/span>\r\n  ?><\/span><\/span>\r\n  <<\/span>script<\/span> type<\/span>=<\/span>\"<\/span>text\/javascript\"<\/span><\/span>><\/span><\/span><\/span>\r\n  alert(<\/span><\/span>'error occured while inserting your data'<\/span>)<\/span>;<\/span>\r\n  <\/<\/span>script<\/span>><\/span><\/span><\/span>\r\n  <?php<\/span>\r\n }<\/span>\r\n \/\/ sql query execution function\r\n<\/span>}<\/span>\r\n?><\/span><\/span>\r\n<!DOCTYPE html PUBLIC \"-\/\/W3C\/\/DTD XHTML 1.0 Transitional\/\/EN\" \"http:\/\/www.w3.org\/TR\/xhtml1\/DTD\/xhtml1-transitional.dtd\"><\/span><\/span>\r\n<<\/span>html<\/span> xmlns<\/span>=<\/span>\"<\/span>http:\/\/www.w3.org\/1999\/xhtml\"<\/span><\/span>><\/span><\/span><\/span>\r\n<<\/span>head<\/span>><\/span><\/span><\/span>\r\n<<\/span>meta<\/span> http-equiv<\/span>=<\/span>\"<\/span>Content-Type\"<\/span><\/span> content<\/span>=<\/span>\"<\/span>text\/html; charset=<\/span>utf-8\"<\/span><\/span> \/><\/span><\/span><\/span>\r\n<<\/span>title<\/span>><\/span><\/span><\/span>CRUD<\/span> Operations With PHP<\/span> and<\/span> MySql -<\/span> By Cleartuts<\/<\/span>title<\/span>><\/span><\/span><\/span>\r\n<<\/span>link<\/span> rel<\/span>=<\/span>\"<\/span>stylesheet\"<\/span><\/span> href<\/span>=<\/span>\"<\/span>style.css\"<\/span><\/span> type<\/span>=<\/span>\"<\/span>text\/css\"<\/span><\/span> \/><\/span><\/span><\/span>\r\n<\/<\/span>head<\/span>><\/span><\/span><\/span>\r\n<<\/span>body<\/span>><\/span><\/span><\/span>\r\n<<\/span>center<\/span>><\/span><\/span><\/span>\r\n\r\n<<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>header\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>content\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>label<\/span>><\/span><\/span><\/span>CRUD<\/span> Operations With PHP<\/span> and<\/span> MySql -<\/span> By Cleartuts<\/<\/span>label<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n<<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>body\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>content\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>form<\/span> method<\/span>=<\/span>\"<\/span>post\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>table<\/span> align<\/span>=<\/span>\"<\/span>center\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span> align<\/span>=<\/span>\"<\/span>center\"<\/span><\/span>><\/span><\/span><\/span><<\/span>a<\/span> href<\/span>=<\/span>\"<\/span>index.php\"<\/span><\/span>><\/span><\/span><\/span>back to main page<\/<\/span>a<\/span>><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span>><\/span><\/span><\/span><<\/span>input<\/span> type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> name<\/span>=<\/span>\"<\/span>first_name\"<\/span><\/span> placeholder<\/span>=<\/span>\"<\/span>First Name\"<\/span><\/span> required<\/span> \/><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span>><\/span><\/span><\/span><<\/span>input<\/span> type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> name<\/span>=<\/span>\"<\/span>last_name\"<\/span><\/span> placeholder<\/span>=<\/span>\"<\/span>Last Name\"<\/span><\/span> required<\/span> \/><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span>><\/span><\/span><\/span><<\/span>input<\/span> type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> name<\/span>=<\/span>\"<\/span>city_name\"<\/span><\/span> placeholder<\/span>=<\/span>\"<\/span>City\"<\/span><\/span> required<\/span> \/><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span>><\/span><\/span><\/span><<\/span>button<\/span> type<\/span>=<\/span>\"<\/span>submit\"<\/span><\/span> name<\/span>=<\/span>\"<\/span>btn-save\"<\/span><\/span>><\/span><\/span><\/span><<\/span>strong<\/span>><\/span><\/span><\/span>SAVE<\/span><\/<\/span>strong<\/span>><\/span><\/span><\/span><\/<\/span>button<\/span>><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>table<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>form<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n\r\n<\/<\/span>center<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>body<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>html<\/span>><\/span><\/span><\/span><\/code><\/pre>\n
edit_data.php<\/b><\/p>\n
<?php<\/span>\r\ninclude_once<\/span> 'dbconfig.php'<\/span>;<\/span>\r\nif<\/span>(<\/span>isset(<\/span><\/span>$_GET<\/span>[<\/span>'edit_id'<\/span>]<\/span>)<\/span>)<\/span>\r\n{<\/span>\r\n $sql_query<\/span>=<\/span>\"SELECT * FROM users WHERE user_id=\"<\/span>.<\/span>$_GET<\/span>[<\/span>'edit_id'<\/span>]<\/span>;<\/span>\r\n $result_set<\/span>=<\/span>mysql_query(<\/span><\/span>$sql_query<\/span>)<\/span>;<\/span>\r\n $fetched_row<\/span>=<\/span>mysql_fetch_array(<\/span><\/span>$result_set<\/span>)<\/span>;<\/span>\r\n}<\/span>\r\nif<\/span>(<\/span>isset(<\/span><\/span>$_POST<\/span>[<\/span>'btn-update'<\/span>]<\/span>)<\/span>)<\/span>\r\n{<\/span>\r\n \/\/ variables for input data\r\n<\/span> $first_name<\/span> =<\/span> $_POST<\/span>[<\/span>'first_name'<\/span>]<\/span>;<\/span>\r\n $last_name<\/span> =<\/span> $_POST<\/span>[<\/span>'last_name'<\/span>]<\/span>;<\/span>\r\n $city_name<\/span> =<\/span> $_POST<\/span>[<\/span>'city_name'<\/span>]<\/span>;<\/span>\r\n \/\/ variables for input data\r\n<\/span>\r\n \/\/ sql query for update data into database\r\n<\/span> $sql_query<\/span> =<\/span> \"UPDATE users SET first_name='$first_name',last_name='$last_name',user_city='$city_name' WHERE user_id=\"<\/span>.<\/span>$_GET<\/span>[<\/span>'edit_id'<\/span>]<\/span>;<\/span>\r\n \/\/ sql query for update data into database\r\n<\/span> \r\n \/\/ sql query execution function\r\n<\/span> if<\/span>(<\/span>mysql_query(<\/span><\/span>$sql_query<\/span>)<\/span>)<\/span>\r\n {<\/span>\r\n  ?><\/span><\/span>\r\n  <<\/span>script<\/span> type<\/span>=<\/span>\"<\/span>text\/javascript\"<\/span><\/span>><\/span><\/span><\/span>\r\n  alert(<\/span><\/span>'Data Are Updated Successfully'<\/span>)<\/span>;<\/span>\r\n  window.<\/span>location.<\/span>href=<\/span>'index.php'<\/span>;<\/span>\r\n  <\/<\/span>script<\/span>><\/span><\/span><\/span>\r\n  <?php<\/span>\r\n }<\/span>\r\n else<\/span>\r\n {<\/span>\r\n  ?><\/span><\/span>\r\n  <<\/span>script<\/span> type<\/span>=<\/span>\"<\/span>text\/javascript\"<\/span><\/span>><\/span><\/span><\/span>\r\n  alert(<\/span><\/span>'error occured while updating data'<\/span>)<\/span>;<\/span>\r\n  <\/<\/span>script<\/span>><\/span><\/span><\/span>\r\n  <?php<\/span>\r\n }<\/span>\r\n \/\/ sql query execution function\r\n<\/span>}<\/span>\r\nif<\/span>(<\/span>isset(<\/span><\/span>$_POST<\/span>[<\/span>'btn-cancel'<\/span>]<\/span>)<\/span>)<\/span>\r\n{<\/span>\r\n header(<\/span><\/span>\"Location: index.php\"<\/span>)<\/span>;<\/span>\r\n}<\/span>\r\n?><\/span><\/span>\r\n<!DOCTYPE html PUBLIC \"-\/\/W3C\/\/DTD XHTML 1.0 Transitional\/\/EN\" \"http:\/\/www.w3.org\/TR\/xhtml1\/DTD\/xhtml1-transitional.dtd\"><\/span><\/span>\r\n<<\/span>html<\/span> xmlns<\/span>=<\/span>\"<\/span>http:\/\/www.w3.org\/1999\/xhtml\"<\/span><\/span>><\/span><\/span><\/span>\r\n<<\/span>head<\/span>><\/span><\/span><\/span>\r\n<<\/span>meta<\/span> http-equiv<\/span>=<\/span>\"<\/span>Content-Type\"<\/span><\/span> content<\/span>=<\/span>\"<\/span>text\/html; charset=<\/span>utf-8\"<\/span><\/span> \/><\/span><\/span><\/span>\r\n<<\/span>title<\/span>><\/span><\/span><\/span>CRUD<\/span> Operations With PHP<\/span> and<\/span> MySql -<\/span> By Cleartuts<\/<\/span>title<\/span>><\/span><\/span><\/span>\r\n<<\/span>link<\/span> rel<\/span>=<\/span>\"<\/span>stylesheet\"<\/span><\/span> href<\/span>=<\/span>\"<\/span>style.css\"<\/span><\/span> type<\/span>=<\/span>\"<\/span>text\/css\"<\/span><\/span> \/><\/span><\/span><\/span>\r\n<\/<\/span>head<\/span>><\/span><\/span><\/span>\r\n<<\/span>body<\/span>><\/span><\/span><\/span>\r\n<<\/span>center<\/span>><\/span><\/span><\/span>\r\n\r\n<<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>header\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>content\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>label<\/span>><\/span><\/span><\/span>CRUD<\/span> Operations With PHP<\/span> and<\/span> MySql -<\/span> By Cleartuts<\/<\/span>label<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n\r\n<<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>body\"<\/span><\/span>><\/span><\/span><\/span>\r\n <<\/span>div<\/span> id<\/span>=<\/span>\"<\/span>content\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>form<\/span> method<\/span>=<\/span>\"<\/span>post\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>table<\/span> align<\/span>=<\/span>\"<\/span>center\"<\/span><\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span>><\/span><\/span><\/span><<\/span>input<\/span> type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> name<\/span>=<\/span>\"<\/span>first_name\"<\/span><\/span> placeholder<\/span>=<\/span>\"<\/span>First Name\"<\/span><\/span> value<\/span>=<\/span>\"<\/span><?php<\/span> echo<\/span> $fetched_row<\/span>[<\/span>'first_name'<\/span>]<\/span>;<\/span> ?><\/span><\/span>\"<\/span><\/span> required<\/span> \/><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span>><\/span><\/span><\/span><<\/span>input<\/span> type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> name<\/span>=<\/span>\"<\/span>last_name\"<\/span><\/span> placeholder<\/span>=<\/span>\"<\/span>Last Name\"<\/span><\/span> value<\/span>=<\/span>\"<\/span><?php<\/span> echo<\/span> $fetched_row<\/span>[<\/span>'last_name'<\/span>]<\/span>;<\/span> ?><\/span><\/span>\"<\/span><\/span> required<\/span> \/><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span>><\/span><\/span><\/span><<\/span>input<\/span> type<\/span>=<\/span>\"<\/span>text\"<\/span><\/span> name<\/span>=<\/span>\"<\/span>city_name\"<\/span><\/span> placeholder<\/span>=<\/span>\"<\/span>City\"<\/span><\/span> value<\/span>=<\/span>\"<\/span><?php<\/span> echo<\/span> $fetched_row<\/span>[<\/span>'user_city'<\/span>]<\/span>;<\/span> ?><\/span><\/span>\"<\/span><\/span> required<\/span> \/><\/span><\/span><\/span><\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <<\/span>button<\/span> type<\/span>=<\/span>\"<\/span>submit\"<\/span><\/span> name<\/span>=<\/span>\"<\/span>btn-update\"<\/span><\/span>><\/span><\/span><\/span><<\/span>strong<\/span>><\/span><\/span><\/span>UPDATE<\/span><\/<\/span>strong<\/span>><\/span><\/span><\/span><\/<\/span>button<\/span>><\/span><\/span><\/span>\r\n    <<\/span>button<\/span> type<\/span>=<\/span>\"<\/span>submit\"<\/span><\/span> name<\/span>=<\/span>\"<\/span>btn-cancel\"<\/span><\/span>><\/span><\/span><\/span><<\/span>strong<\/span>><\/span><\/span><\/span>Cancel<\/<\/span>strong<\/span>><\/span><\/span><\/span><\/<\/span>button<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>td<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>tr<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>table<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>form<\/span>><\/span><\/span><\/span>\r\n    <\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>div<\/span>><\/span><\/span><\/span>\r\n\r\n<\/<\/span>center<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>body<\/span>><\/span><\/span><\/span>\r\n<\/<\/span>html<\/span>><\/span><\/span><\/span><\/code><\/pre>\n
style.css<\/b><\/p>\n
@charset \"utf-8\";<\/span><\/span>\r\n\/* CSS Document *\/<\/span>\r\n\r\n*\r\n<\/span>{<\/span>\r\n margin<\/span>:<\/span>0;<\/span>\r\n padding<\/span>:<\/span>0;<\/span>\r\n}<\/span>\r\nbody\r\n<\/span>{<\/span>\r\n background<\/span>:<\/span>#f9f9f9;<\/span>\r\n font-family<\/span>:<\/span>\"Courier New\"<\/span>, Courier, monospace;<\/span>\r\n}<\/span>\r\n#header\r\n<\/span>{<\/span>\r\n width<\/span>:<\/span>100%;<\/span>\r\n height<\/span>:<\/span>50px;<\/span>\r\n background<\/span>:<\/span>#00a2d1;<\/span>\r\n color<\/span>:<\/span>#f9f9f9;<\/span>\r\n font-family<\/span>:<\/span>\"Lucida Sans Unicode\"<\/span>, \"Lucida Grande\"<\/span>, sans-serif;<\/span>\r\n font-size<\/span>:<\/span>35px;<\/span>\r\n text-align<\/span>:<\/span>center;<\/span>\r\n}<\/span>\r\n#header a\r\n<\/span>{<\/span>\r\n color<\/span>:<\/span>#fff;<\/span>\r\n text-decoration<\/span>:<\/span>blink;<\/span>\r\n}<\/span>\r\n#body\r\n<\/span>{<\/span>\r\n margin-top<\/span>:<\/span>50px;<\/span>\r\n}<\/span>\r\ntable\r\n<\/span>{<\/span>\r\n width<\/span>:<\/span>80%;<\/span>\r\n font-family<\/span>:<\/span>Tahoma, Geneva, sans-serif;<\/span>\r\n font-weight<\/span>:<\/span>bolder;<\/span>\r\n color<\/span>:<\/span>#999;<\/span>\r\n margin-bottom<\/span>:<\/span>80px;<\/span>\r\n}<\/span>\r\ntable a\r\n<\/span>{<\/span>\r\n text-decoration<\/span>:<\/span>none;<\/span>\r\n color<\/span>:<\/span>#00a2d1;<\/span>\r\n}<\/span>\r\ntable,td,th\r\n<\/span>{<\/span>\r\n border-collapse<\/span>:<\/span>collapse;<\/span>\r\n border<\/span>:<\/span>solid #d0d0d0 1px;<\/span>\r\n padding<\/span>:<\/span>20px;<\/span>\r\n}<\/span>\r\ntable td input\r\n<\/span>{<\/span>\r\n width<\/span>:<\/span>97%;<\/span>\r\n height<\/span>:<\/span>35px;<\/span>\r\n border<\/span>:<\/span>dashed #00a2d1 1px;<\/span>\r\n padding-left<\/span>:<\/span>15px;<\/span>\r\n font-family<\/span>:<\/span>Verdana, Geneva, sans-serif;<\/span>\r\n box-shadow<\/span>:<\/span>0px 0px 0px rgba<\/span>(1,0,0,0.2);<\/span>\r\n outline<\/span>:<\/span>none;<\/span>\r\n}<\/span>\r\ntable td input:focus\r\n<\/span>{<\/span>\r\n box-shadow<\/span>:<\/span>inset 1px 1px 1px rgba<\/span>(1,0,0,0.2);<\/span>\r\n outline<\/span>:<\/span>none;<\/span>\r\n}<\/span>\r\ntable td button\r\n<\/span>{<\/span>\r\n border<\/span>:<\/span>solid #f9f9f9 0px;<\/span>\r\n box-shadow<\/span>:<\/span>1px 1px 1px rgba<\/span>(1,0,0,0.2);<\/span>\r\n outline<\/span>:<\/span>none;<\/span>\r\n background<\/span>:<\/span>#00a2d1;<\/span>\r\n padding<\/span>:<\/span>9px 15px 9px 15px;<\/span>\r\n color<\/span>:<\/span>#f9f9f9;<\/span>\r\n font-family<\/span>:<\/span>Arial, Helvetica, sans-serif;<\/span>\r\n font-weight<\/span>:<\/span>bolder;<\/span>\r\n border-radius<\/span>:<\/span>3px;<\/span>\r\n width<\/span>:<\/span>49.5%;<\/span>\r\n}<\/span>\r\ntable td button:active\r\n<\/span>{<\/span>\r\n position<\/span>:<\/span>relative;<\/span>\r\n top<\/span>:<\/span>1px;<\/span><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
In this tutorial we are going to discuss about simple CRUD(Create , Read , Update , Delete) PHP operations , these are some of the basic things of\u2026<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-179","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/179","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/comments?post=179"}],"version-history":[{"count":1,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/179\/revisions"}],"predecessor-version":[{"id":180,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/179\/revisions\/180"}],"wp:attachment":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/media?parent=179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/categories?post=179"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/tags?post=179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
after selecting data we need to execute UPDATE<\/a><\/b> Query as follow<\/p>\n