The purpose of these examples are to show you various ways to use PHP and MySQL. The examples include displaying all fields in the database, random fields, sorting alphabetically and limiting the results returned.
A detailed introduction to PHP and mySQL interaction. Includes detailed comments to help newbies get used to PHP and understand what is happening in each script.
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
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.
A collection of 21 tips on working with MySQL database. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping tables, inserting, updating, and deleting rows, selecting and looping through data rows, searching by key words, setting auto-increment IDs.
Platform(s): Linux, Windows, FreeBSD, Mac OSX, Sun Solaris
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.
Got a MySQL database with content within it? Want to be able to search it and display paged search results on screen? This tutorial and script will do just that. (Apache, PHP, MySQL database required)
PHP4 is packed with good features. One of the most popular is session variables. These are variables that persist throughout a session, as the user moves from page to page. Session variables are great holders of state information and other useful stuff. PHP4's session variables are stored in files by default. However for true scalability, it is better to store this data in a database using a database wrapper library like ADODB. ADODB supports Oracle, MySQL, PostgreSQL, Interbase, MSSQL, VFP, Access, ADO.
This 6-page article explains how to create an extension to PHPLIB to work with multiple databases. You may find this article helps you extend PHPLIB in other ways. Read this article to the end and then think about situations where PHPLIB performs 98% of what you want.