Results 1 to 9 of 9

Thread: SQL -

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Product of Science
    Join Date: Aug:2016
    Location:
    Posts: 294

    SQL -

    php - :
    Code:
            $result1 = $conn->query($sql1);
            if ($result1->num_rows > 0)  
            {
              while ($row1 = mysqli_fetch_assoc($result1)) 
                {
                    echo $row1["email"];
                    echo "<br>";
                    echo $row1["first_name"];
                    echo "<br>";
                    $sql2 = "SELECT customer_id, welcome FROM customer_order_emails WHERE customer_id=$row1["customer_id"];
            	$result2 = $conn->query($sql2);
                    /* ................ */
                }
            }
    , : WHERE customer_id=$row1["customer_id"]

  2. #2
    Registered User
    Join Date: Dec:2003
    Posts: 2,817
    php .
    Gigabyte DS3P, E4400@9x333, 2x2Gb Super T@1000Mhz, Gigabyte GTX460OC 768Mb

  3. #3
    Product of Science
    Join Date: Aug:2016
    Location:
    Posts: 294
    , :

    Code:
                    $sql2 = "SELECT customer_id, welcome FROM customer_order_emails WHERE customer_id=$row1["customer_id"];

    Code:
                    $sql2 = 'SELECT customer_id, welcome FROM customer_order_emails WHERE customer_id=$row1["customer_id"]';
    - , ,
    Code:
                    echo $row1["first_name"];
    ??????
    !

  4. #4
    Banned
    Join Date: Aug:2008
    Location:
    Posts: 5,960
    - , - UTF8.

    Code:
    $conn = new mysqli("IP", "", "", "");
    $Error="";
    $conn->set_charset("utf8");
    if ($conn->connect_errno) {
    	Error("DB erro " . $conn->connect_errno);
    }
    PHP , .
    Last edited by moonclub; 26th November 2017 at 20:49.

  5. #5
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    "" / ( ) : "alabala {$var1['index']}";
    - .
    , moonclub, , , php , . Content-Type .
    , / , UTF-8 .

  6. #6
    Product of Science
    Join Date: Aug:2016
    Location:
    Posts: 294
    @moonclub @tedych. .
    , PHP mail() Function,
    Code:
    bool mail ( string $to , string $subject , string $message [, string $additional_headers [, string $additional_parameters ]] )
    , - , - - , -.
    , PHP 7.

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 |