Results 1 to 8 of 8

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User zombie13's Avatar
    Join Date: Oct:2012
    Location: Bulgaria - Ruse
    Posts: 63

    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) ïðè íåïðèñúñòâàù èìåéë âðúùà
    Code:
    object(mysqli_result)[2]
      public 'current_field' => null
      public 'field_count' => null
      public 'lengths' => null
      public 'num_rows' => null
      public 'type' => null
    Êúäå å çàðîâåíî êó÷åòî? Ïîìîãíåòå ìè PHP äåòåêòèâè

  2. #2
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location: Ïëîâäèâ
    Posts: 17,654
    Àìè âàð äúìï-à ïðàâèëíî òè å ïîêàçàë, êúäå å ïðîáëåìà òîãàâà?
    Ïðè âñè÷êè ñëó÷àè ïðè âàëèäíà çàÿâêà (áåç çíà÷åíèå äàëè å ïðàçíà), $result ñúäúðæà íåùî (îáåêò), è if (!$result) íÿìà êàê äà âúðíå èñòèíà.
    Òîÿ òåñò òè ïîêàçâà ñàìî äàëè íå å ãðúìíàëà ñàìàòà çàÿâêà (ïðèìåðíî àêî å íåïðàâèëíà êàòî ñèíòàêñèñ).
    Ïîëçâàé ïðèìåðíî num_rows() ìåòîäà íà âúðíàòèÿ mysqli_result îáåêò, çà äà âèäèø äàëè èìà âúðíàòè ðåäîâå.

    Edit: ñîðè, ìîÿ ãðåøêà, èìàõ ïðåäâèä num_rows ïðîïåðòèòî îò îáåêòà, à íå ìåòîäà, ò.å.
    $result->num_rows > 0.
    Last edited by tedych; 28th November 2012 at 11:50.

  3. #3
    Registered User zombie13's Avatar
    Join Date: Oct:2012
    Location: Bulgaria - Ruse
    Posts: 63
    tedych eé òî÷íî òàÿ ôóíêöèÿ ìè òðÿáâàøå. Ìíîãî òè áëàãîäàðÿ! È òîëêîâà áúðçî îòãîâîðè! Ïîêëîí.
    ×åðïíÿòà å â ìåí

  4. #4
    Registered User
    Join Date: Jul:2005
    Location: Sofiq
    Posts: 2,798
    mysqli_result

    mysqli_result implements Traversable {
    /* Properties */
    int $current_field ;
    int $field_count;
    array $lengths;
    int $num_rows;

    .....
    }
    Áè òðÿáâàëî ñïîðåä äîêóìåíòàöèÿòà â $result->num_rows äà èìàø áðîÿ íà ñåëåêíàòèòå ðåäîâå.

  5. #5
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location: Ïëîâäèâ
    Posts: 17,654
    Äà, ñîðè, àç ñè áÿõ åäèòíàë âå÷å ãîðíèÿ ïîñò, íÿìà ìåòîä, à ïðîïåðòèòî.
    Îòäàâíà íå ïîëçâàì äèðåêòíî òåçè íåùà, à ìèíàâàò ïðåç ìîè êúñòúì àáñòðàêöèè (êëàñîâå), òà ïîíÿêîãà ñå ïîçàáðàâÿò òàêèâà äåòàéëè .
    À è âñè÷êè çíàåì êîëêî "èíòóèòèâíè", "êîíñèñòåíòíè" è "äîáðå èìåíóâàíè" ñà ôóíêöèèòå, êëàñîâåòå è ìåòîäèòå â ÏÕÏ êàòî öÿëî. Íàïðàâî êðåùÿò äà ãè ïîìíèø íàèçóñò .

  6. #6
    Registered User zombie13's Avatar
    Join Date: Oct:2012
    Location: Bulgaria - Ruse
    Posts: 63
    Àç ãî íàïðàâèõ

    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 />';
        }
    }

    .... 
    è êîäà çàòèêòàêà.

    Îùå âåäíúæ áëàãîäàðÿ, ñóïåð ñòå!

  7. #7
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location: Ïëîâäèâ
    Posts: 17,654
    Î äà, òè ïîëçâàøå ïðîöåäóðíèÿ ïîõâàò . Òî ðåàëíî îòçàä âñå ñå ïîëçâà è îáåêòíèÿ, à ïðîöåäóðèòå (ôóíêöèèòå) ñà òàì ïðîñòî äà å ïî-ëåñíî çà èäâàùèòå îò mysql_ ôóíêöèèòå, êîèòî ñå ïîëçâàõà ìàñîâî ïðåäè.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè