PHP - Multiple While's, Single Query - Is There A Way?

Hey guys,

I'll be the first to say that I'm a real php n00b, and only understand the basics.
I have a website already in place that someone else coded and I just need to add something to.

There's a form that posts to another page and then back to a sql database. What I want to do is have the form also email me the contents of the form when it is submitted.

Is there a way to have a form do multiple actions? I'm not sure the best way to go about this, so if someone has some pointers, I'd really appreciate it.

Thanks!

I have the form:

Hi there im trying to set a single variable multiple rows of data that are echoed using a single variable. The trouble is i just cant seem to make it work by trying to add a while or do loop..

The variable is $alderaanfleetalt  and consists of:

Code: [Select]
$fleetname = "FleetName";
$shipname = "Ship Name";
Which is just text stored in two other variables. The select query row of data is added the $alderaanfleetalt variable.

Code: [Select]
$alderaanfleetalt =  $fleetname." ".$row_Alderaanfleet['FleetName']."</br>".$shipname." ".$row_Alderaanfleet['ShipName'];
At the moment only a single row appears. ive tried to add a while/do loop so that multiple rows are outputted but its not working.

Code: [Select]
do{
$alderaanfleetalt =  $fleetname." ".$row_Alderaanfleet['FleetName']."</br>".$shipname." ".$row_Alderaanfleet['ShipName'];
} while ($row_Alderaanfleet = mysql_fetch_assoc($Alderaanfleet));

Im a bit lost here and not even sure it can be done this way... Any help would be ace.

Thank you

Hi.   I have a product database w/ tables each for product series, model, sub-model and optionals. One item in each of these makes up one product. So Series K, Model 7, sub-model 2, optional 3 will be a product called K 7/2-3 .The permutations and combinations of these are all possible products.   In the same db, I have a quotations table. Each quotation has a unique id / record.  A quotation can include any number of products : it can have K 7/2-3, KA 561/1-2 , FPN 311/2-1  or it can only have KA 561/1-2 etc.   Now I am stuck. Don't know how to   a. structure the quotations table   b. create a MySQL select so that one statement can make multiple selections . I thought of using a checkbox but that doesn't work either since the series/model/sub model/optionals must chosen sequentially.   Any ideas I can follow thru ?   Many thanks Swati      

Hi all,

slightly confusing title!

What I am trying to do is make a simple stores system whereby I can add and remove stores.

It is purely php and no mySQL.

My idea was to create a text file with the individual number and then include the file on the table on the page.

I have worked out how to increment one value by one, but the others I am struggling with.

Example I wish to have two links one which I click to increase and another to decrease the value by one. 

It's the multiple issue that is confusing me, I create a txt file and a php file using a variable from a submitted form (part number).  The php file holds info and the text file holds the number which is default at '0' (Zero).

My idea was to write some php to the file, perhaps when I click the plus it will open and write to the file + 1 ..

Any guidance or points in the right direction would be greatly appreciated.  Thanks.

Shugs

I'm so sorry for this question but I not really know how to play with single and double quote.

If I have a query like this:

Code: [Select]
  mysql_query('UPDATE table SET Status=1,Sending=Done WHERE ID IN ('.implode(',', $done).')');
And I wish to add Code: [Select]
SentAt='$date' in the query as well , and I try this:

Code: [Select]
  mysql_query('UPDATE table SET Status=1,Sending=Done,SentAt='$date' WHERE ID IN ('.implode(',', $done).')');
Not working...how should I write it?

Thank you.

This topic has been moved to MySQL Help.

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

Hey Im always trying to remove code and cut corners to reduce work in the long run, soIim wondering how I could link my menu bar from say a template to ALL my php pages for my site so I don't have to write/change links on every page when I need to.

Thanks

I have stored supplier information in a table and same form user will select multiple products for that supplier and that will be stored in a seperate table against that supplier id. Now when i would like to display all supplier information with muliple products in a single line. Now all the information will be displayed as many time as the products are. How to display all the products in a same line.    Now my display is like this  

if(isset($_POST['submit']) && ($_POST['vendor']!='') && ($_POST['item']!=''))
{
$sql="SELECT supplier.id AS sid, supplier.name AS SNAME, supplier.category, supplier.website, supplier.email, supplier.phone, supplier.vat, supplier.pan, supplier_location.id, supplier_location.supplier_id, supplier_location.location, supplier_products.id, supplier_products.supplier_id, supplier_products.product_id, location.loc_id, location.name AS locname, products.product_id, products.name AS pname FROM supplier INNER JOIN supplier_location ON supplier.id = supplier_location.supplier_id INNER JOIN supplier_products ON supplier.id=supplier_products.supplier_id INNER JOIN location ON supplier_location.location = location.loc_id INNER JOIN products ON supplier_products.product_id=products.product_id WHERE supplier.id=".$sup." AND supplier_products.product_id=".$product;
$sql1 = mysql_query($sql) or die(mysql_error());


<table>
<thead><tr>
<th>Vendor ID</th>
<th>Vendor</th>
<th>Category</th>
<th>Website</th>

<th>Email</th> 

<th>Phone</th>
<th>Products</th>
<th>Locations</th>
 <th>VAT</th>
  <th>PAN</th>
                        
                       
                        


</tr>


</thead>
<tbody> 


<tr>
<?php
while($row = mysql_fetch_array($sql1))
{ 


?>
   
   
    <td><?php echo $row['sid'] ?></td>
<td><?php echo $row['SNAME'] ?></td>
    <td><?php echo $row['category'] ?></td>
    <td><?php echo $row['website'] ?></td>
     <td><?php echo $row['email'] ?></td>
    <td><?php echo $row['phone'] ?></td>
    <td><?php echo $row['iname']; ?></td>


    <td><?php echo $row['locname']; ?></td>


    <td><?php echo $row['vat'] ?></td>
    <td><?php echo $row['pan'] ?></td>




</tr>


<?php 




}
?>
</tbody></table>


}

Hi is it possible to update multiple records of the same table using a single hidden field with a while loop??? For example:

Code: [Select]
<?php if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE ships SET HealthA=%s WHERE ShipID=%s",
                       GetSQLValueString($_POST['healtha'], "int"),
                       GetSQLValueString($_POST['shipid'], "text")); ?>

 <input name="healtha" type="hidden" id="healtha" value="<?php echo $row_Ships['HealthA'] + 1; ?>" />
<input name="shipid" type="hidden" id="shipid" value="<?php  while($row = mysql_fetch_assoc($Ships)){ echo $row_Ships['ShipID']; }?>" />
If its not possible what else could i do to achieve this please?

Thank you

Hi, I have a table of content in my page. For each row it has a check box. How do i achieve the function of when i click on submit button, those rows which are checked will be downloaded as a single pdf file. For example, for each checked row is a PDF file here. Suppose if i checked for 5 rows , 5 PDFs will be downloaded.
Can i know how can i achieve this? 
Or is it not possible to do that for TCPDF library?
If it is possible, i would appreciate if you guys could give me hints or some reading documentation to achieve this function. I have no idea how should i search for the solution for this function.  Thanks in advance

Hi, I believe this is my first post on here. First off let me say thank you for silently helping out in the past while I keep on learning PHP.

I have decided to build an image gallery, and I am having problems with the page numbering links and the breadcrumbs.

Reson I decided to build my own is that I wanted a challange to learn more.
I could not find anything that would intregrate with the site as I wanted it to (pulled as a function so offers some customising with options).

The problem that I am having is that the <a href= tag is starting to give multipul "/"s when I only need one, so that the url at the top is coming up as

http://localhost/mmv4/gallery/pics///Ax/Ax_Jo/

when I am wanting http://localhost/mmv4/gallery/pics/Ax/Ax_Jo/IMG_4244.JPG.

I have used str_replace to catch //s and more, but this then adds odd slashes on the end so the page numbeing is getting odd results. some dirs have the / on the end and some do not, so the links are sometimes "visited" and others not.

I beleve that the problem is generated in
Code: [Select]
<?php
if(isset($_GET['album'])) {
      //load the available dirs into an array so that the sneeky users cannot get further back.
      $files = scandir($gal);
      $dirs = array();
      foreach($files as $file){
         if($file != '.' && $file != '..' && $file != 'thumbs') {
            if(is_dir($gal."/".$file)) {
               $dirs[] = $file;
               //echo $file ."<br />\n";
            }
         }
      }
      
      //if(in_array($_GET['album'],$dirs)) {
         $album = "/".$_GET['album']."/";
         $album = str_replace("..", "", $album);
      //}
      //else {
      //   $output .= "<p>There is no album called \"$_GET[album]\", please select an album from below.</p>";
      //}
   }

or the breadcrumbs bit
Code: [Select]
<?php
if($crumbs == 1) {
      //bread crums
       $path = $gal.$album;
       $path = explode("/", $path);
   
   
       $crumbs = array();
       foreach($path as $key => $value) {
          if($value != ""){
             $crumbs[] = $value;
          }
       }
       // create Breadcrumbs div
   
       $output .= "<div id=\"breadcrumbs\">";
       $number = count($crumbs);
       $real = "";
       foreach($crumbs as $num => $link) {
          if ($link == $gal) {
             $link = "Gallery Home";
          }
          if ($num == $number -1) {
             $output .= $link;
          }
          else{
             if ($num >= 1){
                $real ="";
                for($x=1; $x<=$num; $x++) {
                   $real .= "/".$crumbs[$x];
                }
                $output .= "<a href=\"?album=".str_replace("/", "",$real)."\">".$link."</a>"." <- ";
             }
             else{
                $output .= "<a href=\"?album=".str_replace("/", "",$real)."\">".$link."</a>"." <- ";
             }
          }
          $num +1;
         
       }
   
       //close breadcrumbs div
       $output .= "</div>";
   }

Can any one please help me shed some light on this one, I am confused.
I can send / attach the full source if needed.

MOD EDIT: tags fixed for syntax highlighting . . .

Hi All

 

I have not really played around with PHP in ages so I am having a hard time trying to figure out the best way to proceed. Anyhow... what I need to get done is to take a singleton pattern core database class that has a extended driver based class (ie; the type of database server the connection is connecting to), and build a new class that dynamically handles as many driver based connections that are called using a single instance. As a side note, I tried PDO but it only supports a single driver per class instance, and then each of those connections cannot not have their on set of properties that relate to each connection. Anyway, I was thinking that the best way to handle all the driver specific connections, is to hand out a 'unique hash reference' that points to an array of connection objects and the object properties. then when the client runs any sql function they pass the 'unique hash reference'  which the class then returns the object and it properties that will be used by the class to call up the driver specific sql function that was requested by the client. So what do you all thing about that....

 

TIA

stephanieT

 

PS...

 

I reason i need this is because I need to update up 25 different databases based on data stored on all the databases and  not all of the database servers are of the same type, (ie; MSSQL, Oracle, MySQL, MariaDB, berkeley DB, postgres, sqlite2,3, etc, etc)!

Edited January 16, 2019 by StephanieT

I know it needs a for loop, but i don't know where in the code i should be putting it?

Code: [Select]
function check_input($value)
{
// Stripslashes
if (get_magic_quotes_gpc())
  {
  $value = stripslashes($value);
  }
// Quote if not a number
if (!is_numeric($value))
  {
  $value = "'" . mysql_real_escape_string($value) . "'";
  }
return $value;
}

$_POST = array_map('check_input', $_POST);

$sql="INSERT INTO testimonials (CustomerName, Town, Testimonial, SortOrder, Images)
VALUES
({$_POST['customername']}, {$_POST['town']}, {$_POST['testimonial']}, {$_POST['sort_order']}, '$imgname'

)";

}
if (!mysql_query($sql,$con))
  {
  die("<br>Query: $sql<br>Error: " . mysql_error() . '<br>');
  }
echo "<p align=center><b>1 testimonial added</b></p>";

mysql_close($con);


Thanks in Advance,
Steve

I am creating a user inbox system. I am retrieving all the unread messages. Each message row contains a "reply" form. So say I have 10 messages showing on a single page. That's 10 forms.

What I would like to know is how can I submit any one of the 10 forms and not have it affect the remaining 9 forms?

Here is the basic code.

if(isset($_POST['submit'])) {
  $post_message = trim($_POST['message']);

  $errors      =  array();
  $db->beginTransaction();

  if(empty($post_message)) {
    $errors[] = 'The message field can not be empty!';
  }

  if(empty($errors)) {
    $db->commit();
    
    echo 'success';

  } else {
    $db->rollBack();
  }
}
<form action="" method="post">
  <fieldset>
    <textarea name="message" maxlength="10000" placeholder="What would you like to say?"></textarea>
  </fieldset>
  <fieldset>
    <input type="submit" name="submit" value="Submit" />
  </fieldset>
</form>