PHP mysqli_fetch_Assoc Exemples

Exemple #1

Fichier : functions.php Projet : benhiggs/A-level-computing-project-moodle-progress-viewer-git

    } else {
        //if class doesnt exist, add class to database
        $query = mysqli_query($con, "SELECT teacherid FROM login INNER JOIN teachers on login.userid=teachers.userid WHERE username='******'");
        $result = mysqli_fetch_assoc($query);
        $teacherid = $result['teacherid'];
        $query = "INSERT INTO classlist (teacherid,classname) VALUES ('{$teacherid}','{$classname}')";
        if (mysqli_query($con, $query)) {
            $_SESSION["error"] = 0;
            $_SESSION["addednewclass"] = True;
            header("Location:options.php");
        }
    }
}
if (isset($_POST['removeclass'])) {
    $classname = $_POST["classnames"];
    $classid = mysqli_fetch_Assoc(mysqli_query($con, "SELECT classid FROM classlist WHERE classname='" . $classname . "'"))['classid'];
    //no validation required due to drop down list, so just delete
    mysqli_query($con, "DELETE FROM classlist WHERE classname='" . $classname . "'");
    mysqli_query($con, "DELETE FROM classstudent WHERE classid='" . $classid . "'");
    $_SESSION["error"] = 0;
    $_SESSION["deleted"] = True;
    header("Location:options.php");
}
if (isset($_POST['removeuser'])) {
    $username = $_POST["username"];
    $classname = $_POST["classlist"];
    //check username exists
    $query = mysqli_query($con, "SELECT * FROM login WHERE username='******'");
    $checkusername = mysqli_num_rows($query);
    if ($checkusername != 1) {
        $_SESSION["error"] = 11;

Exemple #2

Fichier : index.php Projet : MogiYuichiro/seed_sns

// 通常、index.phpが表示された時
if ($page == '') {
    $page = 1;
}
// max関数：（）内に指定した複数のデータから、一番大きい値を返す
// ①表示する正しいページの数値（Min）を設定
$page = max($page, 1);
// あいまい検索処理
if (isset($_GET['search_word']) && !empty($_GET['search_wrod'])) {
    $sql = sprintf('SELECT COUNT(*) AS cnt FROM `tweets` WHERE `tweet` LIKE "%%%s%%"', mysqli_real_escape_string($db, $_GET['search_word']));
} else {
    $sql = sprintf('SELECT COUNT(*) AS cnt FROM `tweets`');
}
// ②必要なページ数を計算する
$recordSet = mysqli_query($db, $sql) or die(mysqli_error($db));
$table = mysqli_fetch_Assoc($recordSet);
// ceil()関数：切り上げ
$maxPage = ceil($table['cnt'] / 5);
// ③表示する正しいページ数の数値（Max）を設定
$page = min($page, $maxPage);
// ④ページに表示する件数だけ取得
$start = ($page - 1) * 5;
$start = max(0, $start);
if (isset($_GET['search_word']) && !empty($_GET['search_word'])) {
    $sql = sprintf('SELECT m.nick_name, m.picture_path, t.* FROM `tweets` t, `members` m WHERE t.member_id = m.member_id AND t.tweet LIKE "%%%s%%" ORDER BY t.created DESC LIMIT %d, 5', mysqli_real_escape_string($db, $_GET['search_word']), $start);
} else {
    // 投稿内容を取得する
    $sql = sprintf('SELECT m.nick_name, m.picture_path, t.* FROM `tweets` t, `members` m WHERE t.member_id = m.member_id ORDER BY t.created DESC LIMIT %d, 5', $start);
}
$tweets = mysqli_query($db, $sql) or die(mysqli_error($db));
if (isset($_REQUEST['res'])) {