Learn VBA & Macros in 1 Week!

PHP - How To Display Multiples Lists Next To Each Other?

Full Excel VBA Course - Beginner to Expert

How To Display Multiples Lists Next To Each Other?	View Content

Hi guys,

I would like to display data from MySQL in the format of 5 lists (of one column each) one next to each other on a webpage

I am quite good with SQL, but I lack knowledge about php and displaying data.

SQL version: 5.1

Does anyone have any good website that would show how to do such a thing?

Full Excel VBA Course - Beginner to Expert

Php/mysql 2 Dropdown Lists Filter & Display On Screen Result

Similar Tutorials

View Content

Hello to all.
I'm new here and i am very glad to be a part of this community.
I am new in PHP/mysql but i try to learn as much as i can in php & mysql.

And here is the problem:
Into a php or html page i want to display 2 dropdown list to act as a filter for displaying a table.
I managed to display a table based on option select from first dropdown but i don'y know how to make or activate the second dropdown list to act as a filter, and when i press "result" to display on the same page the results.

Thanks a lot.

How To Send Multiples Email To User On A Transaction Initiation

Similar Tutorials

View Content

Good morning, I'm writing a php script on a transaction creation/initiation. Only a registered user can initiate a transaction but if the second party to the transaction is not a registered user, the system will send a mail to the user informing him/her to accept and create an account.

The whole idea is i have four conditional statement and each condition needs to send mail to the transaction initiator and the second party. so i am sending 8 mails but 2 at a time if and only if the condition is met.

below is my code

if ($mode==1){
                //echo "Mode 1: ".$mode;
                    $mode2 = 2;
                    
                $sql = "SELECT * FROM reg WHERE email='$email'";
                $query = mysqli_query($con,$sql);  
                $rowreg = mysqli_fetch_row($query); 
                $dbid = $rowreg[0];
                $dbemail = $rowreg[1];
                
                
                
                        if (mysqli_num_rows($query)>0){
    /* Create a new PHPMailer object. Passing TRUE to the constructor enables exceptions. */
$mail = new PHPMailer(TRUE);

/* Open the try/catch block. */
try {
   /* Set the mail sender. */
   $mail->setFrom('no-reply@me.com', 'Mecom');

   /* Add a recipient. */
   $mail->addAddress("$email", "$full_name");

   /* Set the subject. */
   $mail->Subject = 'Transaction Created Successfully';

$mail->isHTML(TRUE);

   /* Set the mail message body. */
   $mail->Body = '<div class="email-background" style="background: #eee;padding: 10px;">
                
                                 <a href=""><center><img src="" style="padding-top:30px;padding-bottom:30px;max-width:100px;height:100px;margin: 0 auto;"></center><a>
                                 
                            <div class="email-container" style="max-width: 500px;background: white;font-family: san-serif;margin: 0 auto;overflow: hidden;border-radius: 5px;text-align: center;">
                            
                            
                                <p style="margin: 20px;font-size: 12px;font-weight: 300;color: #666;line-height: 1.5;text-align:left"> Dear <b>' . $full_name . '</b>;<br/>We believe there is an agreement between you and <b>'. $fullname .' </b>for a transaction. Please see the details of the transaction below</p>
                      
                             <div class="table table-responsive"  style="margin-left: 10px;margin-right: 10px;">
                <table  class="table table-striped table-bordered" style="max-width: 100%;background-color: transparent;border-collapse: collapse;border-spacing: 0;display: table;width: 100%;margin-bottom: 20px;border: 1px solid #ddd;">
                
                    <tbody style="display: table-row-group;vertical-align: middle;border-color: inherit;"> 
                    
                          <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                          
                                <td colspan="2"  width="100%"  style="text-align: center;background: #00bf6f;color: white;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;font-size:20px">Transaction Details <b>'.$transact_no.'</b></td>
                            </tr> 
                    <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                        <td colspan=""  width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Title</td>
                        <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$db_cat_category.'</td>
                    </tr> 
                    <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> 
                        <td colspan=""  width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Description</td>
                        <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$description.'</td>
                    </tr>  
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Link</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$tran_link.'</td>
                        </tr>  
                        '.$customerMail.' 
                     
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Item Worth/Price</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">&#x20A6;'.$price_format.'</td>
                        </tr> 
                        
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Charges bearer</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$charges.'</td>
                        </tr>  
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Total Charges</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">&#x20A6;'.$chrg.'</td>
                        </tr>  
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                                <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Who pay the charges?</td> 
                                <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$chrgs.'</td>
                        </tr>    
 
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Buyer Pays</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$buyer_t_pay.'</td>
                        </tr> 

                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Seller Receives</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$seller_t_receives.'</td>
                        </tr> 
                
                   
                    </tbody>
                    </table>
                        </div>  
                                     
                               
                            </div>
                            
                            <div class="footer-junk" style="background: none;padding: 20px;font-size: 12px;text-align: center;">
                                  Copyright &copy; Mecom'. $year .' All Rights Reserved
                            </div>
                            
                        </div>';

   /* Finally send the mail. */
   //$mail->send();

   if (!$mail->send()){
       /* PHPMailer error. */
       echo $mail->ErrorInfo;
    }else{  
                $output ="<div class=\"alert alert-success\">Transaction has been created successfully</div>"; 
                
    
}
catch (Exception $e)
{
   /* PHPMailer exception. */
   echo $e->errorMessage();
}
catch (\Exception $e)
{
   /* PHP exception (note the backslash to select the global namespace Exception class). */
   echo $e->getMessage();
}

                        
                        
                        //
                        
 //End of First User
 
 
 
 //Second User 
              //
                        
   $fullname = $user["firstname"] . " " . $user["lastname"];  
   $full_name = $fname . " ". $lname;

/* Create a new PHPMailer object. Passing TRUE to the constructor enables exceptions. */
$mail = new PHPMailer(TRUE);

/* Open the try/catch block. */
try {
   /* Set the mail sender. */
   $mail->setFrom('no-reply@me.com', 'Mecom');

   /* Add a recipient. */
   $mail->addAddress("$dbemail", "$fullname");

   /* Set the subject. */
   $mail->Subject = 'Transaction Created Successfully';

$mail->isHTML(TRUE);

   /* Set the mail message body. */
   $mail->Body = '<div class="email-background" style="background: #eee;padding: 10px;">
                
                                 <a href=""><center><img src="" style="padding-top:30px;padding-bottom:30px;max-width:100px;height:100px;margin: 0 auto;"></center><a>
                                 
                            <div class="email-container" style="max-width: 500px;background: white;font-family: san-serif;margin: 0 auto;overflow: hidden;border-radius: 5px;text-align: center;">
                            
                                 <p style="margin: 20px;font-size: 12px;font-weight: 300;color: #666;line-height: 1.5;text-align:left"> Dear ' . $fullname . ',<br/>You just initiated a transaction with title <b>'. $cat_category .'</b> and description <b> '. $description .' </b>to <b>'. $full_name .' </b>. Below is the details of the transaction</p>
                     
                      <div class="table table-responsive"  style="margin-left: 10px;margin-right: 10px;">
                <table  class="table table-striped table-bordered" style="max-width: 100%;background-color: transparent;border-collapse: collapse;border-spacing: 0;display: table;width: 100%;margin-bottom: 20px;border: 1px solid #ddd;">
                
                    <tbody style="display: table-row-group;vertical-align: middle;border-color: inherit;"> 
                    
                          <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                          
                                <td colspan="2"  width="100%"  style="text-align: center;background: #00bf6f;color: white;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;font-size:20px">Transaction Details <b>'.$transact_no.'</b></td>
                            </tr> 
                    <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                        <td colspan=""  width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Title</td>
                        <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$db_cat_category.'</td>
                    </tr> 
                    <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> 
                        <td colspan=""  width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Description</td>
                        <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$description.'</td>
                    </tr>  
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Link</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$tran_link.'</td>
                        </tr>  
                        '.$customerMail.' 
                     
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Item Worth/Price</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">&#x20A6;'.$price_format.'</td>
                        </tr> 
                        
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Charges bearer</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$charges.'</td>
                        </tr>  
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Total Charges</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">&#x20A6;'.$chrg.'</td>
                        </tr>  
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                                <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Who pay the charges?</td> 
                                <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$chrgs.'</td>
                        </tr>    
 
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Buyer Pays</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$buyer_t_pay.'</td>
                        </tr> 

                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Seller Receives</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$seller_t_receives.'</td>
                        </tr> 
                
                   
                    </tbody>
                    </table>
                        </div>  
                     
                               
                            </div>
                            
                            <div class="footer-junk" style="background: none;padding: 20px;font-size: 12px;text-align: center;">
                                  Copyright &copy; Mecom'. $year .' All Rights Reserved
                            </div>
                            
                        </div>';

   /* Finally send the mail. */
   //$mail->send();

   if (!$mail->send()){
       /* PHPMailer error. */
       echo $mail->ErrorInfo;
    }else{  
                //    $output ="<div class=\"alert alert-success\">Transaction has been created successfully</div>"; 
                     
        echo  "<script>
                        window.onload = function() { 
                            sweetAlert({
                                    title: 'Congratulations',
                                    text: 'Your transaction has been created successfully',
                                    type: 'success',
                                    confirmButtonColor: '#B6EA36'
                                }, 
                                function () {
                                    window.location.href = './';
                                }); 
    
                        };  
                 </script>";
    }

 
}
catch (Exception $e)
{
   /* PHPMailer exception. */
   echo $e->errorMessage();
}
catch (\Exception $e)
{
   /* PHP exception (note the backslash to select the global namespace Exception class). */
   echo $e->getMessage();
}


          
                        
                        //
 
 
 //End of Second User
 
 
 
 
                                     
                            
                }else{ //if the second user that is not the initiator is not a registered user
                                   

                                //Add user info into the database table for the main site table
                                //include ('includes/randStrGen.php');        

                        
                            $reg_no = randStrGen(4);
                    $check_ID_query = mysqli_query($con, "SELECT regNo FROM reg WHERE regNo='$reg_no'");
                       $i = 0; 
                        //if username exists add number to username
                        while(mysqli_num_rows($check_ID_query) != 0) {
                            $i++; //Add 1 to i
                            $reg_no = $reg_no + $i;
                            $check_ID_query = mysqli_query($con, "SELECT regNo FROM reg WHERE regNo='$reg_no'");
                        }


                 
        /*         echo "First Name ". $fname . "<br>";
                 echo  "Last Name ". $lname . "<br>";
                 echo  "Address ". $address . "<br>";
                 echo  "Phone Number ". $phonenumber . "<br>";
                 echo  "Registration Number ". $reg_gen . "<br>";
                 
                 exit();*/

            $sql_reg = "INSERT INTO reg(email,password,firstname,lastname,marital_status,phone_number,IDmeans,passportID,lastlogin,regNo,address,bank_acct_number,bank_acct_name,bank_name,real_pass,activation,regDate) VALUES('$email','0','$fname','$lname','0','$phonenumber','0','0',now(),'$reg_no','$address','0','0','0','0','0',now())";
            $query_reg = mysqli_query($con,$sql_reg); 
            $regid = mysqli_insert_id($con);


                                $sql_reg_verify = "INSERT INTO account_verify(token_email,refno) VALUES('$email','$reg_no')";
                                $query_reg_verify = mysqli_query($con,$sql_reg_verify); 
                                //$regid = mysqli_insert_id($link);

                    $sql_description = "INSERT INTO description(item_description,transactID) VALUES('$description','$transact_no')";
                    $query_description = mysqli_query($con,$sql_description); 
                    $descid = mysqli_insert_id($con);
                    
            //$r_tran= $_SESSION['transID'] .$descid ;
                        
                    $sql = "INSERT INTO trans_tbl(transact_no,transact_date,agreement_status,mode_transactID,transact_catID,regID,descID,amount,shipcost,status,transaction_period,inspection_length,charges,amt_pay,comp_charges,transaction_link,payment_status,shipment_status,confirm_shipment,address,refno) 
                    
                    VALUES('$transact_no',now(),'1','$mode','$cat','$user[id]','$descid','$price','0','0','0','0','$charges','0','$chrg','0','0','0','0','$address','0'),
                    
                    ('$transact_no',now(),'1','$mode2','$cat','$regid','$descid','$price','0','0','0','0','$charges','0','$chrg','0','0','0','0','$address','0')";
                    $query = mysqli_query($con,$sql);

                    /*    Sending mail to new user to update his/her password */
                    $encode_email = base64_encode(base64_encode($email));
                    $encode_reg = base64_encode(base64_encode($reg_no));            
                    //$encode_transactiinID = base64_encode(base64_encode($_SESSION['transID']));
                    //$encode_parnterID = base64_encode(base64_encode($_SESSION['id']));
                    //$encode_modeID = base64_encode(base64_encode($mode)); 

        $link_url="<a href=\"https://www.safetranzact.com/verify-account?token=$encode_reg\" style=\"text-decoration: none;display: inline-block;background: #00bf6f;color: white;padding: 10px 20px;border-radius: 5px;\">Review and Sign up</a>";
             
        
    $year = date('Y');
            //send email to the receiver
            
            
        //First user for non register
        
        
 
 
              //
                        
   $full_name = $fname . " " . $lname;               
   $fullname = $user["firstname"] . " ". $user["lastname"];

/* Create a new PHPMailer object. Passing TRUE to the constructor enables exceptions. */
$mail = new PHPMailer(TRUE);

/* Open the try/catch block. */
try {
   /* Set the mail sender. */
   $mail->setFrom('no-reply@me.com', 'Mecom');

   /* Add a recipient. */
   $mail->addAddress("$email", "$full_name");

   /* Set the subject. */
   $mail->Subject = 'Account/Transaction Verification';

$mail->isHTML(TRUE);

   /* Set the mail message body. */
   $mail->Body = '<div class="email-background" style="background: #eee;padding: 10px;">
                
         <a href=""><center><img src="" style="padding-top:30px;padding-bottom:30px;max-width:100px;height:100px;margin: 0 auto;"></center><a>
         
    <div class="email-container" style="max-width: 500px;background: white;font-family: san-serif;margin: 0 auto;overflow: hidden;border-radius: 5px;text-align: center;">
        <p style="margin: 20px;font-size: 12px;font-weight: 300;color: #666;line-height: 1.5;text-align:left"> Dear ' . $full_name. ',<br/>We believe there is an agreement between you and <b>'. $fullname .' </b>  for a transaction. And we noticed that you have not yet signed up; Please Sign up and see the details of the transaction below</p>
          
             <div class="table table-responsive"  style="margin-left: 10px;margin-right: 10px;">
                <table  class="table table-striped table-bordered" style="max-width: 100%;background-color: transparent;border-collapse: collapse;border-spacing: 0;display: table;width: 100%;margin-bottom: 20px;border: 1px solid #ddd;">
                
                    <tbody style="display: table-row-group;vertical-align: middle;border-color: inherit;"> 
                    
                          <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                          
                                <td colspan="2"  width="100%"  style="text-align: center;background: #00bf6f;color: white;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;font-size:20px">Transaction Details <b>'.$transact_no.'</b></td>
                            </tr> 
                    <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                        <td colspan=""  width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Title</td>
                        <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$db_cat_category.'</td>
                    </tr> 
                    <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> 
                        <td colspan=""  width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Description</td>
                        <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$description.'</td>
                    </tr>  
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Link</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$tran_link.'</td>
                        </tr>  
                        '.$customerMail.' 
                     
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Item Worth/Price</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">&#x20A6;'.$price_format.'</td>
                        </tr> 
                        
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Charges bearer</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$charges.'</td>
                        </tr>  
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Total Charges</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">&#x20A6;'.$chrg.'</td>
                        </tr>  
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                                <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Who pay the charges?</td> 
                                <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$chrgs.'</td>
                        </tr>    
 
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Buyer Pays</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$buyer_t_pay.'</td>
                        </tr> 

                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Seller Receives</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$seller_t_receives.'</td>
                        </tr> 
                
                   
                    </tbody>
                    <tfoot>
                            <tr>
                                <td colspan="2">'.$link_url.'</td>
                            </tr>
                    </tfoot>
                    </table>
                        </div>   
                            
                             
                               
                            </div>
                            
                            <div class="footer-junk" style="background: none;padding: 20px;font-size: 12px;text-align: center;">
                                  Copyright &copy; Mecom'. $year .' All Rights Reserved
                            </div>
                            
                        </div>';

   /* Finally send the mail. */
   //$mail->send();

   if (!$mail->send()){
       /* PHPMailer error. */
       echo $mail->ErrorInfo;
    }else{  
                $output ="<div class=\"alert alert-success\">Transaction has been created successfully</div>"; 
                      
    }

 
}
catch (Exception $e)
{
   /* PHPMailer exception. */
   echo $e->errorMessage();
}
catch (\Exception $e)
{
   /* PHP exception (note the backslash to select the global namespace Exception class). */
   echo $e->getMessage();
}


//
                        
                        
                        //
 
        
        //End of First user for non register
        
        
            
            
        //Second user for register
        
        
 
              //
                        
   $full_name = $fname . " " . $lname;               
   $fullname = $user["firstname"] . " ". $user["lastname"];        
   
   $year = date('Y');

/* Create a new PHPMailer object. Passing TRUE to the constructor enables exceptions. */
$mail = new PHPMailer(TRUE);

/* Open the try/catch block. */
try {
   /* Set the mail sender. */
   $mail->setFrom('no-reply@me.com', 'Mecom');

   /* Add a recipient. */
   $mail->addAddress("$dbemail", "$fullname");

   /* Set the subject. */
   $mail->Subject = 'Transaction Created Successfully';

$mail->isHTML(TRUE);

   /* Set the mail message body. */
   $mail->Body = '<div class="email-background" style="background: #eee;padding: 10px;">

             <a href=""><center><img src="" style="padding-top:30px;padding-bottom:30px;max-width:100px;height:100px;margin: 0 auto;"></center><a>

            <div class="email-container" style="max-width: 500px;background: white;font-family: san-serif;margin: 0 auto;overflow: hidden;border-radius: 5px;text-align: center;">

                 <p style="margin: 20px;font-size: 12px;font-weight: 300;color: #666;line-height: 1.5;text-align:left"> Dear ' . $fullname . ',<br/>You just initiated a transaction with title <b>'. $cat_category .'</b> and description <b>'. $description .' </b> to <b>'. $full_name .' </b> Below is the details of the transaction</p>
     
                 <div class="table table-responsive"  style="margin-left: 10px;margin-right: 10px;">
                <table  class="table table-striped table-bordered" style="max-width: 100%;background-color: transparent;border-collapse: collapse;border-spacing: 0;display: table;width: 100%;margin-bottom: 20px;border: 1px solid #ddd;">
                
                    <tbody style="display: table-row-group;vertical-align: middle;border-color: inherit;"> 
                    
                          <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                          
                                <td colspan="2"  width="100%"  style="text-align: center;background: #00bf6f;color: white;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;font-size:20px">Transaction Details <b>'.$transact_no.'</b></td>
                            </tr> 
                    <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                        <td colspan=""  width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Title</td>
                        <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$db_cat_category.'</td>
                    </tr> 
                    <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> 
                        <td colspan=""  width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Description</td>
                        <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$description.'</td>
                    </tr>  
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Link</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$tran_link.'</td>
                        </tr>  
                        '.$customerMail.' 
                     
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Item Worth/Price</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">&#x20A6;'.$price_format.'</td>
                        </tr> 
                        
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Charges bearer</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$charges.'</td>
                        </tr>  
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Total Charges</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">&#x20A6;'.$chrg.'</td>
                        </tr>  
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                                <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Who pay the charges?</td> 
                                <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$chrgs.'</td>
                        </tr>    
 
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Buyer Pays</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$buyer_t_pay.'</td>
                        </tr> 

                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Seller Receives</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$seller_t_receives.'</td>
                        </tr> 
                
                   
                    </tbody>
                    </table>
                        </div>  
                               
                            </div>
                            
                            <div class="footer-junk" style="background: none;padding: 20px;font-size: 12px;text-align: center;">
                                  Copyright &copy; Mecom'. $year .' All Rights Reserved
                            </div>
                            
                        </div>';

   /* Finally send the mail. */
   //$mail->send();

   if (!$mail->send()){
       /* PHPMailer error. */
       echo $mail->ErrorInfo;
    }else{  
                 
        echo  "<script>
                        window.onload = function() { 
                            sweetAlert({
                                    title: 'Congratulations',
                                    text: 'Your transaction has been created successfully',
                                    type: 'success',
                                    confirmButtonColor: '#B6EA36'
                                }, 
                                function () {
                                    window.location.href = './';
                                }); 
    
                        };  
                 </script>";
    }

 
}
catch (Exception $e)
{
   /* PHPMailer exception. */
   echo $e->errorMessage();
}
catch (\Exception $e)
{
   /* PHP exception (note the backslash to select the global namespace Exception class). */
   echo $e->getMessage();
}


  
//$mail4->ClearAllRecipients();                      
                        
                        //
 
 
        
        //End of Second user for register
            

            }

}else{      ///////////////////////Second condition with 




                //echo "Mode 2: ".$mode;
                $mode2 = 1;
                
                
                
        $sql = "SELECT * FROM reg WHERE email='$email' LIMIT 1";
        $query = mysqli_query($con,$sql);  
        $rowreg = mysqli_fetch_row($query); 
        $dbid = $rowreg[0];
        $dbemail = $rowreg[1];

        if (mysqli_num_rows($query)>0){
//Add user info into the database table for the main site table
        
            $sql_description = "INSERT INTO description(item_description,transactID) VALUES('$description','$transact_no')";
            $query_description = mysqli_query($con,$sql_description); 
            $desc_id = mysqli_insert_id($con);
            
    //$r_tran= $_SESSION['transID'] .$descid ;
                
            $sql = "INSERT INTO trans_tbl(transact_no,transact_date,agreement_status,mode_transactID,transact_catID,regID,descID,amount,shipcost,status,transaction_period,inspection_length,charges,amt_pay,comp_charges,transaction_link,payment_status,shipment_status,confirm_shipment,address,refno) 
            
            VALUES('$transact_no',now(),'1','$mode','$cat','$user[id]','$desc_id','$price','0','0','0','0','$charges','0','$chrg','$tran_link','0','0','0','$address','0'),
            
            ('$transact_no',now(),'1','$mode2','$cat','$dbid','$desc_id','$price','0','0','0','0','$charges','0','$chrg','$tran_link','0','0','0','$address','0')";
            $query = mysqli_query($con,$sql); 
            
            
        //First user to received email
        
         //
                        
 $full_name = $fname . " ". $lname;               
   $fullname = $user["firstname"] . " ". $user["lastname"];
  $year = date('Y');                     

/* Create a new PHPMailer object. Passing TRUE to the constructor enables exceptions. */
$mail = new PHPMailer(TRUE);

/* Open the try/catch block. */
try {
   /* Set the mail sender. */
   $mail->setFrom('no-reply@me.com', 'Mecom');

   /* Add a recipient. */
   $mail->addAddress("$email", "$full_name");

   /* Set the subject. */
   $mail->Subject = 'Transaction Created Successfully';

$mail->isHTML(TRUE);

   /* Set the mail message body. */
   $mail->Body = '<div class="email-background" style="background: #eee;padding: 10px;">

             <a href="https://www.safetranzact.com"><center><img src="https://www.safetranzact.com/assets/images/fav.png" style="padding-top:30px;padding-bottom:30px;max-width:100px;height:100px;margin: 0 auto;"></center><a>

            <div class="email-container" style="max-width: 500px;background: white;font-family: san-serif;margin: 0 auto;overflow: hidden;border-radius: 5px;text-align: center;">
            <p style="margin: 20px;font-size: 12px;font-weight: 300;color: #666;line-height: 1.5;text-align:left"> Dear <b>' . $full_name . '</b>,<br/>We believe there is an agreement between you and <b> '. $fullname  .'  </b>for a transaction. Please see the details of the transaction below</p>
 
                  <div class="table table-responsive"  style="margin-left: 10px;margin-right: 10px;">
                <table  class="table table-striped table-bordered" style="max-width: 100%;background-color: transparent;border-collapse: collapse;border-spacing: 0;display: table;width: 100%;margin-bottom: 20px;border: 1px solid #ddd;">
                
                    <tbody style="display: table-row-group;vertical-align: middle;border-color: inherit;"> 
                    
                          <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                          
                                <td colspan="2"  width="100%"  style="text-align: center;background: #00bf6f;color: white;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;font-size:20px">Transaction Details <b>'.$transact_no.'</b></td>
                            </tr> 
                    <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                        <td colspan=""  width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Title</td>
                        <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$db_cat_category.'</td>
                    </tr> 
                    <tr style="display: table-row;vertical-align: inherit;border-color: inherit;"> 
                        <td colspan=""  width="20%" style="text-align: left;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Description</td>
                        <td colspan="" width="80%" style="text-align: right;font-size: 12px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$description.'</td>
                    </tr>  
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Transaction Link</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$tran_link.'</td>
                        </tr>  
                        '.$customerMail.' 
                     
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Item Worth/Price</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">&#x20A6;'.$price_format.'</td>
                        </tr> 
                        
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Charges bearer</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$charges.'</td>
                        </tr>  
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Total Charges</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">&#x20A6;'.$chrg.'</td>
                        </tr>  
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                                <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Who pay the charges?</td> 
                                <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$chrgs.'</td>
                        </tr>    
 
                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Buyer Pays</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$buyer_t_pay.'</td>
                        </tr> 

                        <tr style="display: table-row;vertical-align: inherit;border-color: inherit;">
                            <td colspan="" width="20%" style="text-align: left;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">Seller Receives</td> 
                            <td colspan="" width="80%" style="text-align: right;font-size: 14px;border: 1px solid #ddd;padding: 8px;line-height: 1.428571429;vertical-align: top;border-top: 1px solid #ddd;">'.$seller_t_receives.'</td>
                        </tr> 
                
                   
                    </tbody>
                    </table>
                        </div>  
                             
                                     
                               
                            </div>
                            
                            <div class="footer-junk" style="background: none;padding: 20px;font-size: 12px;text-align: center;">
                                  Copyright &copy; Safetranzact '. $year .' All Rights Reserved
                            </div>
                            
                        </div>';

   /* Finally send the mail. */
   //$mail->send();

   if (!$mail->send()){
       /* PHPMailer error. */
       echo $mail->ErrorInfo;
    }else{  
                     $output ="<div class=\"alert alert-success\">Transaction has been created successfully</div>"; 
                     
         
    }

//$mail->ClearAllRecipients();
   
}
catch (Exception $e)
{
   /* PHPMailer exception. */
   echo $e->errorMessage();
}
catch (\Exception $e)
{
   /* PHP exception (note the backslash to select the global namespace Exception class). */
   echo $e->getMessage();
}


 
//$mail->ClearAllRecipients();                       
                        
                        //
                        

        
        //End of First user to received email
        
        
        
        //Second user to received email
        
        
 
              //
                        
   $fullname = $user["firstname"] . " " . $user["lastname"];    
   $full_name = $fname . " " . $lname;                        
   
   $year = date('Y');

/* Create a new PHPMailer object. Passing TRUE to the constructor enables exceptions. */
$mail = new PHPMailer(TRUE);

/* Open the try/catch block. */
try {
   /* Set the mail sender. */
   $mail->setFrom('no-reply@safetranzact.com', 'Safetranzact');

   /* Add a recipient. */
   $mail->addAddress("$dbemail", "$fullname");

   /* Set the subject. */
   $mail->Subject = 'Transaction Created Successfully';

$mail->isHTML(TRUE);

   /* Set the mail message body. */
   $mail->Body = '<div class="email-background" style="background: #eee;padding: 10px;">
                
                                 <a href=""><center><img src="" style="padding-top:30px;padding-bottom:30px;max-width:100px;height:100px;margin: 0 auto;"></center><a>
                                 
                            <div class="email-container" style="max-width: 500px;background: white;font-family: san-serif;margin: 0 auto;overflow: hidden;border-radius: 5px;text-align: center;">
                             
            <p style="margin: 20px;font-size: 12px;font-weight: 300;color: #666;line-height: 1.5;text-align:left"> Dear ' . $fullname . ',<br/>You just initiated a transaction with title <b>'. $cat_category .'</b> and description <b>'. $description .' to <b>'. $full_name .' </b>Below is the details of the transaction</p>
                  <div class="table table-responsive"  style="margin-left: 10px;margin-right: 10px;">
                <table  class="table table-striped table-bordered" style="

Creating A Loop Singling Out Multiples Of 3 And 5 And Replacing Them With A Word

Similar Tutorials

View Content

Help With Drop Down Lists

Similar Tutorials

View Content

Help With Dependent Select Lists

Similar Tutorials

View Content

Thanks in advance for any help that you may be able to provide. I'm a graphic designer with VERY limited knowledge of php, javascript, etc. I'm trying to create a form on my company's website that will allow customers to view specifications for particular products. I'm trying to use selection boxes to narrow the customer's search, with the selection from the second box dependent on the first, and the resulting information displayed dependent on the choice from the second list.

So far, I've only been able to adapt some code I found in a tutorial to display the data in the first selection box. No matter what I've tried, I can't seem to get any information to display in the second box, let alone information that is dependent on the first selection. I am brand new to php and javascript, and I didn't even know AJAX, JSON, or JQuery even existed until only a few days ago. Below is the three php files I'm using to try and make this work. If someone could point out what is wrong with it, I would be eternally grateful.

Here is the code from db.php, the file I'm using to connect to my database:

Code: [Select]
<?php
/*changing "db_username" to "root", changing "db_password" to "xxXXXX", changing "database" to "trailers" */
mysql_connect("localhost", "root", "xxXXXX") or die(mysql_error());
mysql_select_db("trailers") or die(mysql_error());
?>
Here is the code from func.php, the file with all the functions and database queries:

Code: [Select]
<?php
//**************************************
//     Page load dropdown results - changing tier_one to tnttrailer_brand, changing two_drops to trailerquote, changing 'tier_one' to 'tnttrailer_brand'     //
//**************************************
function getTierOne()
{
$result = mysql_query("SELECT DISTINCT tnttrailer_brand FROM trailerquote")
or die(mysql_error());

  while($tier = mysql_fetch_array( $result ))

{
   echo '<option value="'.$tier['tnttrailer_brand'].'">'.$tier['tnttrailer_brand'].'</option>';
}

}

//**************************************
//     First selection results - changing two_drops to trailerquote, changing tier_one to tnttrailer_brand, changing 'tier_two' to 'trailer_description',     //
//**************************************
if($_GET['func'] == "drop_1" && isset($_GET['func'])) {
   drop_1($_GET['drop_var']);
}

function drop_1($drop_var)
{
    include_once('db.php');
$result = mysql_query("SELECT trailer_description FROM trailerquote WHERE tnttrailer_brand='$drop_var'")
or die(mysql_error());

echo '<select name="tier_two" id="tier_two">
      <option value=" " disabled="disabled" selected="selected">Choose one</option>';

   while($drop_2 = mysql_fetch_array( $result ))
{
  echo '<option value="'.$drop_2['trailer_description'].'">'.$drop_2['trailer_description'].'</option>';
}

echo '</select> ';
    echo '<input type="submit" name="submit" value="Submit" />';
}
?>
Finally, this is the code from index.php, the file with the form, javascript and the AJAX:

Code: [Select]
<?php
  include('db.php');
  include('func.php');
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Chained Select Boxes using PHP, MySQL and jQuery</title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js"></script>

<script type="text/javascript">
$(document).ready(function() {
$('#wait_1').hide();
$('#drop_1').change(function(){
$('#wait_1').show();
$('#result_1').hide();
$.get("func.php", {
func: "drop_1",
drop_var: $('#drop_1').val()
}, function(response){
$('#result_1').fadeOut();
setTimeout("finishAjax('result_1', '"+escape(response)+"')", 400);
});
return false;
});
});

function finishAjax(id, response) {
$('#wait_1').hide();
$('#'+id).html(unescape(response));
$('#'+id).fadeIn();
}
</script>
</head>

<body>
<p>
<form action="" method="post">

<select name="drop_1" id="drop_1">

<option value="" selected="selected" disabled="disabled">Select a Category</option>

<?php getTierOne(); ?>

</select>

<span id="wait_1" style="display: none;">
<img alt="Please Wait" src="ajax-loader.gif"/>
</span>
<span id="result_1" style="display: none;"></span>

</form>
</p>
<p>
<?php if(isset($_POST['submit'])){
$drop = $_POST['drop_1'];
$tier_two = $_POST['trailer_description'];
echo "You selected ";
echo $drop." & ".$tier_two;
}
/* changed 'tier_two' to 'trailer_description' */
?>
</body>
</html>
Here's the page on my website. I'm using Joomla for my website, and the above php is loaded into a module at the bottom of the page:

http://www.tnttrailer.com/index.php/dimensions.html

Dynamic Dropdown Lists

Similar Tutorials

View Content

Hi everyone,

I've read through the FAQs for Dynamic Dropdown Menus on this site, as well as others, and I can't figure out why my code won't work. I have two dropdown boxes that need to be populated with data from a mysql table; one menu for route types, and one for route numbers. When I choose the route from the 'Route' menu, the 'Number' menu automatically populates with all of the possible numbers, rather than only those that correspond with the route type. I can tell that the problem has something to do with the value of 'Route' not being recognized, but I don't know why. I'm a beginner when it comes to PHP, so any suggestions or help would be much appreciated! Thanks!

The code is as follows:

Code: [Select]

<html>
<body>
<basefont face='calibri' color='#7E2217'>
<?php
// set variables
$mileTable = $_GET['mileTable'];
$routeType = isset($_POST['Roadtype'])? $_POST['Roadtype']: 0;
include 'opendbMile.php';
include 'error.php';
    // Connect to the MySQL DBMS
   if (!($connection = @ mysql_connect($hostName,
                                                                           $username,
                                                                           $password)))
          die("Could not connect");
   if (!mysql_select_db($databaseName, $connection))
         showerror(  );

    // Start a query...
    $query = "SELECT ID,
                                         Roadtype
                          FROM Alabama
                          GROUP BY Roadtype";
    // execute the SQL statement
    $result = mysql_query($query, $connection) or die(mysql_error());
echo '<form name="mileform" method="post" action="MileQuery.php">';
echo '<p>Route:
<select name="routeType" id="routeType" onchange="this.form.submit();">
<option value="0"'.($routeType == 0? ' SELECTED': '').'>Route</option>';
while($row = mysql_fetch_array($result)){
    echo '
            <option value="'.$row[0].'"'.(($routeType == $row[0])? ' SELECTED': '').'>'.$row[1].'</option>';
}
    echo '
    </select>
</p>';
// create the SQL statement
$query2 = "SELECT ID,
          Roadnumber
                   FROM Alabama
                   GROUP BY Roadnumber";
         if($mnucategory != 0){    // Filter road numbers
    $query2 .= " WHERE Roadtype='".$routeType."'";
    }
// execute the SQL statement
$result2 = mysql_query($query2, $connection) or die(mysql_error());
echo '<p>Number:
    <select name="routeNumber" id="routeNumber" onchange="this.form.submit();">
            <option value="0"'.($routeNumber == 0? ' SELECTED': '').'>Number</option>';
while($row2 = mysql_fetch_array($result2)){
    echo '
            <option value="', $row2[0].'"'.(($routeNumber == $row2[0])? ' SELECTED': '').'>'. $row2[1], '</option>';
}
    echo '
    </select>
</p>';
// Close the DBMS connection
   mysql_close($connection);
?>
</form>
</body>
</html>

Php Multi Selection Lists

Similar Tutorials

View Content

Hi

I have to multi select tables, the table on the left is field with the contents of an array, I then have it so the user can make there selections from the left box and move them into the right. They then hit submit and it gets stored inmysql table as an array. The problem I am having is keeping the selections in that right box after any sort of page refresh.
Any ideas I have pasted the php and html code below, the add/remove function is controlled by javascript, I won't bother pasting that as i don't think it has anything to do with it.

PHP ********
Code: [Select]
<?php
/ ------- PARSING PERSONAL TRAINER DETAILS VENUE ---------
if ($_POST['parse_var'] == "fromPool"){

    $venue = $_POST['venue'];
    if (is_array($_POST['venue'])) {
  $venue = explode("\n", $_POST['venue']);
} else {
  $venue = $_POST['venue'];
}

     // Update the database data now here for all fields posted in the form
     $sqlUpdate = mysql_query("UPDATE ptdata SET venue='$venue' WHERE id='$id' LIMIT 1");
     if ($sqlUpdate){
            $success_msg = '<img src="images/Form/round_success.png" width="20" height="20" alt="Success" />Your venue information has been updated successfully';
     } else {
            $error_msg = '<img src="images/Form/round_error.png" width="20" height="20" alt="Failure" /> ERROR: Problems arose during the information exchange, please try again later</font>';
     }
}
// ------- END PARSING PERSONAL TRAINER DETAILS VENUE ---------
?>
<?php

//////////   Venue Array PHP For Multi Selection Boxes  ////////////

$dbString = ''; // To be pulled from Database

$toPool = explode(',', $dbString);

$pool = Array('Your Home','My Home','Outside','Private Studio','Your Work','Gym');

if($_SERVER['REQUEST_METHOD'] == 'POST'){

    $toPool = (count($_POST['venue']) > 0)? $_POST['venue'] : Array();

    $newDbString = implode(',', $toPool); //  Store in Database;

}

$fromPool = array_diff($pool, $toPool);

?>

html ***********

<form action="ptmemberaccount.php" method="post" enctype="multipart/form-data"onsubmit="multipleSelectOnSubmit()">
<table width="500" align="left">
<tr>
<td width="500" height="300" align="center">
<select multiple="multiple" name="fromBox[]" id="fromBox">

<?php

foreach($fromPool as $itm){

    echo "\t" . '<option value="' . $itm . '">' . $itm . '</option>' . PHP_EOL;

}

?>

</select>
<select multiple="multiple" name="venue[]" id="toBox">

<?php

foreach($toPool as $itm){

        echo "\t" . '<option value="' . $itm . '">' . $itm . '</option>' . PHP_EOL;

}

?>

</select> </td>
</tr>
<tr>
<td align="center" height="35"><script type="text/javascript">

createMovableOptions("fromBox","toBox",400,200,'Training Venues','Selected Training Venues');

</script>

<p>Use the buttons to Add/Remove selections</p></td></td>
</tr>
<tr>
<td align="center" height="100">
<input type="submit" value="OK">

</tr>
</table>
</form>

If you need anymore info let me know, also if anyone knows a better way of achieving this i am open to suggestions.

Many Thanks

MOD EDIT: code tags added

Multiple <ul> Lists Php Loop

Similar Tutorials

View Content

Hi, I need help to create a list like this with data from a database im having trouble doing so i have a table called company with 5 fields (installer, assessor, provider, trainer, other) if for example installer in the filed list = 1 then add to list else dont and see if assessor needs added if = 1 add then close list and see if provider = 1 if it does'tn then ask next.

<ul>
<li>Item 1</li>
<li>Item 2</li>
</ul>

<ul>
<li>Item 3</li>
<li>Item 4</li>
</ul>

Tcpdf And Data Lists

Similar Tutorials

View Content

I want to produce a pdf document using mysql and TCPDF.

I can do this OK in some circumstances but I now have a problem. I have two tables - documents and parties - they are linked by a common field docid.

I have for table documents, the fields:
docid, doctitle, idcode

and for the parties table:
partyid, docid, party (the field party is the name of the party)

For any document there could be any number of parties and for a single idcode there could be any number of documents.

For example, for idcode = 12345 there might be 2 documents called doctitle 1 and doctitle 2. For doctitle 1 there are 3 parties to it party1, party 2 and party 3. For doctitle 2 there are two parties - party4 and party 5.

For any idcode (which is passed through by the url) I want the pdf to give a list such as:

Doctitle 1:
party name 1
party name 2
party name 3

Doctitle 2:
party name 4
party name 5

Part of my code is:

mysql_select_db($database_process, $process);
$result2 = mysql_query("SELECT parties.docid, GROUP_CONCAT(party SEPARATOR '<br>') AS partylist, documents.doctitle
FROM parties INNER JOIN documents ON parties.docid=documents.docid
WHERE parties.idcode = '$appidpassed'
               GROUP BY parties.docid
LIMIT 1
") or die(mysql_error());

while($row = mysql_fetch_array($result2))
{
$doctitle = $row['doctitle'];
   $parties = $row['partylist'];


}

and then further down the page:

$doctitle<br>
$parties

This only gives one document and the parties associated with it. I know the solution is probably easy but I can't see it.

Does anyone have any ideas?

Lists From Tables - Arrays?

Similar Tutorials

View Content

Hi

I am having problems trying to view some data and wondered if anyone could help.

I have a table called 'parties' which contains fields - partyid, docid and party. There is another table called 'documents' which has fields - docid and doctitle.

I have a number of documents and for each document there are a number of parties - ie people linked to that document.

What I would like to do is get a view on screen (and also printed out) that has the title of the document followed by a list of the parties associated with that document.

For example, if in the documents table there was:

|docid   |doctitle     |
|1     |first document   |
|2     |second document|

and in the parties table there was:
|partyid   |docid   |party   |
|1      |1     |Fred    |
|2      |1     |Jim    |
|3      |1     |Jane   |
|4      |2     |Peter   |
|5      |2     |Fred     |

I could get a view that looked like:

First document:
Fred
Jim
Jane

Second document:
Peter
Fred

I suspect it may involve arrays but I have never used them so any guidance would be very welcome.

Thanks

Nested Unordered Lists - Anybody?

Similar Tutorials

View Content

Hi,
for uni i've got to make a shopping cart application in php/mysql. I'm almost done with it, managed to teach myself some nifty jquery and have been able to learn loads more PHP, I'm really enjoying it. I've come to a bit of a stand still though, I showed my application as it is to my lecturer and he had one little point.
My application, you have lists, each list has its own categories (users can add, edit, delete their own) and in each category, there are items (which like categorys can be added, edited or deleted).

So basically, you have a browse_list.php, which browses all the lists, each list has it's own unique hyperlink to browse_list_category.php?list_id= using the get method, it selects all the categories associated with that list, which, like browse_list.php have their own hyperlinks, but this time they link to browse_category_item.php?category_id= and they list what ever items are associated with that category. Sounds a mouth full, but it's really quite simple.

I showed my lecturer that and he wasn't happy with the whole category/item layout. He said it would be better if the category list had a nested item list underneath it. He was happy with the whole list to category part with the hyperlink, though.
Kinda like:

Quote

-list
-------category
-------item
-list1
------category1
------item1
------category2
------item2
------category3
------item3

My database layout is
tbllist -main list table, list_id, list_name
tblcategory - main category table, category_id, category_name
tblcategory_list - link table for list and category (many-many) list_id, category_id
tblitem - main item table, item_id, item_name
tbl_category_item - link table for category and item (many-many) category_id, item_id

So, now you've kinda got the gist of what I'm doing.. I just need help with displaying each item in a category, under the category.. like a nested list
<ul>
<li>category 1</li>
<ul>
<li> item 1</li>
<li> item 2</li>
<li> item 3</li>
</ul>
</ul>

I did try and have a go earlier, kinda rushed and managed to come up with this:
<ul id="sortme" class="shoppinglist">
<?php
// Split records in $result by table rows and put them in $row.
while($row = mysql_fetch_array($result)) {
echo '<li class="list" id="' . $row['category_id'] . '"><div class="text"><a href="browse_item_category.php?category_id=' . $row['category_id'] . '">' . $row['category_name'] . "</a></div> <div class=\"actions\"><a href=\"#\" class=\"tick\">Tick</a> <a href=\"categoryupdater.php?category_id=" . $row['category_id'] . "\" class=\"edit\">Edit</a><a href=\"#\" class=\"delete\">Delete</a></div> </li>\n";
}
?><ul id="sortme" class="shoppinglist">
<?php
while($row = mysql_fetch_array($resultitem)) {
echo '<li class="list" id="' . $row['item_id'] . '"><div class="text">' . $row['item_name'] . "</div> <div class=\"actions\"><a href=\"#\" class=\"tick\">Tick</a> <a href=\"itemupdater.php?item_id=" . $row['item_id'] . "\" class=\"edit\">Edit</a><a href=\"#\" class=\"delete\">Delete</a></div> </li>\n";
}

?>
</ul>
</ul>

but this i get this

not the whole list nested'ness

it's a bit long winded I know but could anyone possible give me a hand? i've done pretty well so far not asking for help, but I think this is going to be the end of me!

Drop Down Lists From A Database

Similar Tutorials

View Content

How To Order Lists Correctly In A Loop ?

Similar Tutorials

View Content

i have a list of check boxes
im ordering it according to Amenity name ASC
im floating 2 divs (columns)side by side

how can i get the list to echo it according to ABC :
like this::?

A D
B E
C F
Code: [Select]
<?php
              echo '<div style="height:800px;" />';
              foreach($amens as $amen) {
              echo '<div style="float:left;padding-left: 2px;width:200px;"><input onclick="changedata(this)" type="checkbox" id="mm'.$amen['Amen_ID'].'" value="'.$amen['Amenity'].'" '.checkAmenity($id, $amen['Amenity']).' /><label style="padding-left:3px;" for="mm'.$amen['Amen_ID'].'">'.$amen['Amenity'].'</label></div>';

              }
echo '</div>';
              ?>

Stuck, On Populating Multiple Lists

Similar Tutorials

View Content

Ok, so i got this website project dropped in my lap, and I'm stuck not really having done much php coding ever. I have a database which is linked already, and it was working when pulling data from a specific table. The problem arose when I was asked to make it work with other tables. I have a table with the table names in it, and the drop down field to select the table populates. The next field is a multiple select field that is supposed to populate report dates from the previously selected table, and then finally the last multiple select field is supposed to populate with names that match the dates selected from the previous field. The last one I can live without, as the existing code takes into account if the name selected doesn't exist in the table with the selected date, but at the moment the date field just comes up blank. Any help would be greatly appreciated.

Lists Problem With Tempory Operators

Similar Tutorials

View Content

Hello.

Im having trouble using a Tempory Operator in a list. maybe someone might know a way around it.

so the list below has 3 Tempory Operators.

the first 1 looks for pages with links that are internal links
the first 2 looks for pages with links that are external links
the first 3 looks for pages with links that have no links

if the link is a "nonTitle" it will be a normal list item
if the link is a "title" it will be a header for a sub list (class="subexpandable")

the problem is that every time it gets to the '; at the end of each Tempory Operators it breaks

THIS IS NOT WORKING
Code: [Select]
<ul>
//FIND INTERNAL LINKS
echo $type == "internal" && $list == "nonTitle" ? '<li><a href="index.php">'.$title.'</a></li>' : '<li><a href="index.php" class="subexpandable">'.$title.'</a>';

//FIND EXTERNAL LINKS
echo $type == "external" && $list == "nonTitle" ? '<li><a href="http://www.url.com">'.$title.'</a></li>' : '<li><a href="http://www.url.com" class="subexpandable">'.$title.'</a>';

//FIND NON LINKS
echo $type == "non" && $list == "nonTitle" ? '<li><a>'.$title.'</a></li>' : '<li><a class="subexpandable">'.$title.'</a>';

//GET SUB LINKS
echo'
<ul class="subcategoryitems" style="margin-left: 15px">
<li><a href="">sub link</a></li>
</ul>
</li>
</ul>';

If i put the sub level inside of each type it works but then i keep having to use the same code over.

THIS IS WORKING

Code: [Select]
<ul>
//FIND INTERNAL LINKS
echo $type == "internal" && $list == "nonTitle" ? '<li><a href="index.php">'.$title.'</a></li>' : '<li><a href="index.php" class="subexpandable">'.$title.'</a>
<ul class="subcategoryitems" style="margin-left: 15px">
<li><a href="">sub link</a></li>
</ul>
</li>';

//FIND EXTERNAL LINKS
echo $type == "external" && $list == "nonTitle" ? '<li><a href="http://www.url.com">'.$title.'</a></li>' : '<li><a href="http://www.url.com" class="subexpandable">'.$title.'</a>
<ul class="subcategoryitems" style="margin-left: 15px">
<li><a href="">sub link</a></li>
</ul>
</li>';

//FIND NON LINKS
echo $type == "non" && $list == "nonTitle" ? '<li><a>'.$title.'</a></li>' : '<li><a class="subexpandable">'.$title.'</a>
<ul class="subcategoryitems" style="margin-left: 15px">
<li><a href="">sub link</a></li>
</ul>
</li>';

</ul>';

so is there a way to do the first example without having to do the second example

thanks
ricky

Selected Index And Drop Down Lists

Similar Tutorials

View Content

Hi,

A quick question please , I am trying to assign a selected index to a drop down list based on data retrieved from the database.

I tried using JavaScript :
document.getElementById('Country').selectedIndex ='".$array['Country']."';

but it does work. Any suggestion?

Multiple Drop Down Lists Via Php Mysql

Similar Tutorials

View Content

Hello Friends!.... here is the big idea. I am trying to make a form in which there will be 2 drop down lists which will be populating directly from MySQL DB ....
Actually i am developing a student management system as my first PHP project... here i want to have 2 drop down lists first is roll number and second is student name. i want that when some one select the roll number in the first drop down the student name against it is automatically populated in the next drop down.

please help me friends i am new to php and dont know soo much.! any help PLZZZZZZZZZZ

Moved: Question On Using Css Menuing With Unorganized Lists And The A Tag

Similar Tutorials

View Content

This topic has been moved to CSS Help.

http://www.phpfreaks.com/forums/index.php?topic=329775.0

Populating Dropdown Lists With Mysql , Then Submitting Form To New Table

Similar Tutorials

View Content

hello. i have an issue where the data stored with an image is not saving to a mysql table.
the image data is ok, just not the selections from the dropdown lists.

here is the code

<?php
include ('connect.php');

// Insert any new image into database
if(isset($_POST['xsubmit']) && $_FILES['imagefile']['name'] != "") {
$fileName = $_FILES['imagefile']['name'];
$fileSize = $_FILES['imagefile']['size'];
$fileType = $_FILES['imagefile']['type'];
$content = addslashes (file_get_contents($_FILES['imagefile']['tmp_name']));
$jeweltype = $_POST['jeweltype'];
$jewelsize = $_POST['jewelsize_in'];
$jewelcolour = $_POST['jewelcolour_in'];
$jewelmaterial = $_POST['jewelmaterial_in'];
$jewelgender = $_POST['jewelgender_in'];

if(!get_magic_quotes_gpc()) {
$fileName = addslashes($fileName);
}

// Checking file size
if ($fileSize < 150000) {
mysql_query ("INSERT into jewel_images (name,size,type,content,jeweltype,jewelsize,jewelcolour,jewelmaterial,jewelgender) "
. "values ('$fileName','$fileSize','$fileType','$content','$jeweltype','$jewelsize','$jewelcolour','$jewelmaterial','$jewelgender')");
} else {
$err = "The Image file to too large!";
}
}

// Find out about latest image

$gotten = mysql_query("select * from jewel_images order by row_id desc");
$row = mysql_fetch_assoc($gotten);
$bytes = $row['content'];

// If this is the image request, send out the image

if ($_REQUEST['pic'] == 1) {
header("Content-type: $row[type];");
print $bytes;
}
?>
<html>
<head>
<title>Upload an image to a database</title>
</head>
<body>
<font color="#FF3333"><?php echo $err ?></font>
<table>
<form name="Upload" enctype="multipart/form-data" method="post">
<tr>
<td>Upload <input type="file" name="imagefile"><br />
Jewelery Type:
<select>
<?php
$sql="SELECT jeweltype FROM jeweltypes";
$result =mysql_query($sql);
while ($data=mysql_fetch_assoc($result)){
?>
<option value ="jeweltype" ><?php echo $data['jeweltype'] ?></option>
<?php } ?>
</select>
<br />
Jewelery Size:
<select>
<?php
$sql="SELECT jewelsize FROM jewelsizes";
$result =mysql_query($sql);
while ($data=mysql_fetch_assoc($result)){
?>
<option value ="jewelsize" ><?php echo $data['jewelsize'] ?></option>
<?php } ?>
</select>
<br />
Jewelery Colour:
<select>
<?php
$sql="SELECT jewelcolour FROM jewelcolours";
$result =mysql_query($sql);
while ($data=mysql_fetch_assoc($result)){
?>
<option value ="jewelcolour_in" ><?php echo $data['jewelcolour'] ?></option>
<?php } ?>
</select>
<br />
Jewelery Material:
<select>
<?php
$sql="SELECT jewelmaterial FROM jewelmaterials";
$result =mysql_query($sql);
while ($data=mysql_fetch_assoc($result)){
?>
<option value ="jewelmaterial_in" ><?php echo $data['jewelmaterial'] ?></option>
<?php } ?>
</select>
<br />
Jewelery Gender:
<select>
<?php
$sql="SELECT jewelgender FROM jewelgenders";
$result =mysql_query($sql);
while ($data=mysql_fetch_assoc($result)){
?>
<option value ="jewelgender_in" ><?php echo $data['jewelgender'] ?></option>
<?php } ?>
</select>
<br />
<input type="submit" name="xsubmit" value="Upload">
</td>
</tr>
<tr>
<td>Latest Image</td>
</tr>
<tr>
<td><img src="?pic=1"></td>
</tr>
</form>
</table>
</body>
</html>

==============================================
here is the query
===============================================

<html>
<head><title>Your Page Title</title></head>
<body>
<?php
$database="josh_jewel";
mysql_connect ("localhost", "xxxxxxxxx", "yyyyyyyyyyyy");
@mysql_select_db($database) or die( "Unable to select database");
$result = mysql_query( "SELECT jewelcolour FROM jewel_images" )
or die("SELECT Error: ".mysql_error());
$num_rows = mysql_num_rows($result);
print "There are $num_rows records.<P>";
print "<table width=400 border=1>\n";
while ($get_info = mysql_fetch_row($result)){
print "<tr>\n";
foreach ($get_info as $field)
print "\t<td><font face=arial size=1/>$field</font></td>\n";
print "</tr>\n";
}
print "</table>\n";
?>
</body>
</html>

Changing Background Color In Lists Using Hex Codes Array In For Loop

Similar Tutorials

View Content

I was trying to show different hex codes as background in a loop for each section of a list.

Here's what I done
Code: [Select]

$rgb;
$rgb["c1"] = "ff4c54";
$rgb["c2"] = "ff764c";
$rgb["c3"] = "ffde4c";
$rgb["c3"] = "c7f25f";
$rgb["c4"] = "33c9f7";
$i=0;
$pargs = array( 'numberposts' => 10,'orderby'=> 'comment_count', );
$myposts = get_posts( $pargs );$max_count=0;
<ul>
foreach( $myposts as $post ) : setup_postdata($post);

<li style="width:300px;background-color:#<?php foreach($rgb as $color => $hex) {
    echo $hex[i];
    $i++;
}  ?>">
<a href="<?php the_permalink(); ?>"><?php the_title(); ?></a> - </li>
<?php endforeach; ?>
</ul>

Ending up with just the white background.. and no change in the background colors.

Kindly help