Database-Related

This article explains how to perform basic CRUD operations on a datavase using the included DataContext class. It shows how to insert/update and query data.

A quick tutorial to show how you can make interactive AJAX dropdown menus that are database driven.

Pretty often you need to run a couple of queries against your MySQL database on the client's web server. Usually phpMyAdmin does the job well but there are situations when you just need to upload something to the server and open in the borwser, without any configuration steps. Welcome Bike, lightweight phpMyAdmin replacement. If you already have a CMS installed on the web server (WordPress, Drupal, Joomla), simply upload Bike to CMS's subfolder and open it in the browser.

SQL tutorial video presents the use of aggregate functions: MIN, MAX, AVG, SUM, COUNT, DISTINCT. Free lesson with practical examples describe how to group data using GROUP BY and HAVING clauses.

MongoDB is an open source NoSQL database system. Tutorial presents introduction to MongoDB. Free lesson describe how to use document-oriented database system: how to insert, select, update and delete data, use Set and Unset operators.

This is a spelling checking script written in PHP/MySQL. It asks the user to input an English word and checks if the spelling is correct. If the spelling is not correct, it offers different suggestions of similar words.

1.Creating Database Tables 2.Introduction to the Header/Footer System 3.Getting Ready for Action 4.Displaying the Forum Overview 5.Signing up a User 6.Adding Authentication and User Levels 7.Creating a Category 8.Adding Categories to index.php 9.Creating a Topic 10.Category View 11.Topic View 12.Adding a Reply

This article demonstrates how to concatenate two or more strings and fields in MySQL using the CONCAT() function.

In this article we describe how to implement record locking in web applications. Because of the stateless nature of HTTP, you cannot really know whether the user left the page or is still looking at your site. We used the lock confirmation technique combined with lock expiration to solve this problem.

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.

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.

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.

If your website some how gets hacked and you lose all your MySQL Database information, I doubt you would be laughing� or smiling� That's why you need to backup your database from time to time so that you can put it back the way it was. Here is a simple script using PHP and MySQL to backup your database!

In this PHP MySQL tutorial I will show you how to use basic database manipulation features in PHP.

Mysql provide blob type for storing data, if you looking a way to export your blob data into a file (picture) maybe this tutorial will help.

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

Quick and easy script on how to create a DB link and execute an sql statement

This article provides tutorial notes on connecting PHP scripts to MySQl servers. Topics include creating database connection objects; executing INSERT INTO, SELECT, and UPDATE statements from PHP scripts.

This is a script usefull mostly to server admins, which will automatically detect all your mysql databases and backup/compress them.

A collection of 18 FAQs on connecting to MS SQL Server with PHP scripts. Clear explanations and tutorial exercises are provided on SQL Server connection; providing port number; selecting database; running SQL statements; checking execution errors; looping through query result; looping through result fields.