|
|
|
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.
Version: n/a
Platforms: linux, windows, freebsd, sun
Last Updated: March 26, 2007 |
|
|
|
|
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.
Version: 1.0
Platforms: linux, windows, freebsd, osx, sun
Last Updated: April 12, 2007 |
|
|
|
|
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.
Version: n/a
Platforms: n/a
Last Updated: April 13, 2007 |
|
|
|
|
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
Version: 1.0.0
Platforms: linux, windows, freebsd, sun
Last Updated: May 08, 2007 |
|
|
|
|
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.
Version: 1.0
Platforms: linux, windows, freebsd, osx, sun
Last Updated: May 29, 2007 |
|
|
|
|
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 is not strongly typed and thereby unexpectedly executed. It is in fact an instance of a more general class of vulnerabilities that can occur whenever one programming or scripting language is embedded inside another.
Version: 1.0
Platforms: linux, windows, freebsd, sun
Last Updated: June 02, 2007 |
|
|
|
|
