PHP - Multiple Data In A Single Record

I am having a problem applying pagination to my page when I only have one record displayed.  I would like to have it set up to where one record is followed by the next one in the list.  I have tried several ways but they are for whole tables moving to the next page.  I think I am missing something small but not sure.  Any help will be greatly appreciated, thanks.

Hi,

I have a menu that is generated from my mysql database and I want it on every page of my website as the main menu. However I can''t figure out how to do this. I managed to get it on the view article page by duplicating the my query like this:
Code: [Select]
function viewArticle() {

  if ( !isset($_GET["articleId"]) || !$_GET["articleId"] ) {
    homepage();
    return;
  }

  $result['article'] = Article::getById( (int)$_GET["articleId"] ); //single record
  $result['pageTitle'] = $result['article']->title . " | Widget News";

  $results = array();
  $all_data = Article::getList( HOMEPAGE_NUM_ARTICLES ); //multiple record
  $results['articles'] = $all_data['results'];
  $results['totalRows'] = $all_data['totalRows'];

  require( TEMPLATE_PATH . "/viewArticle.php" );
}

However I can't figure out how to place it on for example the new article page.
Code: [Select]
function newArticle() {

  $results = array();
  $results['pageTitle'] = "New Article";
  $results['formAction'] = "newArticle";

  if ( isset( $_POST['saveChanges'] ) ) {

    // User has posted the article edit form: save the new article
    $article = new Article;
    $article->storeFormValues( $_POST );
    $article->insert();
    header( "Location: admin.php?status=changesSaved" );

  } elseif ( isset( $_POST['cancel'] ) ) {

    // User has cancelled their edits: return to the article list
    header( "Location: admin.php" );
  } else {

    // User has not posted the article edit form yet: display the form
    $results['article'] = new Article;
    require( TEMPLATE_PATH . "/admin/editArticle.php" );
  }

}

Can anybody help me out i'm really struggling?
Thanks

Hello PHP experts.
Please help me on this.
I have created a form at http://lakshwebdesign.com/clients/onev8llc/qualitynew-site/instantfreequote.html
How do I add these 3 PHP functionalities to it:-

1) On submit, all the data be sent to an email address.
2) Also, record it in database.
3) Record date on which the form is submitted.

I have knowledge of PHP and I can understand the codes somewhat so I am not a complete beginner of PHP.

Any help will be highly appreciated.

Thanks in advance.

I can use the first while loop, but there is no data in the second while loop. Is there a better way as I have never done this before...

Code: [Select]
              <?php
                $featured_results = mysql_query("SELECT * FROM products LEFT JOIN product_images ON products.product_id=product_images.product_id WHERE products.product_featured='1' AND products.product_active='1' AND thumb='1'");

$fa=0;
while($featured_row = mysql_fetch_assoc($featured_results))
   {
$fthumb_result = mysql_query("SELECT image_name FROM product_images WHERE product_id='".$featured_row['product_id']."' AND thumb='1'");
$fthumb = mysql_fetch_row($fthumb_result);

if ($fa==0) {
echo "\n<img id=\"home-slider-photo-".$fa."\" class=\"home-slider-photo preload\" src=\"/includes/getimage.php?img=".$fthumb[0]."&w=370&h=370\" alt=\"\" />";
} else {
echo "\n<img id=\"home-slider-photo-".$fa."\" class=\"home-slider-photo preload home-slider-photo-unsel\" src=\"/includes/getimage.php?img=".$fthumb[0]."&w=370&h=370\" alt=\"\" />";
}
$fa++;
}

echo "<div id=\"home-slider-photo-price\">";
$fb=0;
while($featured_row2 = mysql_fetch_assoc($featured_results))
   {
if ($fb==0) {
echo "\n<div id=\"home-slider-photo-price-".$fb."\" class=\"home-slider-photo-price\">\n<span>only</span>$".$featured_row2['product_price']."\n</div>";
} else {
echo "\n<div id=\"home-slider-photo-price-".$fb."\" class=\"home-slider-photo-price home-slider-photo-price-unsel\">\n<span>only</span>$".$featured_row2['product_price']."\n</div>";
}
$fb++;
}
echo "</div>";
?>

Hi all, Im really struggling to build an update multiple records form, Ive built my table which calls all data i need from the db in a looped region which works fine I just cant understand how to then input these back into the table in the correct rows, if this makes sense? Ive been reading this tutorial but Its not very informative its more of a copy and paste http://www.phpeasystep.com/mysql/10.html

Hi: Am not sure if this is the best algorithm to go about  saving a record and uploading (plus moving to another directory) files. I feel i need another algorithm?

if (self::post()->isPost()) { 
                           
            #check if there is any file
            if($this->request->hasFiles() == true){            
                    $uploads = $this->request->getUploadedFiles();
                    $isUploaded = false;
                    #do a loop to handle each file individually
                    foreach($uploads as $upload){
                        #define a "unique" name and a path to where our file must go
                        $path = 'temp/'.md5(uniqid(rand(), true)).'-'.strtolower($upload->getname());

                        #move the file and simultaneously check if everything was ok
                       if($upload->moveTo($path)) {                          
                        #Build an array to be sent to the API for moving the uploaded file to front end directory                        
                           $files="";
                           $files = array(
                            'name' => $upload->getName(),
                            'link' => $this->di['url']->get('temp/' . $upload->getName()),
                            'direction' => 'adverts'
                            );
                        
                          $saveResult = self::request()->request('move-advert/', array('file' => $files), 'POST');
                          if($saveResult->response == 'success') $isUploaded = true; else $isUploaded = false;                          
                           
                       }
                    }
                    #if any file couldn't be moved, then throw an message
                    if($isUploaded) {                         
                        
                        $save_response = self::request()->request('advert/' . $id, self::editValues(self::post()->getPost()), 'POST');
                        if ($save_response->response == 'success') 
                            {
                                 $this->flashSession->success('Advert Updated');
                                 return $this->response->redirect('adverts/list-adverts');
                            } else {
                                $this->flashSession->notice('Could not update Advert');
                            }                                             
                        
                    } else {
                            $this->flashSession->notice('Some error ocurred. Please try again');
                   }
             
             }else {            
                 $this->flashSession->notice('You must Choose an advert image');
            }    
        }

Any suggestions?

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 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

Hi Everyone.

i have a page which list all records. i then have several detail pages which i need to link via the id number. for ex.

records:
id number name
1 john smith
2 peter parker

the detail page is layout out like so:
View details page 1 | view details page 2 | view details page 3

Any help would be appreciated. Thanks.

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, 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

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

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