PHP Classes

MySQLi Prepared Statements: Execute MySQL queries using prepared statements

Recommend this page to a friend!
  Info   View files Example   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 192 All time: 8,521 This week: 174Up
Version License PHP version Categories
mysqli-prepared-stmt 1.0.0GNU General Publi...5.3PHP 5, Databases


This class can execute MySQL queries using prepared statements.

It can connect to a given MySQL database using the MySQLi extension.

The class can execute plain SQL queries or queries with parameters using prepared statements to pass the parameter values.

The parameter values are passed along the SQL query string in a single call as an array that defines either the parameter value and its type.

Queries that retrieve result sets return the results as arrays. The range of result set rows to be returned can be limited.


SQL injection safe DB layer
I want DB layer that have SQL Injection safe structure

Picture of Sung-Whi Kim
Name: Sung-Whi Kim <contact>
Classes: 1 package by
Country: France France
Age: 55
All time rank: 4134103 in France France
Week rank: 578 Up20 in France France Up

  Files folder image Files  
File Role Description
Accessible without login Plain text file db_test.sql Data The sql script to create the sample databse
Plain text file db.php Class The class file
Accessible without login Plain text file example.php Example Sample script showing usage

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:8,521
This week:174Up