本文整理汇总了PHP中mysqli_fetch_object函数的典型用法代码示例。如果您正苦于以下问题：PHP mysqli_fetch_object函数的具体用法？PHP mysqli_fetch_object怎么用？PHP mysqli_fetch_object使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysqli_fetch_object函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的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 :</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 :</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
示例16: genera_objeto
function genera_objeto($data)
{
while ($result = mysqli_fetch_object($data)) {
$query[] = $result;
}
return $query;
}
开发者ID:gmaimonedlb，项目名称:080914，代码行数:7，代码来源:cargosm.php
示例17: action
/**
* Page のAction.
*
* @return void
*/
function action()
{
/*My own query*/
$servername = "localhost";
$username = "root";
$password = "1234";
$dbname = "rise_up_shop";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
$sql = "SELECT * FROM dtb_brand";
$result = mysqli_query($conn, $sql);
$arr = [];
$i = 0;
while ($row = mysqli_fetch_object($result)) {
$arr[$i]['brand_id'] = $row->brand_id;
$arr[$i]['name'] = $row->name;
$arr[$i]['address'] = $row->address;
$arr[$i]['email'] = $row->email;
$arr[$i]['image_path'] = $row->image_path;
$arr[$i]['website'] = $row->website;
$arr[$i]['description'] = $row->description;
$i++;
}
$this->tpl_subtitle = "Brand Detail";
$this->arrResults = $arr;
}
开发者ID:Rise-Up-Cambodia，项目名称:Rise-Up，代码行数:32，代码来源:LC_Page_Brand_Detail.php
示例18: person_by_id
function person_by_id($id)
{
include 'dbconnect.php';
$query = "SELECT * FROM Person WHERE id = " . $id;
$mysqli_result = mysqli_query($connection, $query);
return mysqli_fetch_object($mysqli_result);
}
开发者ID:verenka，项目名称:notes，代码行数:7，代码来源:person_by_id.php
示例19: get_note_by_note_id
function get_note_by_note_id($id)
{
include 'dbconnect.php';
$query = "SELECT * FROM Notiz WHERE id = " . $id;
$mysqli_result = mysqli_query($connection, $query);
return mysqli_fetch_object($mysqli_result);
}
开发者ID:verenka，项目名称:notes，代码行数:7，代码来源:get_note_by_note_id.php
示例20: listing_bsd_for_manage
function listing_bsd_for_manage()
{
$sql = "SHOW DATABASES";
$link_test = mysqli_connect('localhost', 'root', 'darkevengyl');
$test = mysqli_query($link_test, $sql);
$i = '0';
$res_fx = array();
while ($row = mysqli_fetch_object($test)) {
$res_fx[$i] = $row;
$i++;
}
foreach ($res_fx as $row => $values) {
foreach ($values as $row) {
$new_res_fx[$row] = $row;
}
}
if (isset($new_res_fx['information_schema'])) {
unset($new_res_fx['information_schema']);
}
if (isset($new_res_fx['phpmyadmin'])) {
unset($new_res_fx['phpmyadmin']);
}
if (isset($new_res_fx['mysql'])) {
unset($new_res_fx['mysql']);
}
if (isset($new_res_fx['performance_schema'])) {
unset($new_res_fx['performance_schema']);
}
if (isset($new_res_fx['cdcol'])) {
unset($new_res_fx['cdcol']);
}
if (isset($new_res_fx['webauth'])) {
unset($new_res_fx['webauth']);
}
?>
<div class="col-lg-12">
<div class="col-lg-offset-3 col-lg-6">
<form method="post" action="?nav=intranet&nav_intra=manage_bsd">
<?php
foreach ($new_res_fx as $values) {
?>
<div class="checkbox-inline">
<label>
<input name='db_name' onchange="this.form.submit()" type="checkbox" value='<?php
echo $values;
?>
' />
<?php
echo $values;
?>
</label>
</div>
<?php
}
?>
</form>
</div>
</div><?php
}
开发者ID:evengyl，项目名称:evengyl_be，代码行数:60，代码来源:select_db.php
注：本文中的mysqli_fetch_object函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论