PHP - Opinion: Multiple Websites Same Data: Individual Db's Or Single Db?

Hey everyone
 I'm pulling data from my db and then trying to store each value to its own var. the problem is the amount of values is always changing.

here is what I have that isnt working

$result = mysql_query("SELECT thismonth FROM list");

while($row = mysql_fetch_array($result))
  {
echo $row[0] . "<br>";  // this prints out all the values perfectly
     
  }
  


no I just dont know how to store them so i can use them later.

I have 2 websites
currentweb.com
copyweb.com (say)

Using php can I update
2 databases
and
upload files in both these 2 websites (
for both these web sites I have user id and password

exmaple I am uploading a file (Image), in currentweb.com
can I upload it to copyweb.com at the same ( I have database and ftp password for this )

If Yes Please help with code

is it possible to collect data from another website and insert it into my db?, lets say for example: http://www.imdb.com/title/tt0285331/episodes#season-1

could i somehow get the Episode name eg: Quote

Episode 1: 12:00 a.m.-1:00 a.m.

and the description Quote

Jack Bauer is called to his office because there's a threat on the life of a US Senator who's running for President; Jack also discovers that his daughter has skipped out her bedroom window.


and place that into a table in my db?

any help would be great.

I have created 5 websites under 5 different domains. Contents of this websites' are similar and using a same template for each one. Now I need to create an admin panel to control these websites. PHP and MySql I will use for this backend.   My problem is how can I manage these five website with one backend? Reason is I will use different domain for my backend. My all 5 client will use this same backend system to manage their own website.   So can I know from the professionals here, is it possible to display mysql data on these 5 website. If it is possible then how? Any links to article or tutorials would be welcome and appreciated.   NOTE: I checked

mysql federated storage engine

but no idea? Is it the way where do I need to go?   Thank you.

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>";
?>

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!

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

I have the form:

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

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

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, I'm modifying the following PHP code from a Wordpress plugin:

/* Byline. */

if ( $instance['byline'] )
echo do_shortcode( "<p class='byline'>{$instance['byline']}</p>" );

/* Entry title. */

if ( 'widget' !== $instance['entry_container'] && $instance['entry_title'] && $show_entry_title ) {
the_title( "<{$instance['entry_title']} class='entry-title'><a href='" . get_permalink() . "' title='" . the_title_attribute( 'echo=0' ) . "' rel='bookmark'>", "</a></{$instance['entry_title']}>" );
}
elseif ( 'widget' !== $instance['entry_container'] && $show_entry_title ) {
the_title( "<a href='" . get_permalink() . "' title='" . the_title_attribute( 'echo=0' ) . "' rel='bookmark'>", "</a>" );
}

The output currently is:
Code: [Select]
[ December 13, 2010 ]

Post Title
I'm trying to combine the two so that the output appears on one line.  What is the operator to execute multiple command in one statement?

Thanks.

This is a bit of a more advanced question so I am hoping there are some advanced programmers online at this time . Anyways basically I want to be able to "queue" functions from a class in a single call and am wondering if I am doing it correctly or if there is a better way to do it. Here is my code:


<?php
class test {
     private static $one;
     private static $two;
     private static $three;

     public function callOne($val){
          $one .= $val;
          return $this;
     }
     
     public function callTwo($val){
          $two .= $val;
          return $this;
     }

     public function callThree($val){
           $three .= $val;
           return $this;
     }

     public function print(){
          echo $this->one.' '.$this->two.' '.$this->three;
     }
}
?>


now when I want to call this I can do:

$test = new test();
$test->callOne('one')->callTwo('two')->callThree('three');
$test->callOne('another one');
$test->print();


Is there a better way to do this or is there a different method of doing this? Just wanna make sure I am doing it right lol.