Exemplos de MySQLProvider::closeconnect em PHP

Exemplo n.º 1

Arquivo: categories_model.php Projeto: nguyenanhtu/ecommerce

 function insert_cat($name, $desc, $data)
 {
     $mysql = new MySQLProvider();
     $query = "insert into categories(category,description,image)" . "values('" . $name . "','" . $desc . "','" . mysql_real_escape_string($data, $mysql->getconnect()) . "')";
     $result = $mysql->getresult($query);
     $mysql->closeconnect();
 }

Exemplo n.º 2

Arquivo: products_model.php Projeto: nguyenanhtu/ecommerce

 function insert_up($pid, $filename, $filetype)
 {
     $mysql = new MySQLProvider();
     $query = "insert into upload(prod_id,file_name,file_type)" . "values('" . $pid . "','" . $filename . "','" . $filetype . "')";
     $result = $mysql->getresult($query);
     $mysql->closeconnect();
 }

Exemplo n.º 3

Arquivo: image_prod.php Projeto: nguyenanhtu/ecommerce

<?php

require "../includes/mysql.php";
$mysql = new MySQLProvider();
$query = "SELECT * FROM products Where id ='" . $_GET["id"] . "'";
$result = $mysql->getresult($query);
if ($row = mysql_fetch_array($result)) {
    $content = $row['image_small'];
    header('Content-type: image/jpeg');
    echo $content;
}
$mysql->closeconnect();