当前位置: 首页>>代码示例>>PHP>>正文


PHP mysqli_fetch_object函数代码示例

本文整理汇总了PHP中mysqli_fetch_object函数的典型用法代码示例。如果您正苦于以下问题:PHP mysqli_fetch_object函数的具体用法?PHP mysqli_fetch_object怎么用?PHP mysqli_fetch_object使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。


在下文中一共展示了mysqli_fetch_object函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: verify_email

function verify_email($user, &$result)
{
    $dbhost = 'localhost';
    $dbusername = 'root';
    /*usuario de base de datos*/
    $dbuserpass = '';
    /*contraseña, la deje en blanco para pruebas*/
    $dbname = 'practicantes';
    /*nombre de la base de datos*/
    $con = mysqli_connect($dbhost, $dbusername, $dbuserpass) or die("Error al intentar conectarse a la BD");
    /*creamos el enlace a la bd*/
    if (!$con) {
        echo "Error: Unable to connect to MySQL." . PHP_EOL;
        echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
        echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
        exit;
    }
    $sql = "SELECT email FROM usuarios WHERE email='{$user}'";
    $rec = mysqli_query($con, $sql);
    $count = 0;
    while ($row = mysqli_fetch_object($rec)) {
        $count++;
        $result = $row;
    }
    if ($count == 1) {
        return 1;
    } else {
        return 0;
    }
}
开发者ID:bertinperez,项目名称:reclutamiento,代码行数:30,代码来源:formularios.php

示例2: __construct

 function __construct($username, $password, $tenantID)
 {
     if (strlen($username) == 0 || strlen($password) == 0) {
         throw new Exception("Invalid username or password.");
     }
     $userDetails = User::getUserDetails($username);
     if ($userDetails["active"] == 0) {
         throw new Exception("This user account is inactive. Please check your email for activation instructions.");
     } else {
         $saltedPassword = Utility::saltAndHash($password, $userDetails["password"]);
         //echo 'salted:' . $saltedPassword;
         //echo Utility::saltAndHash($password);
         $query = 'call validateUser(' . Database::queryString($username);
         $query .= ',' . Database::queryString($saltedPassword);
         $query .= ',' . Database::queryNumber($tenantID) . ');';
         $result = Database::executeQuery($query);
         if (!$result) {
             throw new Exception('Unable to validate that username/password combination.');
         } else {
             $userid = 0;
             while ($o = mysqli_fetch_object($result)) {
                 $userid = $o->userid;
                 $name = $o->name;
             }
             if ($userid > 0) {
                 $this->id = $userid;
                 $this->name = $name;
             } else {
                 throw new Exception("Unable to validate that username/password combination.");
             }
         }
     }
 }
开发者ID:robertmoss,项目名称:foodfinder_main,代码行数:33,代码来源:user.php

示例3: get_all_server

 static function get_all_server()
 {
     $db = mysqli_connect($_SESSION['db_host'], $_SESSION['db_user'], $_SESSION['db_password'], $_SESSION['db_database']);
     $result = mysqli_query($db, "SELECT * FROM `server` where test_system != 'true'");
     while ($row = mysqli_fetch_object($result)) {
         $i = $row->server_id;
         $obj_name = "server" . $i;
         ${$obj_name} = new server();
         ${$obj_name}->server_id = $row->server_id;
         ${$obj_name}->hostname = $row->hostname;
         # Fra Space
         $result2 = mysqli_query($db, "SELECT * FROM `system_parameter` WHERE `server_id` = {$row->server_id} and `parameter_name` = 'fra-space' order by time desc");
         while ($row2 = mysqli_fetch_object($result2)) {
             ${$obj_name}->fra_space = $row2->value_string;
         }
         # Fra Used Space
         $result2 = mysqli_query($db, "SELECT * FROM `system_parameter` WHERE `server_id` = {$row->server_id} and `parameter_name` = 'fra-used-space' order by time desc");
         while ($row2 = mysqli_fetch_object($result2)) {
             ${$obj_name}->fra_used_space = $row2->value_string;
         }
         # Build all instance objects
         ${$obj_name}->instances = instance_actions::get_instance_by_server($row->hostname);
         $arr_obj[] = ${$obj_name};
     }
     return $arr_obj;
 }
开发者ID:ghoneycutt,项目名称:Oracle-DB-parameter-monitor,代码行数:26,代码来源:class_server_actions.php

示例4: retourneDevoirs

function retourneDevoirs($ele_login)
{
    $date_ct1 = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
    // On récupère tous les devoirs depuis aujourd'hui 00:00:00
    $sql = "SELECT DISTINCT ctde.* FROM ct_devoirs_entry ctde, j_eleves_groupes jeg\r\n\t\t\t\t\t\t\t\tWHERE ctde.id_groupe = jeg.id_groupe\r\n\t\t\t\t\t\t\t\tAND jeg.login = '" . $ele_login . "'\r\n\t\t\t\t\t\t\t\tAND ctde.date_ct >= '" . $date_ct1 . "'\r\n\t\t\t\t\t\t\tORDER BY ctde.date_ct, ctde.id_groupe;";
    //echo "$sql<br />";
    $res_ct = mysqli_query($GLOBALS["mysqli"], $sql);
    $cpt2 = 0;
    // on initialise un compteur pour le while
    if (mysqli_num_rows($res_ct) > 0) {
        while ($lig_ct = mysqli_fetch_object($res_ct)) {
            $tab_ele['cdt_dev'][$cpt2] = array();
            $tab_ele['cdt_dev'][$cpt2]['id_ct'] = $lig_ct->id_ct;
            $tab_ele['cdt_dev'][$cpt2]['id_groupe'] = $lig_ct->id_groupe;
            $tab_ele['cdt_dev'][$cpt2]['date_ct'] = $lig_ct->date_ct;
            $tab_ele['cdt_dev'][$cpt2]['id_login'] = $lig_ct->id_login;
            $tab_ele['cdt_dev'][$cpt2]['contenu'] = $lig_ct->contenu;
            $cpt2++;
        }
        $tab_ele['cdt_dev']['count'] = $cpt2;
    } else {
        $tab_ele['cdt_dev']['count'] = 0;
    }
    return $tab_ele;
}
开发者ID:rhertzog,项目名称:lcs,代码行数:25,代码来源:fonctions_cdt.inc.php

示例5: fetchObj

 public function fetchObj()
 {
     if ($this->_result) {
         return $this->_row = mysqli_fetch_object($this->_result);
     }
     return false;
 }
开发者ID:spineag,项目名称:farm505-back-end,代码行数:7,代码来源:OwnMySQLI.php

示例6: datapages

function datapages()
{
    if ($_SESSION['userinfo']['status'] === 1) {
        $conn = new mysqli('localhost', 'root', '12345password12345', 'main');
        if ($conn->connect_error) {
            die("Connection failed: " . $conn->connect_error);
        }
        $num_rows_res = $conn->query("SELECT count(*) FROM mlib;");
        $num_rows = mysqli_fetch_array($num_rows_res, MYSQLI_NUM)[0];
        for ($i = 1; $i <= $num_rows; $i++) {
            $pages_sql = "Select * FROM mlib WHERE c_id=" . $i . ";";
            $pages_res = $conn->query($pages_sql);
            $pages[$i] = mysqli_fetch_object($pages_res);
        }
        $conn->close();
    } else {
        $conn = new mysqli('localhost', 'root', '12345password12345', 'main');
        if ($conn->connect_error) {
            die("Connection failed: " . $conn->connect_error);
        }
        $num_rows_res = $conn->query("SELECT count(*) FROM mlib WHERE viewers='all';");
        $num_rows = mysqli_fetch_array($num_rows_res, MYSQLI_NUM)[0];
        for ($i = 1; $i <= $num_rows; $i++) {
            $pages_sql = "Select * FROM mlib WHERE c_id=" . $i . " AND viewers='all';";
            $pages_res = $conn->query($pages_sql);
            $pages[$i] = mysqli_fetch_object($pages_res);
        }
        $conn->close();
    }
    return $pages;
}
开发者ID:easonkamander,项目名称:temp,代码行数:31,代码来源:index.php

示例7: getGcmIds

function getGcmIds($link, $id)
{
    $query = "SELECT user_gcm_id FROM device_user WHERE user_id = '{$id}'";
    $resultado = mysqli_query($link, $query) or die("Erro na consulta: " . mysqli_error($link));
    $gcId = mysqli_fetch_object($resultado);
    return $gcId->user_gcm_id;
}
开发者ID:jonatasleon,项目名称:gcm-example-php,代码行数:7,代码来源:index.php

示例8: listDbData

function listDbData()
{
    $link = mysqli_connect('localhost', 'root', '') or die(mysql_error());
    $db_list = mysql_list_dbs($link);
    print "<table width=100% bgcolor='BLACK' cellspacing=1 cellpadding=0>";
    print "<tr bgcolor=#BBBBBB><td align='center'>";
    print "<b>Database list</b>";
    print "</td></tr>";
    while ($row = mysqli_fetch_object($link, $db_list)) {
        print "<tr bgcolor='WHITE'><td align='center'>";
        print $row->Database;
        //echo $row->Database . "<br>";
        print "</td></tr>";
    }
    print "<tr bgcolor=#BBBBBB><td align='center'>";
    print "<b>Tables</b>";
    print "</td></tr>";
    $db_selected = mysqli_select_db('maxinedb', $link);
    $sql = "SHOW TABLES";
    $result = mysqli_query($link, $sql);
    if (!$result) {
        throw new man_exception('MySQL Error: ' . mysql_error());
    }
    while ($row = mysqli_fetch_row($link, $result)) {
        print "<tr bgcolor='WHITE'><td align='center'>";
        print $row[0] . "";
        print "</td></tr>";
    }
    print "</table>";
}
开发者ID:RoneilZA,项目名称:dashboards,代码行数:30,代码来源:manapi.php

示例9: replaceEntityURLs

 static function replaceEntityURLs(&$object)
 {
     global $wpdb;
     self::mapObjects($object);
     $urls = implode("','", array_map(function ($e) {
         return addslashes($e[0]->singleUrl);
     }, array_filter(self::$objects, function ($e) {
         return (bool) $e[0]->singleUrl;
     })));
     $query = "SELECT post_ID, meta_value FROM {$wpdb->postmeta} WHERE meta_value IN('{$urls}')";
     if ($wpdb->use_mysqli) {
         $rs = mysqli_query($wpdb->dbh, $query);
         while ($obj = @mysqli_fetch_object($rs)) {
             $post_permalink = get_permalink($obj->post_ID);
             if (isset(self::$objects[$obj->meta_value]) && is_array(self::$objects[$obj->meta_value])) {
                 foreach (self::$objects[$obj->meta_value] as $o) {
                     $o->singleUrl = $post_permalink;
                 }
             }
         }
     } else {
         $rs = mysql_query($query);
         while ($obj = @mysql_fetch_object($rs)) {
             $post_permalink = get_permalink($obj->post_ID);
             if (isset(self::$objects[$obj->meta_value]) && is_array(self::$objects[$obj->meta_value])) {
                 foreach (self::$objects[$obj->meta_value] as $o) {
                     $o->singleUrl = $post_permalink;
                 }
             }
         }
     }
 }
开发者ID:centroculturalsp,项目名称:cultural,代码行数:32,代码来源:mapasculturais-api-proxy.php

示例10: MessageGetInfo

function MessageGetInfo($idMessage)
{
    $query = "SELECT * FROM `message` WHERE `idMessage`='{$idMessage}';";
    $result = QueryExcuteWhile($query);
    $o = mysqli_fetch_object($result);
    return $o;
}
开发者ID:iLi-Studios,项目名称:iLi-Manager.1.0,代码行数:7,代码来源:read.php

示例11: verif_proportion_garcons_filles

function verif_proportion_garcons_filles()
{
    global $projet;
    $retour = "";
    $sql = "SELECT DISTINCT classe FROM gc_divisions WHERE projet='{$projet}' AND statut='future' ORDER BY classe;";
    $res = mysqli_query($GLOBALS["mysqli"], $sql);
    if (mysqli_num_rows($res) > 0) {
        while ($lig = mysqli_fetch_object($res)) {
            $sql = "SELECT 1=1 FROM gc_eleves_options geo, eleves e WHERE projet='" . $projet . "' AND classe_future='" . $lig->classe . "' AND e.sexe='F' AND geo.login=e.login;";
            $res_f = mysqli_query($GLOBALS["mysqli"], $sql);
            $eff_f = mysqli_num_rows($res_f);
            $sql = "SELECT 1=1 FROM gc_eleves_options geo, eleves e WHERE projet='" . $projet . "' AND classe_future='" . $lig->classe . "' AND e.sexe='M' AND geo.login=e.login;";
            $res_m = mysqli_query($GLOBALS["mysqli"], $sql);
            $eff_m = mysqli_num_rows($res_m);
            $eff_total = $eff_m + $eff_f;
            if ($eff_total >= 20) {
                if ($eff_f / $eff_total >= 2 / 3) {
                    $retour .= "<br /><strong>ATTENTION&nbsp;:</strong> La sélection courante de {$lig->classe} présente plus de 2/3 de filles.";
                } elseif ($eff_m / $eff_total >= 2 / 3) {
                    $retour .= "<br /><strong>ATTENTION&nbsp;:</strong> La sélection courante de {$lig->classe} présente plus de 2/3 de garçons.";
                }
            }
        }
    }
    return $retour;
}
开发者ID:alhousseyni,项目名称:gepi,代码行数:26,代码来源:gc_func.inc.php

示例12: handleForm

function handleForm()
{
    global $db;
    $firstname = $_POST['firstname'];
    $lastname = $_POST['lastname'];
    $email = $_POST['email'];
    $role = $_POST['role'];
    $f = $s = $e = $r = "";
    if (isset($_POST['save'])) {
        //save one record
        $statement = "INSERT INTO users (firstname, lastname, email, type) VALUES\n    ('{$firstname}','{$lastname}','{$email}','{$role}')";
        if ($result = mysqli_query($db, $statement)) {
            echo "<h3 style='color: green'>One row added to the database</h3>";
        } else {
            echo "<h3 style='color: red'>There was a problem saving your data</h3>";
        }
    } elseif (isset($_POST['amend'])) {
        //alter one record
        $statement = "UPDATE users SET firstname='{$firstname}', lastname='{$lastname}', type='{$role}' WHERE email='{$email}'";
        if ($result = mysqli_query($db, $statement)) {
            echo "<h3 style='color: green'>Database updated successfully</h3>";
        } else {
            echo "<h3 style='color: red'>There was a problem updating your data</h3>";
        }
    } elseif (isset($_POST['delete'])) {
        //delete one record
        $statement = "DELETE FROM users WHERE email='{$email}'";
        if ($result = mysqli_query($db, $statement)) {
            echo "<h3 style='color: green'>One row deleted from the database</h3>";
        } else {
            echo "<h3 style='color: red'>There was a problem deleting your data. Make sure that you entered the correct email address.</h3>";
        }
    } elseif (isset($_POST['view'])) {
        //view one record
        $statement = "SELECT * FROM users WHERE email='{$email}'";
        if ($result = mysqli_query($db, $statement)) {
            echo "<h3>Your query returned</h3>";
            $data = mysqli_fetch_object($result);
            $f = $data->firstname;
            $s = $data->lastname;
            $e = $data->email;
            $r = $data->type;
        } else {
            echo "<h3 style='color: red'>There was a problem finding the row. Please check that you entered the correct email address</h3>";
        }
    } else {
        //must be showall
        $statement = "SELECT * FROM users";
        if ($result = mysqli_query($db, $statement)) {
            echo "<h3>Your query returned</h3><table border='1'>";
            while ($data = mysqli_fetch_object($result)) {
                echo "<tr><td>{$data->firstname}</td><td>{$data->lastname}</td>\n          <td>{$data->email}</td><td>{$data->type}</td></tr>";
            }
            echo "</table>";
        } else {
            echo "<h3 style='color: red'>There was a problem retrieving data.</h3>";
        }
    }
    printForm($f, $s, $e, $r);
}
开发者ID:Virunee,项目名称:database,代码行数:60,代码来源:index.php

示例13: buildPage

function buildPage()
{
    global $mysql;
    $MySQLConnection = new Mysql($mysql['host'], $mysql['port'], $mysql['user'], $mysql['password'], $mysql['database']);
    $MySQLConnection->connect();
    if ($result = $MySQLConnection->getQuery('SELECT messageID, messageRecipient, messageSender, messageTime, messageSubject, messageBody, userLogin, userID FROM messages JOIN users ON  messageSender = userID WHERE messageRecipient = ' . $_SESSION["userID"] . ' LIMIT 0,25;')) {
        echo '
					<div class="col-md-2">
				';
        while ($row = mysqli_fetch_object($result)) {
            $messageJSON = (string) json_encode($row);
            echo '
						<div class="list-group">
							<a href="#" onclick="displayMessage(\'' . $row->messageID . '\');"" class="list-group-item">
								<p class="list-group-item-text">' . $row->messageTime . ' - ' . $row->userLogin . '</p>
								<h4 class="list-group-item-heading">' . $row->messageSubject . '</h4>
							</a>
						</div>
					';
        }
        echo '</div>';
    } else {
        echo '<script type="text/javascript">', 'printError(\'Error while getting your messages!\')', '</script>';
    }
}
开发者ID:TheRedJackal,项目名称:tippchampion,代码行数:25,代码来源:messages.php

示例14: login

function login($user, $password, &$result)
{
    $dbhost = 'localhost';
    $dbusername = 'root';
    /*usuario de base de datos*/
    $dbuserpass = '';
    /*contraseña, la deje en blanco para pruebas*/
    $dbname = 'practicantes';
    /*nombre de la base de datos*/
    $con = mysqli_connect($dbhost, $dbusername, $dbuserpass, $dbname);
    if (!$con) {
        echo "Error: Unable to connect to MySQL." . PHP_EOL;
        echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
        echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
        exit;
    }
    $sql = "SELECT usuario, password FROM usuarios WHERE usuario='" . $user . "' AND password='" . $password . "';";
    $rec = mysqli_query($con, $sql);
    $count = 0;
    while ($row = mysqli_fetch_object($rec)) {
        $count++;
        $result = $row;
    }
    if ($count == 1) {
        return 1;
    } else {
        return 0;
    }
}
开发者ID:bertinperez,项目名称:reclutamiento,代码行数:29,代码来源:sesion.php

示例15: look_config_default_values

function look_config_default_values($field_name, $like = '', $default_values = '')
{
    if ($like == '') {
        $sql = "select NAME,IVALUE,TVALUE,COMMENTS from config where NAME in ";
        $arg_sql = array();
        $arg = mysql2_prepare($sql, $arg_sql, $field_name);
    } else {
        $arg['SQL'] = "select NAME,IVALUE,TVALUE,COMMENTS from config where NAME like '%s'";
        $arg['ARG'] = $field_name;
    }
    $resdefaultvalues = mysql2_query_secure($arg['SQL'], $_SESSION['OCS']["readServer"], $arg['ARG']);
    while ($item = mysqli_fetch_object($resdefaultvalues)) {
        $result['name'][$item->NAME] = $item->NAME;
        $result['ivalue'][$item->NAME] = $item->IVALUE;
        $result['tvalue'][$item->NAME] = $item->TVALUE;
        $result['comments'][$item->NAME] = $item->COMMENTS;
    }
    if (is_array($default_values)) {
        foreach ($default_values as $key => $value) {
            $key = strtolower($key);
            if (is_array($value)) {
                foreach ($value as $name => $val) {
                    if (!isset($result[$key][$name]) or $result[$key][$name] == '') {
                        $result[$key][$name] = $val;
                    }
                }
            }
        }
    }
    return $result;
}
开发者ID:remicollet,项目名称:OCSInventory-ocsreports,代码行数:31,代码来源:function_commun.php


注:本文中的mysqli_fetch_object函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。