function LoadGachaBase() { echo 'LoadGachaBase<br>'; $jsonData = LoadJsonFile("GachaBase.txt"); $TotalGachaBaseRate = 0; DeleteData("GachaBase"); foreach ($jsonData as $key => $value) { $TotalGachaBaseRate = $TotalGachaBaseRate + $value['RATE']; InsertRedis_Hash("GachaBase", $value['ID'], $TotalGachaBaseRate); } DeleteData("TotalGachaBaseRate"); InsertRedis("TotalGachaBaseRate", $TotalGachaBaseRate); }
//何も入力されていなかったら PrintForm(); } if ($_SERVER["REQUEST_METHOD"] == "POST") { if (isset($_POST['standard_form'])) { //標準フォームを入力したあとの処理 if ($_POST['edit_num'] == null) { //編集対象番号が入力されていない場合標準フォーム出力 PrintForm(); } else { //編集対象番号が入力されている場合編集フォーム出力 PrintFormEdit(); } if ($_POST["delete_num"] != null) { //削除対象番号が入力されている場合 DeleteData(); } else { if ($_POST["edit_num"] == null) { //編集対象番号に入力がなければ WriteData(); } } } else { if (isset($_POST["edit_form"])) { //編集フォームを入力した後の処理 PrintForm(); EditData(); } } } ReadData();
function deleteBlogComment($id) { $id = intval($id); if (!is_int($id)) { return false; } DeleteData('blog_comment', array('blog_comment_id' => $id)); return true; }
<?php require "common_super.php"; ob_start(); include "jobinfo.php"; $x_jobid = @$_GET["jobid"]; $conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT); $sDbWhere = " jobId={$x_jobid} "; if (DeleteData($sDbWhere, $conn)) { $_SESSION[ewSessionMessage] = "Delete Successful"; phpmkr_db_close($conn); ob_end_clean(); header("Location: joblist.php"); exit; } //------------------------------------------------------------------------------- // Function DeleteData // - Delete Records based on input sql criteria sqlKey function DeleteData($sqlKey, $conn) { global $x_jobid; $sFilter = $sqlKey; // Backup the record before delete $sSql = ewBuildSql(ewSqlSelect, ewSqlWhere, ewSqlGroupBy, ewSqlHaving, ewSqlOrderBy, $sFilter, ""); $query = phpmkr_query($sSql, $conn) or die("Failed to execute query at line " . __LINE__ . ": " . phpmkr_error($conn) . '<br>SQL: ' . $sSql); while ($temp = phpmkr_fetch_array($query)) { $oldrs[] = $temp; } // Delete $sSql = "DELETE FROM `job`"; $sWhere = "";