static function insertNewWord($english, $chinese, $example) { $mysqli = DB::getConn(); $sql = "insert into english(english,chinese,example,created_at) values('{$english}','{$chinese}','{$example}',now())"; JTool::println($sql); $mysqli->query($sql); $flag = DB::printError($mysqli); $sql = "select * from english where id = (select max(id) from english);"; $result = $mysqli->query($sql); $arr = $result->fetch_assoc(); $key = new Rediska_Key("allEnglish"); if ($allenglish = $key->getValue()) { $allenglish[] = $arr; $key->setValue($allenglish); } DB::close($mysqli, null, $result); return $flag; }
<?php include_once 'Tool.php'; include_once 'JASEnglishDAO.class.php'; session_start(); if ($_POST['insert']) { $chinese = $_POST['chinese']; $english = $_POST['english']; $example = $_POST['example']; $flag = JASEnglish::insertNewWord($english, $chinese, $example); if ($flag) { $_SESSION['insert'] = true; JTool::printArray($_SESSION); header("location:index.php"); } else { $_SESSION['insert'] = false; header("location:index.php"); } } if ($_POST['findDynamic'] == true) { $arr = JASEnglish::getAll(); $newarr = array(); foreach ($arr as $each) { $i = strpos(strtolower($each['english']), strtolower($_POST['str'])); if ($i !== false) { $newarr[] = $each; } } echo json_encode($newarr); }