PHP Classes

PDO MySQL database: Execute common MySQL queries using PDO

Recommend this page to a friend!
     
  Info   View files Example   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 606 All time: 5,157 This week: 206Up
Version License PHP version Categories
pdo-mysql-database 1Artistic License5.0.2PHP 5, Databases
Description 

Author

pedram marandi

This class can execute common MySQL queries using PDO.

It can connect to a MySQL database using the PDO extension and executes common queries given the respective SQL statements.

Currently it executes SQL SELECT, INSERT, DELETE, UPDATE queries, as well return the result row count of a given SELECT query.

Picture of pedram marandi
Name: pedram marandi <contact>
Classes: 2 packages by
Country: Iran Iran
Age: 28
All time rank: 229432 in Iran Iran
Week rank: 321 Up8 in Iran Iran Up

Example

<?php

// Eima
require_once('database.php');


// Delete query from database
$db->delete_pdo('DELETE FROM user WHERE id=2');
// insert into database
$data = array('pedram','123456');
$db->insert_pdo("INSERT INTO user (user, pass) VALUES(?, ?)", $data);
//update PDO
$data=array('Eima','2014');
$db->update_pdo('UPDATE user SET `user`=?, `pass`=?',$data);
//select table
$db->select_pdo("SELECT * FROM user");
foreach($db->result as $value) {
echo $value['user'] . "<br/>";
}
//row count
$db->rowCount_pdo("SELECT * FROM user");
echo $db->result;

// You can use this object to close your connection
// $db->close_pdo();
?>


Details

Developed by Eima
you can use this code to learn how it work

  Files folder image Files  
File Role Description
Files folder imagePDOdatabase (3 files)
Plain text file readme Data about class

  Files folder image Files  /  PDOdatabase  
File Role Description
  Plain text file database.php Class about class
  Plain text file database.sql Data example database
  Plain text file example.php Example Class example

Downloadpdo-mysql-database-2014-07-25.zip 2KB
Downloadpdo-mysql-database-2014-07-25.tar.gz
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:606
This week:0
All time:5,157
This week:206Up
User Comments (1)
it was really good :) Thx i really used it
9 years ago (amir reza Tahani)		70%StarStarStarStar
 

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.