 |
|
Top 1 to 50 Database-Related - PHP scripts at Programsdb.com |
Scripts are listed afer popularity. To display the scripts after name please click here
1)
Count and display the number of rows in a mysql database table
This tutorial code helps to count the amount of entries or records in a MySQL database table and outputs the total number of records.
2)
Using PHP and MySQL
Using PHP and MySQL is an article which explains the basics of MySQL, how to create a database and add tables to it and how the PhpMyAdmin helps the creation of database. For this, the author gives some sample PHP code functions to learn easily.
3)
Microsoft Access Database ODBC and PHP
Microsoft Access Database ODBC and PHP is a tutorial to know about the Microsoft Access Database ODBC and PHP and connections between PHP and ODBC. The author teaches for preparing databases and how to configure our ODBC sources with some codes and functions.
4)
PHP Mysql Tutorial for Beginners
Tutorial for beginners in php and mysql that will clearly show them the basics of working with mysql databases and php.
5)
Website Database Basics With PHP and MySQL
Website Database Basics With PHP and MySQL is an article that gives solution for making your visitor to search for information on your website and also add to it. For this purpose, the author says that creation of database on a website is necessary.
6)
Viewing MySQL table
Viewing MySQL table is a tutorial that teaches how to output any database table into the HTML page ignoring the number of columns and rows the table contains. The author gives some sample functions to get this.
7)
PHP,MySQL Tutorial
This is a complete PHP, MySQL tutorial that covers installation instructions for Unix and Windows. It also offers PHP/MySQL goodies and secrets that will turn your simple data-driven site into an useful application with some examples.
8)
Database Abstraction with PEAR
Database Abstraction with PEAR is a tutorial which teaches a method of coding that lets you to concentrate on coding and PEAR includes a database abstration class that you can use in your scripts. This article focus on PEAR for database abstration.
9)
ADOdb MySQL Tutorial
ADOdb MySQL Tutorial teaches about how PHP accesses every database slightly in a different way. To overcome this difficulties, a database wrapper libray like ADODB is handy when you need to ensure portablility.
10)
Building Next/Prev Buttons for Query Results
Building Next/Prev Buttons for Query Results is a tutorial which tells the users how to create next and previous buttons for query result by using php.
11)
Database Normalization And Design Techniques
Database Normalization And Design Techniques is a tutorial that tells the users how to normalize the data and for developing their application using php.
12)
Random MySQL result-set
This is an easy to learn database related tutorial which teaches you how to produce a result set of random rows from a table. The only thing is that you have to initialize the variables at the beginning of the script.
13)
A Contact Database using MySQL and PHP
This article shows how to improve a web interface to a contact database using MySQL and PHP. The author says that this two offers speed, security and rich feature.
14)
Admin user interface: adding and deleting users
Admin user interface: adding and deleting users is a tutorial that tells the users how to add and delete users with admin interface by using php.
15)
PHP - Previous and Next Links
PHP - Previous and Next Links is an article which teaches how to add previous and next links in your web pages and is for the people who are familiar with basic PHP syntax and know how to use PHP to query a database.
16)
Oracle and PHP
Oracle and PHP is a tutorial that describes how to utilize the PHP built-in functions to work with an Oracle database with the assumption of Oracle and PHP are installed correctly.
17)
Alternating row colors with PHP and mySQL
Alternating row colors with PHP and mySQL is a tutorial which explains how to alternate table row colours using PHP and MySQL. The author gives some sample code functions for easy understanding.
18)
MySQL Table Joins
This article discusses about the join command of MySQL. This can develop access and modify data across various tables.
19)
Building database table handlers in PHP using OO approach
Building database table handlers in PHP using OO approach is an article about separating database-related login in Object-Oriented fashion. This tutorial is mainly for PHP programmers for understanding basic object oriented ideas and SQL.
20)
SQL execution time
SQL execution time is a tutorial that explains how to show overall time spent for executing PHP code and the time spent for executing SQL queries and show the percentage of time overall for MySQL only. The author gives some codes and functions for doing this.
21)
Sorting Database Results with PHP
This tutorial describes how to show your data from a database and gives the user choice to sort the data by different columns. The author gives some PHP code functions for displaying this easily.
22)
Accessing a Microsoft SQL Server database from PHP running under Linux
Accessing a Microsoft SQL Server database from PHP running under Linux is a tutorial that explains the users how to connect and access an ms SQL server from php installed on a unix box.
23)
Doing Simple DB Abstraction in PHP
Doing Simple DB Abstraction in PHP is a tutorial that tells the users how to create their own database API which can be to used with different types of databases by using php. This tutorial provide detail to the users that should modify it to their needs.
24)
Static HTML Generation With PHP
Static HTML Generation With PHP is a tutorial that teaches to create static html pages with some simple PHP scripts and makes your website run faster and minimize your MySQL
database queries drastically.
25)
Web Database Tutorial (PHP & MySQL)
Web Database Tutorial (PHP & MySQL) is an article that teaches about the generation of web database programme using PHP and MySQL on a Unix platform or Mac OS X or Linux with the assumption of your system running with Apache web server. Some codes and functions are given for easy understanding.
26)
Formatting Date/Time value
Formatting date/time value is an article showing the date and time functions of MySQL assuming that you have the common date/time data storing format ie-Time stamp column in the table. The author differentiate the use of PHP and MySQL functions and gives examples.
27)
Best Practices: Database Abstraction
This tutorial is a study of some common database access methods and a comparative study of PEAR database abstraction class with them. The author gives some sample programmes for this study.
28)
Script Web databases quickly with PHP scripting language
This is an article that discusses about PHP script and how it is flexible and works with databases like Informix, Microsoft SQL Server, mSQL, MySQL, ODBC, Oracle and Sybase. The author concludes that PHP is the ideal tool for handling databases in your Web development.
29)
Preparation for using LDAP to SQL
Preparation for using LDAP to SQL is a tutorial for getting relational data from a hierarchical structure. The author used PHP for tackling this difficulty to query and provide snap shots regularly.
30)
Using PHP with ODBC
From this article you can learn the usage of PHP's open database connectivity functions in getting connected with MS SQL server database to retrieve the necessary data.
31)
Creating dynamic Web sites with PHP and MySQL
Creating dynamic Web sites with PHP and MySQL is a tutorial aimed at developers who are new to PHP and MySQL. This narrates how to create dynamic websites with PHP and MySQL in a easy way.
32)
Interfacing With MS Access 97 plus
Interfacing With MS Access 97+ is a narration of creating an access database to use, setting up an ODBC connection and finally interfacing with database.
33)
Displaying Data In a MySQL Database
It is an easy to learn tutorial in which the author discusses about the process of displaying the data in the database and the method of generating a table for database and the method of inserting data into the database table.
34)
Alternating Row Colors
This simple tutorial tell the readers how to alternate the colour of the rows in a table, it also discusses on how to create a table and connecting the database.
35)
SQL Database Function Wrappers
SQL Database Function Wrappers is a tutorial that explains the users how to create functions that will eliminate some unwanted redundancy while transacting with database by using php.
36)
Oracle vs. MySQL: loading the data
This is an useful article that relates the efficiency of both Oracle and MySQL database in loading data from text files. This user guide brings out the advantages of MySQL database over the Oracle database.
37)
Creating and accessing MySQL data with PHP
This tutorial describes you some basics of how to access data with your PHP scripting to collect information in a MySQL database. For this, you must have some knowledge about MySQL.
38)
Database connection in a class of its own
Database connection in a class of its own is a tutorial that discusses about the usage of basic object-oriented techniques which reduces the difficulties of connecting and interacting with a database.
39)
So You Want to Use a Database in Your Site?
This article discusses about how to use a database in your website. For this purpose, the author uses many sample codes and a simple SQL query interface for easy understanding.
40)
Access Granted
Access Granted is an article that explains the basics of popular MySQL database and MySQL grant tables which are an integral part of the server security system.
41)
PHP and Accessing MySQL Databases
PHP and Accessing MySQL Databases is an article showing how to a access MySQL database data easily with PHP script with some websites for easy reference.
42)
Printing leaf items
Printing leaf items is an article which explains what is leaf items? how many leaf items are here? how to store informations in the tree structure using MySQL database with some simple programmes.
43)
MySQL(TM) manual in MS HTML Help
This tutorial describes what is Myman and its conversion into HTML help. How this conversion brings the usage of MySQL more comfortable? What are the requirements? with some reference sites.
44)
The MySQL Grant Tables
The MySQL Grant Tables is an article that explains the process in which the MySQL server accepts or cancells the user privileges, and highlights the newest five tables that provides this control.
45)
Setting Up Database Driven Websites
This tutorials guides to setup a MySQL database, Apache server, PHP and a web enabled database for setting up a database driven website.
46)
Coding Ground - PHP and MySQL tutorial
Coding Ground - PHP and MySQL tutorial that provides users with the method of creating dynamic webpages using PHP and MySQL. Users are also provided with the details of creating databases and tables to recieve and store input data.
47)
PHP4 Session Handler using ADODB
PHP4 Session Handler using ADODB is a tutorial that teaches the users how to handle sessions with ADODB by using php4. This article is useful for the beginners and webmasters.
48)
SQL Theory & How-To
This tutorial discusses the two question ie- how do you build complex queries on the fly according to user input? and how to create powerful, complex queries to take advantages of your table schemas.
49)
Using PHP to search a MySQL database and return paged results
Using PHP to search a MySQL database and return paged results is an article for searching and getting results in a MySQL database content. The author gives some sample programmes for this. Knowledge of PHP and MySQL is a must.
50)
PHP with mySQL introduction
PHP with MySQL introduction is a tutorial that teaches basic MySQL interaction by making a link database. The author gives some simple code for this for easy understanding. This article is useful for new PHP programmers to understand what is happening while interaction.
Browse Pages: |< 1 [2] >> >|
|
|
|
 |
|
|
