本文整理汇总了PHP中mysqli_fetch_assoc函数的典型用法代码示例。如果您正苦于以下问题:PHP mysqli_fetch_assoc函数的具体用法?PHP mysqli_fetch_assoc怎么用?PHP mysqli_fetch_assoc使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysqli_fetch_assoc函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: check_user
function check_user($uid, $link)
{
$query = "SELECT sid FROM " . USERS_TABLE . " WHERE uid='{$uid}';";
$result = mysqli_query($link, $query) or die(mysqli_error());
$row = mysqli_fetch_assoc($result);
return $row["sid"] == SID ? true : false;
}
开发者ID:TssDragon,项目名称:intess,代码行数:7,代码来源:uni-auth.php
示例2: deleteInstitution
function deleteInstitution($institutionId)
{
//Delete all children of Institution
$conn = connectToDatabase();
mysqli_begin_transaction($conn, MYSQLI_TRANS_START_READ_WRITE);
$sql = "SELECT CURP FROM BelongsToInstitution WHERE institutionId = '{$institutionId}';";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_assoc($result)) {
deleteChildSameConnection($row["CURP"], $conn);
}
}
//Delete all users from institution
$sql = "SELECT userName FROM WorksInInstitution WHERE institutionId = '{$institutionId}';";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_assoc($result)) {
deleteUserSameConnection($row["userName"], $conn);
}
}
$sql = "DELETE FROM Institution WHERE institutionId = '{$institutionId}'";
if (mysqli_query($conn, $sql)) {
echo "1";
} else {
echo "0" . mysqli_error($conn);
}
mysqli_commit($conn);
closeDb($conn);
}
开发者ID:EduardoVaca,项目名称:KidsMatter,代码行数:29,代码来源:deletes.php
示例3: view
public function view()
{
$sql = "SELECT * FROM herramientas WHERE idHerramienta = '{$this->idHerramienta}'";
$datos = $this->con->consultaRetorno($sql);
$row = mysqli_fetch_assoc($datos);
return $row;
}
开发者ID:fernandoparada18,项目名称:ptms,代码行数:7,代码来源:Herramienta.php
示例4: validateUser
function validateUser($user, $pass, $pass_confirm)
{
$valueToRetun = 0;
$validUsernameOrNot = validUsername($user);
$validPasswordOrNot = validPassword($pass);
//check to see if username exists
$sqlQuery = "SELECT * FROM users WHERE username = '{$user}'";
$result = mysqli_query($connection, $sqlQuery);
$row = mysqli_fetch_assoc($result);
if ($row != "") {
$valueToReturn = 1;
} else {
if ($validUsernameOrNot && $validPasswordOrNot) {
$valueToReturn = 2;
//Username and password is valid
} else {
if (!$validUsernameOrNot) {
$valueToReturn = 3;
//Username is not valid format
} else {
if (!$validPasswordOrNot) {
$valueToReturn = 4;
//Password is not valid format
} else {
if (strcmp($pass, $pass_confirm) !== 0) {
$valueToReturn = 5;
//Password confirmation is incorrect
}
}
}
}
}
mysql_free_result($result);
return $valueToReturn;
}
开发者ID:gdanielyan,项目名称:Email-Scheduler,代码行数:35,代码来源:webservice.php
示例5: view
public function view()
{
$sql = "SELECT t1.*, \n t2.nombre as nombre_seccion\n FROM estudiantes t1 \n INNER JOIN secciones t2 \n ON t1.id_seccion = t2.id\n WHERE t1.id = '{$this->id}'";
$datos = $this->con->consultaRetorno($sql);
$row = mysqli_fetch_assoc($datos);
return $row;
}
开发者ID:Esandex,项目名称:POO,代码行数:7,代码来源:Estudiante.php
示例6: post_query
function post_query($col)
{
include 'conn.php';
// Get the number of row of a table
$sql = "SELECT count(id) FROM blog";
$query = mysqli_query($conn, $sql);
$row = mysqli_fetch_row($query);
// Catch the session variable from another page
$n = $_SESSION['var'];
for ($i = 1; $i <= $row[0]; $i++) {
$sql = "SELECT * FROM blog where id = {$n} order by time asc";
// For query
$query = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($query);
if ($col == 'post_detail') {
str_cut($row['post_detail']);
break;
} elseif ($col == 'author') {
echo $row['author'];
break;
} elseif ($col == 'time') {
echo $row['time'];
break;
} elseif ($col == 'post_heading') {
echo $row['post_heading'];
break;
} elseif ($col == 'image') {
echo $row['image'];
break;
} elseif ($col == 'id') {
echo $row['id'];
break;
}
}
}
开发者ID:Amely228,项目名称:Portfolio,代码行数:35,代码来源:functions.php
示例7: validaUsuario
/**
* Função que valida um usuário e senha
*
* @param string $usuario - O usuário a ser validado
* @param string $senha - A senha a ser validada
*
* @return bool - Se o usuário foi validado ou não (true/false)
*/
function validaUsuario($usuario, $senha)
{
global $_SG;
$cS = $_SG['caseSensitive'] ? 'BINARY' : '';
// Usa a função addslashes para escapar as aspas
$nusuario = addslashes($usuario);
$nsenha = addslashes($senha);
// Monta uma consulta SQL (query) para procurar um usuário
$sql = "SELECT `id`, `nome` FROM `" . $_SG['tabela'] . "` WHERE " . $cS . " `usuario` = '" . $nusuario . "' AND " . $cS . " `senha` = '" . $nsenha . "' LIMIT 1";
$query = mysqli_query($sql);
$resultado = mysqli_fetch_assoc($query);
// Verifica se encontrou algum registro
if (empty($resultado)) {
// Nenhum registro foi encontrado => o usuário é inválido
return false;
} else {
// Definimos dois valores na sessão com os dados do usuário
$_SESSION['usuarioID'] = $resultado['id'];
// Pega o valor da coluna 'id do registro encontrado no MySQL
$_SESSION['usuarioNome'] = $resultado['nome'];
// Pega o valor da coluna 'nome' do registro encontrado no MySQL
// Verifica a opção se sempre validar o login
if ($_SG['validaSempre'] == true) {
// Definimos dois valores na sessão com os dados do login
$_SESSION['usuarioLogin'] = $usuario;
$_SESSION['usuarioSenha'] = $senha;
}
return true;
}
}
开发者ID:emersonandre,项目名称:projeto-indicadores-autoviacao,代码行数:38,代码来源:seguranca.php
示例8: createOpenInvoiceList
function createOpenInvoiceList()
{
$currentDate = date('Ymd');
$res = mysqli_query_check("select count(*) as cnt from {prefix}invoice i where i.deleted = 0 AND i.interval_type > 0 AND i.next_interval_date <= {$currentDate} AND i.archived = 0");
$row = mysqli_fetch_assoc($res);
if ($row['cnt'] > 0) {
createList('open_invoices', 'invoice', 'resultlist_repeating_invoices', $GLOBALS['locLabelInvoicesWithIntervalDue'], "i.interval_type > 0 AND i.next_interval_date <= {$currentDate} AND i.archived = 0", true);
}
$open = '';
$res = mysqli_query_check('SELECT id FROM {prefix}invoice_state WHERE invoice_open=1');
while ($id = mysqli_fetch_value($res)) {
if ($open) {
$open .= ', ';
}
$open .= $id;
}
$unpaid = '';
$res = mysqli_query_check('SELECT id FROM {prefix}invoice_state WHERE invoice_unpaid=1');
while ($id = mysqli_fetch_value($res)) {
if ($unpaid) {
$unpaid .= ', ';
}
$unpaid .= $id;
}
if ($open) {
createList('open_invoices', 'invoice', 'resultlist_open_invoices', $GLOBALS['locLabelOpenInvoices'], "i.state_id IN ({$open}) AND i.archived=0", true);
}
if ($unpaid) {
createList('open_invoices', 'invoice', 'resultlist_unpaid_invoices', $GLOBALS['locLabelUnpaidInvoices'], "i.state_id IN ({$unpaid}) AND i.archived=0", true, true);
}
}
开发者ID:jahau,项目名称:MLInvoice,代码行数:31,代码来源:open_invoices.php
示例9: verificar_login
function verificar_login($userid, $pass, &$result)
{
$servername = "localhost";
$username = 'root';
$password = "";
$dbname = "cmd";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT * FROM `trabajador` WHERE `userid`=\"" . $userid . "\" and `password`=\"" . $pass . "\"";
$result = mysqli_query($conn, $sql);
$count = 0;
if (!$result) {
echo "no result";
} else {
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_assoc($result)) {
$_SESSION['userid'] = $row["userid"];
$_SESSION['rol'] = $row["rol"];
$count++;
}
}
if ($count == 1) {
return 1;
} else {
return 0;
}
}
}
开发者ID:AGonzalezMaillard,项目名称:CMDashboard,代码行数:32,代码来源:index.php
示例10: fetch_record
function fetch_record($query)
{
global $connection;
$result = $connection->query($query);
return mysqli_fetch_assoc($result);
//return $result->fetch_assoc();
}
开发者ID:aespidol,项目名称:wall,代码行数:7,代码来源:new-connection.php
示例11: queryToArray
public static function queryToArray($sql)
{
global $my_user, $my_pass, $my_host, $my_db, $config_enable_cache;
$link = Database::getLink();
$db_selected = mysqli_select_db($link, $my_db);
if (!$db_selected) {
die('Can\'t use ' . $my_db . ' : ' . mysqli_error($link));
}
// Perform Query
$result = mysqli_query($link, $sql);
$id = mysqli_insert_id($link);
if ($id > 0) {
// we did an insert, just return the id
return $id;
}
//echo ("\ndatabase qtoa before proc id is $id");
if (!$result) {
$message = 'Invalid query: ' . mysqli_error($link) . "\n";
$message .= 'Whole query: ' . $sql;
die($message);
}
if ($result === true) {
// probably an insert..
return false;
}
$rows = array();
while ($row = mysqli_fetch_assoc($result)) {
$rows[] = $row;
}
return $rows;
}
开发者ID:OpenDAWN,项目名称:evosynth,代码行数:31,代码来源:inc.php
示例12: getRank
function getRank($a, $b, $c)
{
include 'config.php';
$con = mysqli_connect($IP, $user, $pass, $db);
// echo "select `idCategory` from Placed where `idBid`=$c and `idAuction`=$a";
// echo "select `idCategory` from Placed where `idBid`=$c and `idAuction`=$a";
//echo "select `idCategory` from Placed where `idBid`=$c and `idAuction`=$a";
// $result=mysqli_query($con,"select `idCategory` from Placed where `idBid`=$c and `idAuction`=$a") or die(mysqli_error($con));
$result = mysqli_query($con, "select `idCategory` from Placed where `idBid`={$c} and `idAuction`={$a}") or die(mysqli_error($con));
// echo "select count(*)+1 as rank from Placed where `Price`>$b and `idAuction`=$a and `status` = 'A'";
// echo json_encode($result);
// echo mysqli_num_rows($result);
$row = mysqli_fetch_assoc($result);
$c = $row['idCategory'];
// echo $c.'sdf';
if (empty($c)) {
return 0;
}
// echo "select count(*)+1 as rank from Placed where `Price`>$b and `idCategory`=$c and `idAuction`=$a and `status` = 'A'";
//echo "select count(*)+1 as rank from Placed where `Price`>$b and `idCategory`=$c and `idAuction`=$a and `status` = 'A'";
$result = mysqli_query($con, "select count(*)+1 as rank from Placed where `Price`>{$b} and `idCategory`={$c} and `idAuction`={$a} and `status` = 'A'") or die("Error" . mysqli_error($con));
$output = [];
while ($row = mysqli_fetch_assoc($result)) {
return $row['rank'];
}
}
开发者ID:jeevan6,项目名称:CSL343_Networking_Errands,代码行数:26,代码来源:getRank.php
示例13: query
function query($SQL, $select = false)
{
static $CONFIG = ['server' => 'localhost', 'username' => 'root', 'password' => 'root', 'database' => 'wt'];
static $connection;
if (!isset($connection)) {
// Create connection
$connection = mysqli_connect($CONFIG['server'], $CONFIG['username'], $CONFIG['password'], $CONFIG['database']);
if (!$connection) {
die('Could not connect to database!');
}
}
if ($select) {
// IS A SELECT QUERY, RETURN ARRAY
$results = mysqli_query($connection, $SQL);
$toReturn = [];
if (mysqli_num_rows($results) > 0) {
while ($result = mysqli_fetch_assoc($results)) {
array_push($toReturn, $result);
}
}
return $toReturn;
} else {
// RETURN BOOL
if (mysqli_query($connection, $SQL)) {
return true;
} else {
return false;
}
}
// Execute SQL
}
开发者ID:s1d130050131516,项目名称:wt,代码行数:31,代码来源:connectivity.php
示例14: preffAction
public function preffAction(Request $request)
{
$Applicant_id = $request->get('id');
$result = get_all_schools();
$schools = array();
while ($row = mysqli_fetch_assoc($result)) {
array_push($schools, $row);
}
$postData = $request->request->all();
if (isset($postData['submit']) && isset($postData['school'])) {
$count = 0;
foreach ($postData['school'] as $school) {
if (isset($school['sid']) && $school['id'] != "") {
$connection = connect();
$no = $school['id'];
$sch_id = $school['sid'];
$query = "insert into applicant_has_school (";
$query .= " Applicant_id, school_id, preferrence_no";
$query .= ") values( ";
$query .= " '{$Applicant_id}','{$sch_id}','{$no}'";
$query .= ")";
$result = mysqli_query($connection, $query);
colse_connection($connection);
}
$count++;
}
return $this->redirectToRoute('childrenofstaff_new', array('id' => $Applicant_id));
}
return $this->render('applicant/preferrence.html.twig', array('schools' => $schools, 'id' => $Applicant_id));
}
开发者ID:KanchanaMalsha,项目名称:Database-Project,代码行数:30,代码来源:ApplicantController.php
示例15: Populate
function Populate()
{
//mysql connection
$con = mysqli_connect("eu-cdbr-azure-west-a.cloudapp.net", "b8592f1b44ff9a", "fecb2128", "TeamProject");
if (mysqli_connect_errno()) {
$result = "f";
} else {
//query
$query = "SELECT Name,Email FROM Subscriber";
$result = mysqli_query($con, $query);
//initialize arrays
$i = 0;
$subnames = array();
$submails = array();
//loop through the database populating
while ($sub = mysqli_fetch_assoc($result)) {
$subnames[$i] = $sub['Name'];
$submails[$i] = $sub['Email'];
$i++;
}
//close conection and return
mysqli_close($con);
return array($subnames, $submails);
}
}
开发者ID:alexandroskou,项目名称:Repository1,代码行数:25,代码来源:Notify.php
示例16: searchPost
public function searchPost($searchtext)
{
if (!empty($searchtext)) {
$sql = "SELECT * FROM posts\n WHERE MATCH (title)\n AGAINST ('" . $searchtext . "' IN NATURAL LANGUAGE MODE)";
} else {
$sql = "SELECT * FROM posts ";
}
$query = mysqli_query($this->con, $sql);
$postArray = array();
// var_dump($query);
// exit;
if ($query) {
while ($row = mysqli_fetch_assoc($query)) {
$myPost = new BlogPostModel();
$myPost->setId($row['id']);
$myPost->setTitle($row['title']);
$myPost->setSummary($row['body']);
$myPost->setDateCreated($row['created']);
array_push($postArray, $myPost);
}
return $postArray;
} else {
header('Location: ?action=search');
}
}
开发者ID:Hirannuwanpriya,项目名称:code-samples,代码行数:25,代码来源:PostModel.php
示例17: docleanup
/**
* https://github.com/Bigjoos/
* Licence Info: GPL
* Copyright (C) 2010 U-232 v.3
* A bittorrent tracker source based on TBDev.net/tbsource/bytemonsoon.
* Project Leaders: Mindless, putyn.
*
*/
function docleanup($data)
{
global $INSTALLER09, $queries, $mc1;
set_time_limit(0);
ignore_user_abort(1);
//=== delete from now viewing after 15 minutes
sql_query('DELETE FROM now_viewing WHERE added < ' . (TIME_NOW - 900));
//=== fix any messed up counts
$forums = sql_query('SELECT f.id, count( DISTINCT t.id ) AS topics, count(p.id) AS posts
FROM forums f
LEFT JOIN topics t ON f.id = t.forum_id
LEFT JOIN posts p ON t.id = p.topic_id
GROUP BY f.id');
while ($forum = mysqli_fetch_assoc($forums)) {
$forum['posts'] = $forum['topics'] > 0 ? $forum['posts'] : 0;
sql_query('update forums set post_count = ' . sqlesc($forum['posts']) . ', topic_count = ' . sqlesc($forum['topics']) . ' where id=' . sqlesc($forum['id']));
}
if ($queries > 0) {
write_log("Forum clean-------------------- Forum cleanup Complete using {$queries} queries --------------------");
}
if (false !== mysqli_affected_rows($GLOBALS["___mysqli_ston"])) {
$data['clean_desc'] = mysqli_affected_rows($GLOBALS["___mysqli_ston"]) . " items updated";
}
if ($data['clean_log']) {
cleanup_log($data);
}
}
开发者ID:CharlieHD,项目名称:U-232-V3,代码行数:35,代码来源:forum_update.php
示例18: view
public function view()
{
$sql = "SELECT * FROM secciones WHERE id = '{$this->id}'";
$datos = $this->con->consultaRetorno($sql);
$row = mysqli_fetch_assoc($datos);
return $row;
}
开发者ID:Randy-ak47,项目名称:ProjectsPhp-Curso01,代码行数:7,代码来源:Seccion.php
示例19: showDevices
function showDevices($con)
{
// Select all the rows in the markers table
$query = "SELECT \n" . " gd.*, \n" . " gowner.gps_owner_name as gps_owner_name \n" . "FROM \n" . " gps_device gd \n" . " left join gps_owner gowner on gd.gps_device_id = gowner.gps_owner_id \n" . "ORDER BY \n" . " gd.gps_device_id;";
$result = mysqli_query($con, $query);
if (!$result) {
die('Invalid query: ' . mysql_error());
}
echo "<table border='1' style='width:100%' class='table'>\n";
echo "<thead><tr>\n";
echo "<th>id</th>\n";
echo "<th>device id</th>\n";
echo "<th>name</th>\n";
echo "<th>desc</th>\n";
echo "<th>comment</th>\n";
echo "<th>owner</th>\n";
echo "<th>delete</th>\n";
echo "</tr></thead>\n";
echo "<tbody>\n";
while ($row = @mysqli_fetch_assoc($result)) {
$ownersSQL = "SELECT gps_owner_id, gps_owner_name from gps_owner \n" . "order by gps_owner_id";
$ownersDropDown = buildDropDown($con, $ownersSQL, $row['gps_owner_id'], "owner", "gps_device", "gps_owner_id", "gps_owner_name", "gps_device_id", $row['gps_device_id'], true);
echo "<td>" . $row['gps_device_id'] . "</td>\n";
echo getTableRow($row, "gps_device_local_id", "gps_device", "gps_device_id", "", "");
echo getTableRow($row, "gps_device_name", "gps_device", "gps_device_id", "", "");
echo getTableRow($row, "gps_device_desc", "gps_device", "gps_device_id", "", "");
echo getTableRow($row, "gps_device_comment", "gps_device", "gps_device_id", "", "");
echo "<td>" . $ownersDropDown . "</td>\n";
echo "<td><a onclick='updateDelete(\"gps_entries\", \"gps_device_id\", \"NULL\", \"gps_device\", \"gps_device_id=" . $row['gps_device_id'] . "\", true)' href='javascript:void(0);'>[X]</a></td>\n";
echo "</tr>\n";
}
echo "</tbody>\n";
echo "</table>\n";
}
开发者ID:vivek779,项目名称:phpGPS,代码行数:34,代码来源:editDevices.php
示例20: fetch
public function fetch()
{
if ($this->queryResult) {
return mysqli_fetch_assoc($this->queryResult);
}
return false;
}
开发者ID:anton-christensen,项目名称:p2_software,代码行数:7,代码来源:db.php
注:本文中的mysqli_fetch_assoc函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论