Categories
PHPTips and Tutorials → Database-Related

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.
  • Platforms
    • Linux,
    • Windows,
    • Mac OSX,
    • Sun Solaris
  • Licenses
    • Freeware
DETAILS

Alternate row colours using MySQL

This tutorial teaches you how to number rows and give them alternate colours!
  • Platforms
    • Linux,
    • Windows
  • Licenses
    • Freeware
DETAILS

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.
  • Platforms
    • Linux,
    • Windows,
    • Sun Solaris
  • Licenses
    • Other Free / Open Source License
DETAILS

SImple PHP Database Abstraction Class

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.
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD,
    • Mac OSX,
    • Sun Solaris
  • Licenses
    • Freeware
DETAILS

How to create a database and an user in cPanel

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...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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 page...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Install ADOdb Database Abstraction Layer

Do you get stressed out by mysql or other database queries? Do you use multiple databases and wish there was just one way to handle all of your queries? ADOdb is a system that executes queries to any type of database the same way, so you only have ...
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD,
    • Mac OSX,
    • Sun Solaris
  • Licenses
    • Other Free / Open Source License
DETAILS

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.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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 co...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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 stat...
  • Platforms
    • Linux,
    • Windows,
    • Mac OSX,
    • Sun Solaris
  • Licenses
    • Freeware
DETAILS

Page:
©2003-2019 jCay.com