How to automate delete data from mysql table - DataDeleter.php - SpartaCode

SpartaCode

Make your development faster and easier !

How to automate delete data from mysql table - DataDeleter.php



Why ? DataDeleter?

When you want to delete a row in database. 
For example, Consider you wanna delete a post created by user and he wishes it to be deleted, then we create PHP service that accepts post id from client and delete row matching that post id into table.

So, 
Why not automate these coding.
Here comes DataDeleter.

DataDeleter accepts a unique primary key in your table as input and delete that row.

After successful execution of DataPutter it will return status as output in JSON Array of Object format .



So, to download DataDeleter.php go to this link below :





How to use DataDeleter.php ?


Steps :


1. Just supply your database details into DataPutter.php and copy DataPutter.php into your xampp project.

2. Edit database details code to point to your database.

3. Now DataDeleter is ready to run.

4. Now go to your Chrome browser in url section type following :


http://localhost/YourProjectName/DataDeleter.php?table=YourTableName&KeyName=PrimaryKeyName&KeyValue=PrimaryKeyValue


Where,

PrimaryKeyName Denotes name of primary key column in your table.

PrimaryKeyValue 
Denotes value of primary key column in your table.


Example would be as follows :

http://localhost/YourProjectName/DataDeleter.php?table=tblTest&KeyName=UserId&KeyValue=22




Hope you like tutorial.
+1 Post and Comment your response


No comments:

Post a Comment

News

Get Amazing Traffic to your Site

Traffic Exchange

Post Bottom Ad

Responsive Ads Here