Categories
PHPTips and Tutorials → Database-Related

MySQL - Connecting PHP to Database

This article provides tutorial notes on connecting PHP scripts to MySQl servers. Topics include creating database connection objects; executing INSERT INTO, SELECT, and UPDATE statements from PHP scripts.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

PHP MySQL by examples

Learn by examples how to manipulate your database using PHP. Various methods and practices explained.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Backup all your databases with one click

This is a script usefull mostly to server admins, which will automatically detect all your mysql databases and backup/compress them.
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD,
    • Mac OSX,
    • Sun Solaris
  • Licenses
    • Freeware
DETAILS

Installing phpMyAdmin

This is a guide aimed at getting phpMyAdmin installed on your server in very little time. It covers all the basics, and should get phpMyAdmin running on most servers.
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD,
    • Mac OSX
  • Licenses
    • GPL
DETAILS

SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution

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

Counting records in PHP/mySQL

Following code samples, demonstrates how to count records in a MySQL database table. You may send parameters to query to display only selected range of rows.
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD,
    • Mac OSX,
    • Sun Solaris
  • Licenses
    • Freeware
DETAILS

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

Protecting against SQL injections

SQL injection is a security vulnerability that occurs in the database layer of an application. The vulnerability is present when user input is either incorrectly filtered for string literal escape characters embedded in SQL statements or user input i...
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD,
    • Sun Solaris
  • Licenses
    • GPL
DETAILS

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

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

Page:
©2019 A--9.com