php how to fetch multiple records and display in a query

debugcn 投稿 Dev

Gagandeep Singh

I have a partner table and I need to send reply via SMS. So my table contains firm name, city, mobile and pincode. If someone sends me a pin code via SMS, I want to get back to the customer with the 2 or 3 records (Multiple). With this code I am able to send only one record.

$sql = "SELECT * FROM reg_dealer WHERE pincode = '$myvalue'";
$q = mysql_query($sql);
$rows= mysql_num_rows($q);
$res= mysql_fetch_array($q);

$firm_name=$res['firm_name'];
$city=$res['city'];
$mobiledealer=$res['mobile'];
$pincode=$res['pincode'];

if($res['pincode']=='')
{
$mobile = $_GET['mobile'];  
$reply_message = "Greeting. We will get back to you soon on the nearest Partner details.";
$reply_message1 = urlencode($reply_message);
mysql_query("INSERT INTO history(sender,message,datetime,datenew,code,status,reply_message,url)VALUES('$mobile','$message','$datetime','$datenew','$number','Dealer Does Not Exist','$reply_message','$s')");//insert data in to table
}
// part 2
else
{
$mobile = $_GET['mobile'];  
$reply_message = "Greetings. Please find the nearest Partner - ".$firm_name.", ".$city.", +".$mobiledealer.".";
$reply_message1 = urlencode($reply_message);
mysql_query("INSERT INTO history(sender,message,datetime,datenew,code,status,reply_message,url)VALUES('$mobile','$message','$datetime','$datenew','$number','Dealer Details Sent','$reply_message','$s')");//insert data in to table
}

Al Amin Chayan

Use while loop.

$sql = "SELECT * FROM reg_dealer WHERE pincode = '$myvalue'";
$q = mysql_query($sql);
$rows= mysql_num_rows($q);
while($res= mysql_fetch_array($q))
{

$firm_name=$res['firm_name'];
$city=$res['city'];
$mobiledealer=$res['mobile'];
$pincode=$res['pincode'];

if($res['pincode']=='')
{
$mobile = $_GET['mobile'];  
$reply_message = "Greeting. We will get back to you soon on the nearest Partner details.";
$reply_message1 = urlencode($reply_message);
mysql_query("INSERT INTO history(sender,message,datetime,datenew,code,status,reply_message,url)VALUES('$mobile','$message','$datetime','$datenew','$number','Dealer Does Not Exist','$reply_message','$s')");//insert data in to table
}
// part 2
else
{
$mobile = $_GET['mobile'];  
$reply_message = "Greetings. Please find the nearest Partner - ".$firm_name.", ".$city.", +".$mobiledealer.".";
$reply_message1 = urlencode($reply_message);
mysql_query("INSERT INTO history(sender,message,datetime,datenew,code,status,reply_message,url)VALUES('$mobile','$message','$datetime','$datenew','$number','Dealer Details Sent','$reply_message','$s')");//insert data in to table
}  
}

Update with new requirement:

$mobile = $_GET['mobile'];
$sql = "SELECT * FROM reg_dealer WHERE pincode = '$myvalue'";
    $q = mysql_query($sql);
    $rows= mysql_num_rows($q);
    while($res= mysql_fetch_array($q))
    {

    $firm_name=$res['firm_name'];
    $city=$res['city'];
    $mobiledealer=$res['mobile'];
    $pincode=$res['pincode'];

    if($res['pincode']=='')
    {
    $reply_message .= "Greeting. We will get back to you soon on the nearest Partner details.";
    mysql_query("INSERT INTO history(sender,message,datetime,datenew,code,status,reply_message,url)VALUES('$mobile','$message','$datetime','$datenew','$number','Dealer Does Not Exist','$reply_message','$s')");//insert data in to table
    }
    // part 2
    else
    {
    $reply_message .= "Greetings. Please find the nearest Partner - ".$firm_name.", ".$city.", +".$mobiledealer.".";
    mysql_query("INSERT INTO history(sender,message,datetime,datenew,code,status,reply_message,url)VALUES('$mobile','$message','$datetime','$datenew','$number','Dealer Details Sent','$reply_message','$s')");//insert data in to table
    }  
    }  
if (isset($reply_message) && $reply_message != '')
{
    $reply_message1 = urlencode($reply_message);

    if($res['pincode']=='')
    {
    mysql_query("INSERT INTO history(sender,message,datetime,datenew,code,status,reply_message,url)VALUES('$mobile','$message','$datetime','$datenew','$number','Dealer Does Not Exist','$reply_message1','$s')");//insert data in to table
    }
    // part 2
    else
    {
    mysql_query("INSERT INTO history(sender,message,datetime,datenew,code,status,reply_message,url)VALUES('$mobile','$message','$datetime','$datenew','$number','Dealer Details Sent','$reply_message1','$s')");//insert data in to table
    } 
}

この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。

侵害の場合は、連絡してください[email protected]