Results 1 to 8 of 8
Thread: PHP - mysqli_query Ìîëÿ çà ïîìîù
Hybrid View
-
28th November 2012 11:08 #1
PHP - mysqli_query Ìîëÿ çà ïîìîù
Çäðàâåéòå,
êàðàì äèðåêòíî:
Èìàì áàçà äàííè email_list ñ òðè ïîëåòà - first_name,last_name,email.
è åäèí ðåä John,Simpson,john@yahoo.com
Ôàéëà êîéòî èçïîëçâà áàçàòà å show_data.php
PHP Code:$dbc = mysqli_connect('localhost','root','','customersDB') or die('Error connecting to MySQL server.');
$query = "SELECT first_name,last_name FROM email_list WHERE email='peter@yahoo.com'";
$result = mysqli_query($dbc,$query) ;
if(!$result){
echo 'No people found!';
}else{
while($row = mysqli_fetch_array($result)){
echo $row['first_name']. ' '.$row['last_name'].'<br />';
}
}
Àêî â $query çàäàì âàëèäåí èìåéë ïðèñúñòâàù â áàçàòà, elsa ñè âúðøè ðàáîòàòà, íî àêî å íåïðèñúñòâàù èìåéë if íå äåéñòâà.
var_dump($result) ïðè íåïðèñúñòâàù èìåéë âðúùà
Êúäå å çàðîâåíî êó÷åòî? Ïîìîãíåòå ìè PHP äåòåêòèâèCode:object(mysqli_result)[2] public 'current_field' => null public 'field_count' => null public 'lengths' => null public 'num_rows' => null public 'type' => null

-
28th November 2012 11:22 #2
Àìè âàð äúìï-à ïðàâèëíî òè å ïîêàçàë, êúäå å ïðîáëåìà òîãàâà?
Ïðè âñè÷êè ñëó÷àè ïðè âàëèäíà çàÿâêà (áåç çíà÷åíèå äàëè å ïðàçíà), $result ñúäúðæà íåùî (îáåêò), è if (!$result) íÿìà êàê äà âúðíå èñòèíà.
Òîÿ òåñò òè ïîêàçâà ñàìî äàëè íå å ãðúìíàëà ñàìàòà çàÿâêà (ïðèìåðíî àêî å íåïðàâèëíà êàòî ñèíòàêñèñ).
Ïîëçâàé ïðèìåðíî num_rows() ìåòîäà íà âúðíàòèÿ mysqli_result îáåêò, çà äà âèäèø äàëè èìà âúðíàòè ðåäîâå.
Edit: ñîðè, ìîÿ ãðåøêà, èìàõ ïðåäâèä num_rows ïðîïåðòèòî îò îáåêòà, à íå ìåòîäà, ò.å.
$result->num_rows > 0.Last edited by tedych; 28th November 2012 at 11:50.
-
28th November 2012 11:36 #3
tedych eé òî÷íî òàÿ ôóíêöèÿ ìè òðÿáâàøå. Ìíîãî òè áëàãîäàðÿ! È òîëêîâà áúðçî îòãîâîðè! Ïîêëîí.
×åðïíÿòà å â ìåí
-
28th November 2012 11:52 #4Registered User
Join Date: Jul:2005
Location: Sofiq
Posts: 2,798
mysqli_result
Áè òðÿáâàëî ñïîðåä äîêóìåíòàöèÿòà â $result->num_rows äà èìàø áðîÿ íà ñåëåêíàòèòå ðåäîâå.mysqli_result implements Traversable {
/* Properties */
int $current_field ;
int $field_count;
array $lengths;
int $num_rows;
.....
}
-
28th November 2012 11:55 #5
Äà, ñîðè, àç ñè áÿõ åäèòíàë âå÷å ãîðíèÿ ïîñò, íÿìà ìåòîä, à ïðîïåðòèòî.
Îòäàâíà íå ïîëçâàì äèðåêòíî òåçè íåùà, à ìèíàâàò ïðåç ìîè êúñòúì àáñòðàêöèè (êëàñîâå), òà ïîíÿêîãà ñå ïîçàáðàâÿò òàêèâà äåòàéëè
.
À è âñè÷êè çíàåì êîëêî "èíòóèòèâíè", "êîíñèñòåíòíè" è "äîáðå èìåíóâàíè" ñà ôóíêöèèòå, êëàñîâåòå è ìåòîäèòå â ÏÕÏ êàòî öÿëî. Íàïðàâî êðåùÿò äà ãè ïîìíèø íàèçóñò
.
-
28th November 2012 11:58 #6
Àç ãî íàïðàâèõ
è êîäà çàòèêòàêà.PHP Code:
....
if(!mysqli_num_rows($result)){
echo 'No people found!';
}else{
while($row = mysqli_fetch_array($result)){
echo $row['first_name']. ' '.$row['last_name'].' '.$row['email'].'<br />';
}
}
....
Îùå âåäíúæ áëàãîäàðÿ, ñóïåð ñòå!
-
28th November 2012 12:02 #7
Î äà, òè ïîëçâàøå ïðîöåäóðíèÿ ïîõâàò
. Òî ðåàëíî îòçàä âñå ñå ïîëçâà è îáåêòíèÿ, à ïðîöåäóðèòå (ôóíêöèèòå) ñà òàì ïðîñòî äà å ïî-ëåñíî çà èäâàùèòå îò mysql_ ôóíêöèèòå, êîèòî ñå ïîëçâàõà ìàñîâî ïðåäè.




Reply With Quote
Lenovo ThinkPad 15 èëè IdeaPad 15
5th May 2023, 22:16 in Ìîáèëíè êîìïþòðè