Search Filter
Search Filter
Sort Listings By
Show Only
By Customer Review
Licence Type

Database-Related

Results 21-40 of 61
PHP Database Integration With MySQL
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
(3 ratings)
Reviews0
PriceFree
Views2767
Creating an object oriented MySQL abstraction class
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.
(3 ratings)
Reviews0
PriceFree
Views1958
5 useful PHP functions for MySQL data fetching
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.
(3 ratings)
Reviews0
PriceFree
Views2341
Export Database Schema as XML
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.
(0 ratings)
Reviews0
PriceFree
Views814
Migration of Access data to MySQL
In this tutorial you will learn how to migrate "Access data to MySQL". It is very important for ASP TO PHP Comers. Enjoy It!
(3 ratings)
Reviews0
PriceFree
Views863
Select random records from a MySQL database
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.
(9 ratings)
Reviews0
PriceFree
Views2547
Importing csv data into MySQL with php script
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.
(7 ratings)
Reviews1
PriceFree
Views3791
MySQL Table Fields Data Typs
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.
(3 ratings)
Reviews0
PriceFree
Views1411
Display MySQL table as HTML example
This example use MySQL functions from PHP to display full MySQL table(every column and every row) as HTML.
(9 ratings)
Reviews0
PriceFree
Views4695
MySQL FAQs - Managing Tables and Running Queries with PHP Scripts
A collection of 18 tips on managing tables and data rows with PHP scripts. Clear explanations and tutorial exercises are provided on creating and dropping tables; inserting, updating, and deleting rows, selecting and looping through data rows by pages; setting auto-increment IDs.
(0 ratings)
Reviews0
PriceFree
Views1885
How to connect to MS SQL Server database
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.
(12 ratings)
Reviews0
PriceFree
Views3872
DSN and DSN-less connections
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.
(0 ratings)
Reviews0
PriceFree
Views974
MySQL FAQs - PHP Connections and Query Execution
A collection of 18 FAQs on connecting MySQL server with PHP scritps. Clear explanations and tutorial exercises are provided on MySQL server connection; providing port number, user account and password; selecting or creating database; running SQL statements; checking execution errors.
(0 ratings)
Reviews0
PriceFree
Views1361
PHP Script Tips - Working with MySQL Database
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.
(3 ratings)
Reviews0
PriceFree
Views3441
Check Database Permissions
If you are the root user then it will display all the databases on the server, but if your not the root user then it will show all the databases that your user has permissions for. It's a really fun to play around with and can be expanded in a variety of ways. It's explained in the comments.
(0 ratings)
Reviews0
PriceFree
Views1201
Tutorial: SQL Basics 1 Databases (Creating and Deleting)
This tutorial will explain the basics of core databases in SQL without complicating with mySQL. Will show you the how to create and view databases in the system and how to create and run sql scripts in the monitor and phpMyAdmin further tutorials will go into the basics of tables following with advanced tutorials.
(0 ratings)
Reviews0
PriceFree
Views820
Connecting to mySQL
This is a small tutorial detailing how to connect to mySQL. It is easy to follow and can be pulled right of the site. Ideal for newcomers to PHP that want to look at connecting to databases.
(0 ratings)
Reviews0
PriceFree
Views715
Database frontend with PEAR DataGrid and DataObject
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.
(3 ratings)
Reviews0
PriceFree
Views2688
Mastering phpMyAdmin for Effective MySQL Management
This is the Full chapter 6 from the recently published book 'Mastering phpMyAdmin for Effective MySQL Management'. The Chapter 'Changing Table Structure' give a great step by step guide with diagrams. Publshed in HTML for your enjoyment.
(0 ratings)
Reviews0
PriceFree
Views1574
Dealing with special characters
This tutorial will teach you how to deal with special characters like HTML tags, white space etc. from a user submitted form and database output.
(0 ratings)
Reviews0
PriceFree
Views1279
Results 21-40 of 61