topics covered,
- mysql connections
- error handling
- listing databases on a server
- listing tables in a database
- printing mysql table fields into table header
- printing the data into the table automatically
why should you look at it?
- no specific fields mentioned, just point the script at a server, db and table and watch it do its thing!
- you get to reuse the code easily
- no functions, includes, api's or anything
- all 100% php + mysql code for beginners
- runs on php4 or php5, with any mysql version
by tss503
Platform(s): Linux, Windows, FreeBSD, Mac OSX, Sun Solaris
Ever see the little errors of unable to find a file that is stored in mysql? Well you can use this tutorial to add a little message so the viewers know whats going on.
This is a database driven pagination tutorial. Pagination refers to when return results are
broken up into pages. For example when say a search returns 100 results but 10 results per page is desired and links to the other pages with 10 more results are generated. This is used to avoid scrolling nightmares. A classic example is the google search. This tutorial assumes basic knowledge of php scripting and mysql databases.
Learn how to easily create a comment system. Don't know what a comment system is? Well, it's what you see very often in a news system. Basically it allows your users to give feedback on tutorials, news etc. This tutorial is definitley a must-see.
This tutorial shows how to store data into a MySQL database and then retrieve it by using a PHP query. This wil teach you the basics behind the use of PHP with databases.
A VERY good tutorial for beginners who are interested in learning the language quickly.
This is a PHP and MySQL tutorial. With code examples like uploading files to database, creating guestbook, contact form, Content Management System (CMS), User Authentication etc.
This sample script produces a result set of random rows from a table. It does so by populating one of the columns with a random number, and then doing a select statement that uses it to sort the results.