A CRUD Implementation

Click here to view an article about my WordPress plugin called CRUD (Creation, Reading, Updating and Deleting) implementation for an arbitrary database or look below to see the CRUD plugin in action. To log into the CRUD system you need to use the username "admin" and the password "abc".

action=browser
You are in read only mode. To edit the clients_table you need to enter the correct username and password.










Here is the SQL query:
SELECT * FROM clients_table
ORDER BY url_yellow ASC
LIMIT 0,10;
Clients Matching Search Criteria
 row 
ID
up
Name
up
URL Yellow
up
Phone#
up
URL Address
up
Email Address
up
Address
up
Categories
up
Time fixed
up
0 1 Marvin Minsky htpp://foo.com 339-1145 http://marvinminksy.com foo@foo.com 123 Fo Street 00:00:00
1 4 Danger Powers http://www.danger-powers.com 339-1145 http://www.danger.com roger@example.com 456 Foo St Boxes 00:00:00
2 3 Marvin Minksy; http://www.marvinminsky.com' 339-1145 http://www.davin.com davin@example.com 123 Foo St Boxes 00:00:00
3 5 Penny Lane http://www.pennylane.com 333-4567 http://www.pennylane.com penny@lane.com 00:00:00
 row 
ID
up
Name
up
URL Yellow
up
Phone#
up
URL Address
up
Email Address
up
Address
up
Categories
up
Time fixed
up

Client Record Scrolling Functions
UP
<<<<<<

Go To Rows#
0 ... 9
GOTO BEGINNING
GOTO END



DOWN
>>>>>>

Go To Rows#
0 ... 9






Total number of rows in table = 4
Entire clients_table is shown. No scrolling is necessary!

Client Record Searching Functions




Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>