PHP Orm MysqlConnect Examples

Example #1

File: testing.php Project: Mapsred/ORM-LAMP

function deleteById()
{
    $orm = new ORM();
    $sql = new MysqlConnect($orm->getDatabase());
    $sql->deleteById('1');
    $sql->persist($orm);
}

Example #2

File: generator.php Project: Mapsred/ORM-LAMP

require_once 'ORM/MysqlConnect.php';
require_once 'autoload.php';
use ORM\MysqlConnect;
$sql_serveur = $argv[1];
$sql_utilisateur = $argv[2];
$sql_password = $argv[3];
$sql_bd = $argv[4];
$tableName = $argv[5];
$className = $argv[6];
$filename = $className . '.php';
//php generator.php 5.135.191.187 game_test 90sqPDD1b5 game_test actions Game
//php generator.php 5.135.191.187 maps_red 9aEuULSDQtyJMbK2 orm action ORM
// update($table, array $data, $where=""
$database = array($sql_serveur, $sql_utilisateur, $sql_password, $sql_bd);
$mysql = new MysqlConnect($database);
$requete = "SHOW COLUMNS FROM {$tableName}";
$columns = $mysql->querySelect($requete);
$nb = 0;
foreach ($columns as $column) {
    $data = $columns;
    $nb++;
}
$gen = NULL;
$gen .= "<?php \n";
$gen .= "namespace Model\\Database;";
$gen .= "\t\n class {$className} { \n";
$gen .= "\tprotected " . '$sql_serveur' . "= '{$sql_serveur}';\n";
$gen .= "\tprotected " . '$sql_utilisateur' . "= '{$sql_utilisateur}';\n";
$gen .= "\tprotected " . '$sql_password' . "= '{$sql_password}';\n";
$gen .= "\tprotected " . '$sql_bd' . "= '{$sql_bd}';\n";