Most Popular Scripts | PHP | Tutorials & Tips | Database-Related
Migration of Access data to MySQL
posted bymeetfazaninDatabase-Related
In this tutorial you will learn how to migrate "Access data to MySQL". It is very important for ASP TO PHP Comers.
Enjoy It!
Reviews0
PriceFree
Views1096
ODBC Socket Server
posted bytiminDatabase-Related
This article describes how to make Access and PHP work together using the ODBCSocketServer, an open source socket server, available at http://odbc.linuxave.net/. This tutorial will take you through configuring your machines and using the socket server.
Reviews0
PriceFree
Views1996
Simple Database ORM
posted bysidHussaininDatabase-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.
Reviews0
PriceFree
Views820
SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution
posted bykarl_viinDatabase-Related
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.
Reviews0
PriceFree
Views1284
Creating an object oriented MySQL abstraction class
posted byphptoys2inDatabase-Related
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.
Reviews0
PriceFree
Views2225
Database frontend with PEAR DataGrid and DataObject
posted byylfinDatabase-Related
Structures_DataGrid and DB_DataObject are two PEAR components, which can be connected together, to easily display the data contained in a SQL table, and let the user sort and page through it.
With minimal typing, this tutorial shows you how you can bypass the usual steps of parsing GET parameters, performing SQL requests, and generating HTML content.
Reviews0
PriceFree
Views3147
Accessing a Microsoft SQL Server database from PHP running under Linux
posted byalbertoinDatabase-Related
This article describes how to connect and query an MS SQL server (running under a Windows operating system) from php installed on a unix box.
Reviews0
PriceFree
Views2813
Admin user interface: adding and deleting users
posted bywebmasterinDatabase-Related
This is the second part of creating Web-based admin user interface. This tutorial covers adding and deleting users via Web form using a MySQL database.
Reviews0
PriceFree
Views7493
Interfacing With MS Access 97+
posted bysiddharthv79inDatabase-Related
Here, you will learn how to create an MS Access database and interface with it using PHP on Windows platform. Main topics include: Creating an Access database, Setting up an ODBC Connection, and Interfacing with database.
Reviews0
PriceFree
Views5149
Create a PHP/MySQL Powered Forum from Scratch
posted byseoruchi1inDatabase-Related
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
Reviews0
PriceFree
Views626
MySQL Table Fields Data Typs
posted bynewsourceinDatabase-Related
Learn the three main basic data types used in MySQL and how to utilize them to build a more effective dynamic web site. Lots of web developers use MySQL but not all of them harness the power of these features.
Reviews0
PriceFree
Views1648
Bike
posted bybetacoderinDatabase-Related
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.
Reviews0
PriceFree
Views474
How to Create an AJAX Drop Down Menu with PHP and MySQL
posted byJeremyMorganinDatabase-Related
A quick tutorial to show how you can make interactive AJAX dropdown menus that are database driven.
Reviews0
PriceFree
Views606
SQL tutorial, aggregations
posted byKamil_MoscickiinDatabase-Related
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.
Reviews0
PriceFree
Views419
MongoDB tutorial, introduction to NoSQL
posted byKamil_MoscickiinDatabase-Related
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.
Reviews0
PriceFree
Views633
PHP Spell Check script
posted byfrozenmonkeyinDatabase-Related
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.
Reviews0
PriceFree
Views509
Concatenate strings and fields in MySQL
posted byphpf1inDatabase-Related
This article demonstrates how to concatenate two or more strings and fields in MySQL using the CONCAT() function.
Reviews0
PriceFree
Views459
Record locking in Web applications
posted bybetacoderinDatabase-Related
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.
Reviews0
PriceFree
Views674
PHP and MySQL Introduction Tutorial
posted bydrb072378inDatabase-Related
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.
Reviews0
PriceFree
Views788
Using MySQL Prepared Statements in PHP
posted byStevoTVRinDatabase-Related
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.
Reviews0
PriceFree
Views782