http://www.advancescripts.com/rss/598.htmlDatabase Management RSS feedsen-usCopyright (c) AdvanceScripts All rights reserved. http://www.advancescripts.com/detailed/15651.html In some recent work I needed to have databases created with a back end application. Once the database was created from this online application it was pre filled with tables and data from another script that ran right after the database was made. To create a database with PHP we first need to connect as a user that has the ability to create new databases... http://www.advancescripts.com/detailed/15634.html In this PHP MySQL tutorial I will show you how to use basic database manipulation features in PHP. http://www.advancescripts.com/detailed/15219.html Learn how using dreamweaver can display information stored in a MySQL database. http://www.advancescripts.com/detailed/15016.html 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 http://www.advancescripts.com/detailed/14439.html This tutorial might seem pretty simple and obvious for many advanced webmasters, but some beginners might have some problems. And since I remember I was a bit stuck on this years ago too, why not make things clear for anyone? When do we need to do this? Everytime we install a forum or a CMS that requires an empty database being already created for the install process. http://www.advancescripts.com/detailed/14206.html 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 http://www.advancescripts.com/detailed/14077.html 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. http://www.advancescripts.com/detailed/14011.html If you're using different databases and remote sites to test and/or install scripts. Here is a little class which can prevent some troubles. When connecting a remote mysql_server, it reads a file where all connection items such as host, user.. are stored. http://www.advancescripts.com/detailed/14010.html script to generate a report from a valid mysql connection. The user has to supply which fields he wants to display in table. All properties are changable. http://www.advancescripts.com/detailed/13877.html This DB connectivity class makes it even easier to work with data from MySQL databases. It handles errors, features a better result object, and allows you to iterate through the rows returned by a SELECT query. http://www.advancescripts.com/detailed/13752.html 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. http://www.advancescripts.com/detailed/13745.html 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. a http://www.advancescripts.com/detailed/13354.html If you have a database driven site and you want to optimize MySQL tables then this is perfect. It goes through all the tables in a MySQL database and does table optimization on each one using the MySQL Optimize Table syntax. http://www.advancescripts.com/detailed/13335.html Getting information about databases if essential if you want to write generic and scalable applications. This code shows you how to get information such as all databases on the server, all tables in each database and all field and field info for each table. Even if you do not need to build on this code, you might want to copy the code which prints out all databases, tables and field information plus examples. Its a great way to get an overview of the tables you are working on for a project http://www.advancescripts.com/detailed/13113.html Before you can get content out of your MS SQL database, you must know how to establish a connection to MS SQL Server from inside a PHP script. This tutorial describes how to connect to MS SQL database with a DSN and without a DSN. http://www.advancescripts.com/detailed/13108.html Sometimes it can be useful to have a dump of the current database schema. This script reads the schema from a MySQL database and outputs XML that describes the schema. http://www.advancescripts.com/detailed/13106.html DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone. DSN-less connections don't require creation of system level DSNs for connecting to databases and provide an alternative to DSNs. This tutorial will show you how to connect to an Access database with a DSN and without a DSN. http://www.advancescripts.com/detailed/13007.html Php caching techniques to increase database overhead. Those caching techniques are very useful for high traffic web sites. http://www.advancescripts.com/detailed/12947.html This example use MySQL functions from PHP to display full MySQL table(every column and every row) as HTML. http://www.advancescripts.com/detailed/12857.html 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.