Top Rated Scripts | PHP | Tutorials & Tips | Database-Related
PHP Database Integration With MySQL
posted bychetu_akarteinDatabase-Related
One of the defining features of PHP is the versatility it offers for connection to, and manipulation with, databases. In this article, we look at some features of the PHP and MySQL combination. We shall go through the following steps:- Connect to MySQL Database Server
Create new Database
Select MySQL Database
Add data to table
Retrieve data
Error Handling
Reviews0
PriceFree
Views3260
MySQL backup tutorial
posted byphpf1inDatabase-Related
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.
Reviews0
PriceFree
Views1071
Backup all your databases with one click
posted byNikolas0inDatabase-Related
This is a script usefull mostly to server admins, which will automatically detect all your mysql databases and backup/compress them.
Reviews0
PriceFree
Views1421
phpMyAdmin Tutorial: Transformations & PDF-Features
posted bygarvininDatabase-Related
After having worked through this tutorial you will be able to:
* know how the additional phpMyAdmin features using special seperate tables work and how to set them up
* store pictures inside a MySQL table and view them from within phpMyAdmin
* put specific transformations on any of your columns
* create your own transformations, even with active PHP-code in it!
* create PDF pages of your table layout, with relations and individually positioned ER-models
At the end of this tutorial there's also some hints on getting the most out of your phpMyAdmin config file, showing you some configuration directives which seem to get less public attention.
Reviews0
PriceFree
Views4362
Uploading, Saving and Downloading Binary Data in a MySQL Database
posted byjcpminDatabase-Related
This article is aimed at answering one of the most asked questions on the PHP mailing list and discussion forums alike: How to store binary files in a MySQL database. This article is split into three pages: Setting up the database, Creating the 'upload' scripts, and Creating the 'download' script. Includes the complete source code for all the scripts involved.
Reviews0
PriceFree
Views5728
PHP Script Tips - Working with MySQL Database
posted bykarl_viinDatabase-Related
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.
Reviews0
PriceFree
Views3824
Random MySQL result-set
posted byfcharruainDatabase-Related
This sample script produces a result set of random rows from a table. It does so by populating one of the columns with a random number, and then doing a select statement that uses it to sort the results.
Reviews0
PriceFree
Views2870
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
Views2001
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
Views1106
5 useful PHP functions for MySQL data fetching
posted byAnshargalinDatabase-Related
PHP usually comes with mysql extension mysql (mysql_... functions) which is rather low-level and requires writing too much code for a trivial tasks: error-checked execution of SQL queries, getting single row from SQL table, getting value from SQL table cell, etc. OOP mysqli extension isn't any better. In this article we present 5 useful functions which greatly simplify majority of real-life MySQL operations.
Reviews0
PriceFree
Views2942
PHP MySQL Tutorial
posted byphpcakeinDatabase-Related
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.
Reviews1
PriceFree
Views7075
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
Views836
Importing csv data into MySQL with php script
posted bywebmasterinDatabase-Related
This tutorial will show you how to import csv data into MYSQL with a simple PHP script.
Many times you have to write a script because the import function in phpMyAdmin will not import
the way you want.
Reviews1
PriceFree
Views4189
Database Normalization And Design Techniques
posted bybwiseinDatabase-Related
One of the most important factors in dynamic web page development is database definition. If your tables are not set up properly, it can cause you a lot of headaches down the road when you have to perform miraculous SQL calls in your PHP code in order to extract the data you want. By understanding data relationships and the normalization of data, you will be better prepared to begin developing your application in PHP. This 6-page article describes the data relationships and the normalization of data using a simple example.
Reviews0
PriceFree
Views4828
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
Views2821
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
Views3153
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
Views2235
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
Views1293
PHP and MySQL examples
posted byshedboyinDatabase-Related
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.
Reviews0
PriceFree
Views11707
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
Views5159