 Phpmyadmin And Php And Mysql, tutorial |
|
|
|
|
  |
 Jun 10 2006, 07:01 PM
Post
#1
|
|
|
Super Member  Group: Members Posts: 357 Joined: 8-April 06 Member No.: 21,487  |
hi
i think phpmyadmin is nice script (3rdparti) to learn php and mysql , you can add database and then make tabel with rows and columns then you can customise (search , show rows , show columns , add rows , delete rows) tabel in phpmyadmin when you are customise phpmyadmin , this script show you php code . you can use this code for browse in database . for example : showing tabel : CODE SELECT * FROM `tabelname` LIMIT 0 , 30 searching : CODE SELECT `columns` FROM `tabel` LIMIT 0 , 30 you can use with while loop showing Ascending: CODE SELECT * FROM `tabelname` ORDER BY `id` ASC LIMIT 0 , 30 Showing Descending : CODE SELECT * FROM `tabelname` ORDER BY `id` DESC LIMIT 0 , 30 write in tabel : CODE mysql_query("INSERT INTO tabelname (columns1,columns2) VALUES ('Your text you want to put in columns1','Your text you want to put in columns2')");
|
 |
 
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 8th September 2008 - 06:13 PM |