buildSQLInsert PHP Code Examples

Example #1

0

Show file

File: manage_goods.php Project: rooterA/ex01

    $sAct = $_GET['act'];
} else {
    $sAct = '';
}
if (isset($_POST['cancel'])) {
    $sAct = '';
}
//ทำการเพิ่ม
if (isset($_POST['submit_add'])) {
    upLoad('new_Pic_goods');
    if ($_FILES['new_Pic_goods']['name'] != '') {
        $axInsert = array('ID_goods' => "{$_POST['new_ID_goods']}", 'Name_goods' => "{$_POST['new_Name_goods']}", 'Date_goods' => "{$_POST['new_Date_goods']}", 'Type_goods' => "{$_POST['new_Type_goods']}", 'Price_goods' => "{$_POST['new_Price_goods']}", 'Stock_goods' => "{$_POST['new_Stock_goods']}", 'Discount_goods' => "{$_POST['new_Discount_goods']}", 'DiscountDateStart_goods' => "{$_POST['new_DiscountDateStart_goods']}", 'DiscountTimeStart_goods' => "{$_POST['new_DiscountTimeStart_goods']}", 'DiscountDateEnd_goods' => "{$_POST['new_DiscountDateEnd_goods']}", 'DiscountTimeEnd_goods' => "{$_POST['new_DiscountTimeEnd_goods']}", 'Pic_goods' => "./images/" . basename($_FILES["new_Pic_goods"]["name"]), 'Add_goods' => "{$_POST['new_Add_goods']}");
    } else {
        $axInsert = array('ID_goods' => "{$_POST['new_ID_goods']}", 'Name_goods' => "{$_POST['new_Name_goods']}", 'Date_goods' => "{$_POST['new_Date_goods']}", 'Type_goods' => "{$_POST['new_Type_goods']}", 'Price_goods' => "{$_POST['new_Price_goods']}", 'Stock_goods' => "{$_POST['new_Stock_goods']}", 'Discount_goods' => "{$_POST['new_Discount_goods']}", 'DiscountDateStart_goods' => "{$_POST['new_DiscountDateStart_goods']}", 'DiscountTimeStart_goods' => "{$_POST['new_DiscountTimeStart_goods']}", 'DiscountDateEnd_goods' => "{$_POST['new_DiscountDateEnd_goods']}", 'DiscountTimeEnd_goods' => "{$_POST['new_DiscountTimeEnd_goods']}", 'Add_goods' => "{$_POST['new_Add_goods']}");
    }
    $sInsertSql = buildSQLInsert('goods', $axInsert);
    if ($mysqli->query($sInsertSql)) {
        echo "";
    }
    if ($per_page == 5) {
        $next_page = $page + 1;
        echo '<form name="page" method="post" action="' . $_SERVER['PHP_SELF'] . '">', '<input type="hidden" name="page" value="' . $next_page . '">', '<script language="JavaScript">document.page.submit();</script></form>';
    }
    if ($per_page == 0 and $page == 1) {
        echo '<script type="text/javascript">window.setTimeout(window.location="' . $_SERVER['PHP_SELF'] . '",0);</script>';
    }
}
//ทำการลบสินค้าจากฐานข้อมูล
if (isset($_POST['submit_del'])) {
    $sDelSql = buildSQLDelete('goods', 'ID_goods', "{$_POST['ID_goods']}");
    if ($mysqli->query($sDelSql)) {

Example #2

0

Show file

File: manage_key.php Project: rooterA/ex01

//first
$per_page = $mysqli->query('SELECT * FROM `' . DB_NAME . '`.`key` LIMIT ' . $first . ', ' . $limit . '');
$per_page = $per_page->num_rows;
//echo "$per_page";
if (isset($_GET['act'])) {
    $sAct = $_GET['act'];
} else {
    $sAct = '';
}
if (isset($_POST['cancel'])) {
    $sAct = '';
}
//ทำการเพิ่ม
if (isset($_POST['submit_add'])) {
    $axInsert = array('ID_key' => "{$_POST['new_ID_key']}", 'Code_key' => "{$_POST['new_Code_key']}", 'Status_key' => "{$_POST['new_Status_key']}", 'ID_goods' => "{$_POST['new_ID_goods']}");
    $sInsertSql = buildSQLInsert('key', $axInsert);
    if ($mysqli->query($sInsertSql)) {
        echo "";
    }
    if ($per_page == $limit) {
        $next_page = $page + 1;
        echo '<form name="page" method="post" action="' . $_SERVER['PHP_SELF'] . '">', '<input type="hidden" name="page" value="' . $next_page . '">', '<script language="JavaScript">document.page.submit();</script></form>';
    }
    if ($per_page == 0 and $page == 1) {
        echo '<script type="text/javascript">window.setTimeout(window.location="' . $_SERVER['PHP_SELF'] . '",0);</script>';
    }
}
//ทำการลบากฐานข้อมูล
if (isset($_POST['submit_del'])) {
    $sDelSql = buildSQLDelete('key', 'ID_key', "{$_POST['ID_key']}");
    if ($mysqli->query($sDelSql)) {

Example #3

0

Show file

File: fbAjax.php Project: rooterA/ex01

<?php

require './config.php';
require './con_db.php';
require './general.php';
if (isset($_POST) and !isset($_SESSION['login'])) {
    $_SESSION['login']['status'] = true;
    $_SESSION['login']['type'] = 'facebook';
    $_SESSION['login']['table'] = 'user';
    $_SESSION['login']['id'] = $_POST['fbpost']['id'];
    $iID = $_SESSION['login']['id'];
    $result = $mysqli->query("SELECT * FROM user WHERE Type_user = '******' AND ID_user = {$iID} ");
    $row = $result->fetch_assoc();
    if (empty($row)) {
        $axInsert = array('ID_user' => $_SESSION['login']['id'], 'Name_user' => $_POST['fbpost']['name'], 'Type_user' => 'facebook');
        $sInsertSql = buildSQLInsert('user', $axInsert);
        if ($mysqli->query($sInsertSql)) {
            echo "1";
        }
    } else {
        $axUpdate = array('Name_user' => $_POST['fbpost']['name']);
        $sEditSql = buildSQLUpdate('user', 'ID_user', "{$iID}", $axUpdate);
        if ($mysqli->query($sEditSql)) {
            echo "1";
        }
    }
}

Example #4

0

Show file

File: steamsearch.php Project: rooterA/ex01

	<div style="height:100px"></div>
	<?php 
if (!empty($jData)) {
    $rate = $mysqli->query('SELECT * FROM `' . DB_NAME . '`.`payrate`');
    $rate = $rate->fetch_assoc();
    //inserting a new steam goods or updating.
    $iID = $jData['ID_gsteam'];
    $result = $mysqli->query("SELECT * FROM gsteam WHERE ID_gsteam = {$iID} ");
    $row = $result->fetch_assoc();
    //debug jData do not matched with database.
    $sqlData = $jData;
    if (isset($sqlData['apps'])) {
        unset($sqlData['apps']);
    }
    if (empty($row)) {
        $sInsertSql = buildSQLInsert('gsteam', $sqlData);
        $mysqli->query($sInsertSql);
    } else {
        $sEditSql = buildSQLUpdate('gsteam', 'ID_gsteam', "{$iID}", $sqlData);
        $mysqli->query($sEditSql);
    }
    ?>
	<div class="container">
		<div class="row">

			<div class="col-md-4">
				<?php 
    echo '<img src="' . $jData['Pic_gsteam'] . '">';
    ?>
				<p>
					<?php

PHP buildSQLInsert Examples