Database-Related

Learning and using PHP language without interacting with a Database doesn't have much sense at all,and specifically MySql,and ,while you learning you'll be delighted to discover how simple it is.I'll show you how to crate a Database and Tables where to store your data and then how to retrieve and manipulate the data you stored....
(show more)
(show less)

In this tutorial I will show you a short and simple way how to create a backup copy of your MySQL database using the mysqldump utility.

In this tutorial I will show you how you can create a simple PHP script to execute MySQL batch files.

In this tutorial I will show you how you can create an object oriented database abstraction class for MySQL database. Besides the basic functions this manager class can summarize total time spent with db connection and query execution and counts how many query were executed during your PHP script. ...
(show more)
(show less)

Sometimes it could be very helpful to select a record from a table randomly. You can find such solution when you see random partners or randomly selected tutorials. This tutorial shows you how to select records randomly from a MySQL database.

This tutorial covers the basics of accessing a MySQL database from your PHP script. You will learn how to connect to a MySQL database, and how to execute a SQL statement. The example code will output an HTML table containing the contents of a table in the database....
(show more)
(show less)

PHP supports MySQL prepared statements using the Mysqli (MySQL Improved) extension in PHP 5 via the MySQLi_STMT class. They are fairly easy to use once you get used to the differences from writing raw SQL statements. This tutorial will explain how to use prepared statements....
(show more)
(show less)

Delete Records With animation fade-out effect Using jQuery And PHP

Ever wondered how to use mysql class on your OOP projects ? Singleton is the answer !

CouchDB is part of a new breed of database systems, increasingly being used to create cutting-edge PHP web applications. This blog posts walks you through installing CouchDB on CentOS Linux.

Following examples teaches how to query a mySQL database and getting results in pages. Every page displays results maximum 10 results in a single page.

Following code samples, demonstrates how to count records in a MySQL database table. You may send parameters to query to display only selected range of rows.

This tutorial explains how to use several basic MySQL database functions in PHP. Main topics include: Connecting to a mySQL database using PHP, SHOW available tables, Using telnet to CREATE tables, How to INSERT, QUERY, UPDATE, and DELETE rows in a table, How to ALTER a table, Commenting Your mySQL Tables, and Creating mySQL tables....
(show more)
(show less)

This article will aid the reader in learning the basic operations of the MySQL server, including how to make a proper connection, set up the server for consequential manipulation and execute basic commands. The commands covered within this article are among the most important commands within the language, as they form the basis for the more advanced commands....
(show more)
(show less)

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 is a quick MySQL reference for your daily practice or for learning MySQL. This one page document includes most of the commands you will need to create databases and tables, run queries and process data. The download file format in MS Word.

This is a detailed tutorial intended for the PHP programmer interested in learning more about database connectivity - using the ODBC standard. You should be familiar with PHP syntax and have a working knowledge of databases.

MySQL Tutorial shown in a variety of ways!

This tutorial explains how to make a simple connection to Informix and select some data using PHP.

Condense a Web page generated list of records into one page at a time. Greatly reduce Web page load time as formatted output is sent from server to client much quicker than the entire record set listing on a Web page. The generic PHP class (PageNav) makes that task easy, since it employs OOP. Navigate pages of formatted database records using the abstract class. Abstraction allows one to define the methods for each of the header, record list, and footer output. Create nicely formatted layouts or simple listings in just minutes and reuse this class for all your Web application lists. This article-tutorial explains the use and customization of PageNav. It is a small yet useful generic class because it can be used for any Web page that lists records from a database. Don't output hundreds or thousands of records on a Web page. Break it up into sections or pages with very little overhead using the simple yet convenient PageNav class. A download to the free PHP class is available....
(show more)
(show less)