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);
}
