PHP - Combine 2 Files

Hi

I have an array which looks a little like this, the first number in each array is a quantity

$cars = array (
  array(1,"BMW",15,13),
  array(8,"BMW",15,13),
  array(3,"Saab",5,2),
  array(4,"BMW",11,7),
  array(5,"Land Rover",17,15),
  array(6,"Saab",5,2)
);

what I want to do is combine any array which matches another, but ignoring the quanitity value (first one).

Then creating the array again and adding up the quanitity values and re-inserting them at the start.

Therefore the end result would look like

$cars = array (
  array(9,"BMW",15,13),
  array(9,"Saab",5,2),
  array(4,"BMW",11,7),
  array(5,"Land Rover",17,15),
);

Has anyone got any ideas on how I might do this?

Thanks

Edited July 23, 2020 by John84

I know this involves MySQL, but it's mostly PHP, so I figured it should go here, forgive me if I posted in the wrong section, though.

Anyway! Let's get down to it. I'd like to combine these two scripts (below). I want the questionnaire script to be a signup requirement in the signup script, and I want it to log the questionnaire into my MySQL database as usual, then prompt the user with a successful sign up.

I'm still really new to PHP and I'm just testing to see if this'll work. How would I go about doing this? Thanks a LOT guys.

Questionnai

<?php
  // Start the session
  require_once('startsession.php');

  // Insert the page header
  $page_title = 'Questionnaire';
  require_once('header.php');

  require_once('appvars.php');
  require_once('connectvars.php');

  // Make sure the user is logged in before going any further.
  if (!isset($_SESSION['user_id'])) 
  {
    echo '<p class="login">Please <a href="login.php">log in</a> to access this page.</p>';
    exit();
  }

  // Show the navigation menu
  require_once('navmenu.php');

  // Connect to the database
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

  // If this user has never answered the questionnaire, insert empty responses into the database
  $query = "SELECT * FROM mismatch_response WHERE user_id = '" . $_SESSION['user_id'] . "'";
  $data = mysqli_query($dbc, $query);
  if (mysqli_num_rows($data) == 0) 
  {
    // First grab the list of topic IDs from the topic table
    $query = "SELECT topic_id FROM mismatch_topic ORDER BY category_id, topic_id";
    $data = mysqli_query($dbc, $query);
    $topicIDs = array();
    while ($row = mysqli_fetch_array($data)) 
{
      array_push($topicIDs, $row['topic_id']);
    }

    // Insert empty response rows into the response table, one per topic
    foreach ($topicIDs as $topic_id) 
{
      $query = "INSERT INTO mismatch_response (user_id, topic_id) VALUES ('" . $_SESSION['user_id']. "', '$topic_id')";
      mysqli_query($dbc, $query);
    }
  }

  // If the questionnaire form has been submitted, write the form responses to the database
  if (isset($_POST['submit'])) 
  {
    // Write the questionnaire response rows to the response table
    foreach ($_POST as $response_id => $response) 
{
      $query = "UPDATE mismatch_response SET response = '$response' WHERE response_id = '$response_id'";
      mysqli_query($dbc, $query);
    }
    echo '<p>Your responses have been saved.</p>';
  }

  // Grab the response data from the database to generate the form
  $query = "SELECT mr.response_id, mr.topic_id, mr.response, " .
    "mt.name AS topic_name, mc.name AS category_name " .
"FROM mismatch_response AS mr " .
"INNER JOIN mismatch_topic AS mt USING (topic_id) " .
"INNER JOIN mismatch_category AS mc USING (category_id) " .
"WHERE mr.user_id = '". $_SESSION['user_id'] . "'";
$data = mysqli_query ($dbc, $query);
$responses = array();
while ($row = mysqli_fetch_array($data)) 
{
  array_push($responses, $row);
}
  
  mysqli_close($dbc);

  // Generate the questionnaire form by looping through the response array
  echo '<form method="post" action="' . $_SERVER['PHP_SELF'] . '">';
  echo '<p>How do you feel about each topic?</p>';
  $category = $responses[0]['category_name'];
  echo '<fieldset><legend>' . $responses[0]['category_name'] . '</legend>';
  foreach ($responses as $response) 
  {
    // Only start a new fieldset if the category has changed
    if ($category != $response['category_name']) 
{
      $category = $response['category_name'];
      echo '</fieldset><fieldset><legend>' . $response['category_name'] . '</legend>';
    }

    // Display the topic form field
    echo '<label ' . ($response['response'] == NULL ? 'class="error"' : '') . ' for="' . $response['response_id'] . '">' . $response['topic_name'] . ':</label>';
    echo '<input type="radio" id="' . $response['response_id'] . '" name="' . $response['response_id'] . '" value="1" ' . ($response['response'] == 1 ? 'checked="checked"' : '') . ' />Love ';
    echo '<input type="radio" id="' . $response['response_id'] . '" name="' . $response['response_id'] . '" value="2" ' . ($response['response'] == 2 ? 'checked="checked"' : '') . ' />Hate<br />';
  }
  echo '</fieldset>';
  echo '<input type="submit" value="Save Questionnaire" name="submit" />';
  echo '</form>';

  // Insert the page footer
  require_once('footer.php');
?>



Signup:
<?php
  // Insert the page header
  $page_title = 'Sign Up';
  require_once('header.php');

  require_once('appvars.php');
  require_once('connectvars.php');

  // Connect to the database
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

  if (isset($_POST['submit'])) {
    // Grab the profile data from the POST
    $username = mysqli_real_escape_string($dbc, trim($_POST['username']));
    $password1 = mysqli_real_escape_string($dbc, trim($_POST['password1']));
    $password2 = mysqli_real_escape_string($dbc, trim($_POST['password2']));

    if (!empty($username) && !empty($password1) && !empty($password2) && ($password1 == $password2)) {
      // Make sure someone isn't already registered using this username
      $query = "SELECT * FROM mismatch_user WHERE username = '$username'";
      $data = mysqli_query($dbc, $query);
      if (mysqli_num_rows($data) == 0) {
        // The username is unique, so insert the data into the database
        $query = "INSERT INTO mismatch_user (username, password, join_date) VALUES ('$username', SHA('$password1'), NOW())";
        mysqli_query($dbc, $query);

        // Confirm success with the user
        echo '<p>Your new account has been successfully created. You\'re now ready to <a href="login.php">log in</a>.</p>';

        mysqli_close($dbc);
        exit();
      }
      else {
        // An account already exists for this username, so display an error message
        echo '<p class="error">An account already exists for this username. Please use a different address.</p>';
        $username = "";
      }
    }
    else {
      echo '<p class="error">You must enter all of the sign-up data, including the desired password twice.</p>';
    }
  }

  mysqli_close($dbc);
?>

  <p>Please enter your username and desired password to sign up to Mismatch.</p>
  <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
    <fieldset>
      <legend>Registration Info</legend>
      <label for="username">Username:</label>
      <input type="text" id="username" name="username" value="<?php if (!empty($username)) echo $username; ?>" /><br />
      <label for="password1">Password:</label>
      <input type="password" id="password1" name="password1" /><br />
      <label for="password2">Password (retype):</label>
      <input type="password" id="password2" name="password2" /><br />
    </fieldset>
    <input type="submit" value="Sign Up" name="submit" />
  </form>

<?php
  // Insert the page footer
  require_once('footer.php');
?>


And here are the pastebins in case you prefer those:

http://pastebin.com/pTXGSMT9 - Questionnaire

http://pastebin.com/28jZhYyY - Signup

Thanks!

I am attempting to flush values from a URL query with a pagation script.

This line of code will replace one value:
$page_name2 = preg_replace('/&?start=\d+/','',$page_name);

This line of code will replace the second value:
$page_name3 = preg_replace('/&?limit=\d+/','',$page_name);

Can I combine them to replace both values in replace?

This obviously isn't it:
$page_name3 = preg_replace(('/&?limit=\d+/','',)&&('/&?start=\d+/','',)$page_name);

Thank you.

I've been working on this too long, without having it figured out.  Starting to get a bit 'kooky' at this point!  I'm one stage away from retarded frustration.

I have two arrays, such as these:

Array 1 ( => 7|1|0|5|0|0 [1]  => 7|3|0|5|0|0 [3] => 7|4|0|5|0|0 [4] => 7|5|0|5|0|0 [5] => 7|6|0|5|0|0 [6] => 7|7|0|5|0|0 )
Array 2 ( => 8|1|0|5|0|0 [1] => 7|2|0|5|0|0 [2] => 7|3|0|5|0|0 [3] => 7|4|0|5|0|0 )

I am trying to write a piece of code that will compare every value in array 2 to every value in array 1 and if the first 2 NUMERICAL values do not exist in Array 1, they are to be added to it.

So, in the end, after comparison, Array 1 should look like this:

Array 1 ( => 7|1|0|5|0|0 [1]  => 7|3|0|5|0|0 [3] => 7|4|0|5|0|0 [4] => 7|5|0|5|0|0 [5] => 7|6|0|5|0|0 [6] => 7|7|0|5|0|0 =>  [7] => 8|1|0|5|0|0 [8] => 7|2|0|5|0|0)

The values 7|3|0|5|0|0 and  7|4|0|5|0|0 from Array 2 have not been added to Array 1 because 7|3... and 7|4... already exist in Array 1.

So far, I've got something like this:


Code: [Select]
$match = 0;
        foreach ($array1 as $data1)
        {
        foreach ($array2 as $data2)
            {
                if ($data1 == $data2)
                {
                    $match = 1;
                    break;
                    }
                }
            if ($match != 1)
            {
                array_push($array1, $data2);
                }
            else
            {$match = 0;}
        }
Where have I gone wrong?

i have an array with 5 numbers...

Code: [Select]
$numbers = array(1 => 4;
                              2 => 26;
                              3 => 15;
                              4 => 36
                              5 => 9);

I need a method  to combine them in sets of three..
For example:
4, 26, 15
4, 26, 36
4, 26, 9
and so on ...
Have ten possible combinations.
Any idea or advice of how i could do this...?

Would there be any feasible way of combining the two Update statement below into one?

The Members Table has id, username, password, and application_id
The Application Table has the application id, the users application information and whether or not the application is approved.


if($_GET['approved']=="update"){
$approved=$_GET['approved'];
$approved=sanitize($approved);
if($approved=="y"){
$id=(int)$_GET['id'];
$username=$_GET['username'];
$username=sanitize($username);
$password=$_GET['password'];
$password=sanitize($password);
$approved_sql='UPDATE members SET username="$username" password="$password" application_id="$id"';
$approved_result=mysql_query($approved_sql);
$approved_rows=mysql_affect_rows();
$update_approved_sql='UPDATE application SET approved="y" WHERE id="$id"';
$update_approved_result=mysql_query($update_approved_sql);
$update_approved_rows=mysql_affect_rows();
if($approved_rows==1 && $update_approved_rows==1{
header("Location: ./index.php??admincp=investors&view=applications&id=1&approved=updated");
}
}
}

I have 3 variables that im still cleaning up but they produce results at least. I have spent a couple days searching how to execute (exec or shell_exec) them in order. The best iv found, this is done like
Code: [Select]
$statementa = 'cd test"' then do this"'
exec=($statementa)
but what i am doing is a bit more complicated

Code: [Select]
$tempFolder = 'C:\\xampp\\htdocs\\remote\\';
$filename7Z = 'C:\\xampp\\7-zip\\7z.exe';
$sessionKey = '12345'

$commandtest1= 'C:\\xampp\\7-zip\\7z.exe a ' .$tempFolder. 'c' .$sessionKey. '.7z C:\\xampp\\htdocs\\remote\\client\\ helpdesk.txt icon1.ico icon2.ico icon3.ico winvnc.exe'; //semi working, copies entire dir
$commandtest2 = 'copy /b C:\\xampp\\htdocs\\remote\\support\\7zS.sfx+ C:\\xmapp\\htdocs\\remote\\client\\config.txt+'.$tempFolder.'c'.$sessionKey.'.7z c'.$sessionKey.'.exe'; //create executable in build directory \\\\not working\\\\\\
$commandtest3 = 'del /F /Q '.$tempFolder.'\\c'.$sessionKey.'.7z'; //remove *.7z from %tmp% directory \\\\\\\\\working\\\\\\\
//session_write_close();

exec($commandtest1);
Where i cant seem to find any guidance is, if i wrap these in " then is looks fine in dreamweaver but produces nothing. I think it may be the variables but i cant be sure.
I tried todo $exec($commandtest1 & $commandtest2) but that didn't help any then i tired ($commandtest1 | $commandtest2) still noting. It seems i can just have three exec so i have to comine into one however i have several breaks where it need todo the first then sencond then third. Please someone point me in the correct direction. I must have read http://php.net/manual/en/function.exec.php at least 6 times and either miss is each time or haven't been able to apply it to my code correctly

$id[] = 12345;
$id[] = 12345;
$id[] = 12345;
$id[] = 12345;
$id[] = 12345;

how would I combine these into a string

"12345,12345,12345,12345,12345"

I have this part of the code:

        for($number_words_loop = 0; $number_words_loop < $number_words; $number_words_loop++) 
       { 
        $value1 .= 'AND a.adtitle RLIKE \'[[:<:]]' . $words[$number_words_loop] . '[[:>:]]\''; 
        $value2 .= 'AND a.addesc RLIKE \'[[:<:]]' . $words[$number_words_loop] . '[[:>:]]\''; 
       } 

And I want to combine $value1 and $value2, so the code should look something like this:

        for($number_words_loop = 0; $number_words_loop < $number_words; $number_words_loop++) 
       { 
        $value .= 'AND a.adtitle RLIKE \'[[:<:]]' . $words[$number_words_loop] . '[[:>:]]\' OR AND a.addesc RLIKE \'[[:<:]]' . $words[$number_words_loop] . '[[:>:]]\''; 
       } 

In the first code, first it checks $value1 and then $value2 one by one, and that way it checks if both of them contain all the words that are put in the search field. What I need is to check if all the words that are put in the search field are contained in the one OR in the another. I want to make it search through both of them at the same time, but I don't know how to put correctly that OR I put in the second example. So any professional help will be appreciated.

Here is an example of what I mean:

If the Ad has this:

Ad Title: nokia phone on sale
Ad Description: brand new, unpacked, with 16gb memory card included.

and if someone searches for nokia sale it will show the ad, because all the search words are contained in the Ad Title. Also, if the search is brand unpacked it will also show the ad, because all the search words are contained in the Ad Description. But, the problem is if someone searches for nokia brand This way, the word nokia is not contained in the Ad Description, and the word brand is not contained in the Ad Title, so the ad will not be shown.

So, I only need a way to put that OR correctly to connect those two values, just like the second code, but in the right way.

Thanks in advance.

Hi all

I have written a bit of code that I need to change from 4 seperate SQL queries into 1 so I can paginate the results. My code is below:

Code: [Select]
<!-- Get Trader premium adverts -->
   
   <?php 
    $gettraderads = mysql_query("SELECT * FROM `trade-adverts` WHERE type = 'premium' AND paid = 1 AND categoryid = 1 AND live = 1 AND approved = 1 AND dateexpired >= '".$todaysdate."' ORDER BY id DESC ");
    $numtraderads = mysql_num_rows($gettraderads);
    while ($showtraderads = mysql_fetch_array($gettraderads)) {
   include('trader-ad-cell.php'); 
    }
   ?>
   
    <!-- Get Trader standard adverts -->
   
   <?php 
    $gettraderads = mysql_query("SELECT * FROM `trade-adverts` WHERE type = 'standard' AND categoryid = 1 AND live = 1 AND approved = 1 AND dateexpired >= '".$todaysdate."' ORDER BY id DESC ");
    $numtraderads = mysql_num_rows($gettraderads);
    while ($showtraderads = mysql_fetch_array($gettraderads)) {
   include('trader-ad-cell.php'); 
    }
   ?>
   
    <!-- Get premium adverts -->
   
    <?php 
    $getads = mysql_query("SELECT * FROM `adverts` WHERE categoryid = 1 AND type = 'premium' AND paid = 1 AND live = 1 AND approved = 1 AND dateexpired >= '".$todaysdate."' ORDER BY id DESC ");
    while ($showads = mysql_fetch_array($getads)) {
    include('ad-cell.php'); 
    }
   ?>
   
    <!-- Get standard adverts -->
   
    <?php 
    $getads = mysql_query("SELECT * FROM `adverts` WHERE categoryid = 1 AND type = 'standard' AND live = 1 AND approved = 1 AND dateexpired >= '".$todaysdate."' ORDER BY id DESC ");
    while ($showads = mysql_fetch_array($getads)) {
     $standarduserid = $showads['userid'];
     $getstandarduserinfo = mysql_query(" SELECT * FROM `users` WHERE id = '".$standarduserid."'");
     $showstandarduserinfo = mysql_fetch_array($getstandarduserinfo);
    include('standard-ad-cell.php'); 
    }
   ?>

Can anyone help me?

Many thanks

Pete

I cant seem to get these two forms to basically work together.....I need this code(a form submit):
Code: [Select]
<?php
// Where the file is going to be placed 
$target_path = "uploads/public/uploads/admin/u1p2l3o4a5d6s789/98437e10ec5605a849c3bd9641494560_/";

/* Add the original filename to our target path.  
Result is "uploads/filename.extension" */
$target_path = $target_path . basename( $_FILES['uploadedfile']['name']); 
if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) {
    echo "The file ".  basename( $_FILES['uploadedfile']['name']). 
    " has been uploaded";
} else{
    echo "There was an error uploading the file, please try again!";
}


?>
with this code:
Code: [Select]
<?php
if(isset($_POST['save']))
{

   $event   = $_POST['event'];
   $startdate = $_POST['startdate'];
   $enddate = $_POST['enddate'];
   $description = $_POST['description'];
      $location = $_POST['location'];
      $month = $_POST['month'];
        $title1 = $_POST['title1'];
        $title2 = $_POST['title2'];
        $title3 = $_POST['title3'];
        $title4 = $_POST['title4'];
        $title5 = $_POST['title5'];
        $title6 = $_POST['title6'];
        $title7 = $_POST['title7'];
        $title8 = $_POST['title8'];
        $date1 = $_POST['date1'];
        $date2 = $_POST['date2'];
        $date3 = $_POST['date3'];
        $date4 = $_POST['date4'];
        $date5 = $_POST['date5'];
        $date6 = $_POST['date6'];
        $date7 = $_POST['date7'];
        $date8 = $_POST['date8'];
        $subevent1 = $_POST['subevent1'];
        $subevent2 = $_POST['subevent2'];
        $subevent3 = $_POST['subevent3'];
        $subevent4 = $_POST['subevent4'];
        $subevent5 = $_POST['subevent5'];
        $subevent6 = $_POST['subevent5'];
        $subevent7 = $_POST['subevent6'];
        $subevent8 = $_POST['subevent7'];
        $price1 = $_POST['price1'];
        $price2 = $_POST['price2'];
        $price3 = $_POST['price3'];
        $price4 = $_POST['price4'];
        $price5 = $_POST['price5'];
        $price6 = $_POST['price6'];
        $price7 = $_POST['price7'];
        $price8 = $_POST['price8'];
        $month2 = $_POST['month2'];
 $month_num = $_POST['month_num'];
        $day = $_POST['day'];
        $year = $_POST['year'];
        $shutoff = $_POST['shutoff'];




   if(!get_magic_quotes_gpc())
   {
      $event   = addslashes($event);
      $startdate = addslashes($startdate);

      $enddate = addslashes($enddate);
   $description = addslashes($description);
    $location = addslashes($location);
    $month = addslashes($month);
$title1 = addslashes($title1);
$title2 = addslashes($title2);
$title3 = addslashes($title3);
$title4 = addslashes($title4);
$title5 = addslashes($title5);
$title6 = addslashes($title6);
$title7 = addslashes($title7);
$title8 = addslashes($title8);
$date1 = addslashes($date1);
$date2 = addslashes($date2);
$date3 = addslashes($date3);
$date4 = addslashes($date4);
$date5 = addslashes($date5);
$date6 = addslashes($date6);
$date7 = addslashes($date7);
$date8 = addslashes($date8);
$subevent1 = addslashes($subevent1);
$subevent2 = addslashes($subevent2);
$subevent3 = addslashes($subevent3);
$subevent4 = addslashes($subevent4);
$subevent5 = addslashes($subevent5);
$subevent6 = addslashes($subevent6);
$subevent7 = addslashes($subevent7);
$subevent8 = addslashes($subevent8);
$price1 = addslashes($price1);
$price2 = addslashes($price2);
$price3 = addslashes($price3);
$price4 = addslashes($price4);
$price5 = addslashes($price5);
$price6 = addslashes($price6);
$price7 = addslashes($price7);
$price8 = addslashes($price8);
$month2 = addslashes($month2);
$month_num = addslashes($month_num);
$year = addslashes($year);
$day = addslashes($day);


   }
   include 'config.php';
   include 'opendb.php';

   $query = "INSERT INTO Registration (event, startdate, enddate, description, location, month, title1, title2, title3, title4, title5, title6, title7, title8, date1, date2, date3, date4, date5, date6, date7, date8, subevent1, subevent2, subevent3, subevent4, subevent5, subevent6, subevent7, subevent8, price1, price2, price3, price4, price5, price6, price7, price8, month2, shutoff)
            VALUES ('$event', '$startdate', '$enddate', '$description', '$location', '$month', '$title1', '$title2', '$title3', '$title4', '$title5', '$title6', '$title7', '$title8', '$date1', '$date2', '$date3', '$date4', '$date5', '$date6', '$date7', '$date8', '$subevent1', '$subevent2', '$subevent3', '$subevent4', '$subevent5', '$subevent6', '$subevent7', '$subevent8', '$price1', '$price2', '$price3', '$price4', '$price5', '$price6', '$price7', '$price8', '$month2', '$shutoff')";
   mysql_query($query) or die('Error, query failed');
   include 'closedb.php';

   
   echo "<pre>".print_r($_POST, true)."</pre>";

}

?>
I tried this:
Code: [Select]
<?php
if(isset($_POST['save']))
{

   $event   = $_POST['event'];
   $startdate = $_POST['startdate'];
   $enddate = $_POST['enddate'];
   $description = $_POST['description'];
      $location = $_POST['location'];
      $month = $_POST['month'];
        $title1 = $_POST['title1'];
        $title2 = $_POST['title2'];
        $title3 = $_POST['title3'];
        $title4 = $_POST['title4'];
        $title5 = $_POST['title5'];
        $title6 = $_POST['title6'];
        $title7 = $_POST['title7'];
        $title8 = $_POST['title8'];
        $date1 = $_POST['date1'];
        $date2 = $_POST['date2'];
        $date3 = $_POST['date3'];
        $date4 = $_POST['date4'];
        $date5 = $_POST['date5'];
        $date6 = $_POST['date6'];
        $date7 = $_POST['date7'];
        $date8 = $_POST['date8'];
        $subevent1 = $_POST['subevent1'];
        $subevent2 = $_POST['subevent2'];
        $subevent3 = $_POST['subevent3'];
        $subevent4 = $_POST['subevent4'];
        $subevent5 = $_POST['subevent5'];
        $subevent6 = $_POST['subevent5'];
        $subevent7 = $_POST['subevent6'];
        $subevent8 = $_POST['subevent7'];
        $price1 = $_POST['price1'];
        $price2 = $_POST['price2'];
        $price3 = $_POST['price3'];
        $price4 = $_POST['price4'];
        $price5 = $_POST['price5'];
        $price6 = $_POST['price6'];
        $price7 = $_POST['price7'];
        $price8 = $_POST['price8'];
        $month2 = $_POST['month2'];
 $month_num = $_POST['month_num'];
        $day = $_POST['day'];
        $year = $_POST['year'];
        $shutoff = $_POST['shutoff'];




   if(!get_magic_quotes_gpc())
   {
      $event   = addslashes($event);
      $startdate = addslashes($startdate);

      $enddate = addslashes($enddate);
   $description = addslashes($description);
    $location = addslashes($location);
    $month = addslashes($month);
$title1 = addslashes($title1);
$title2 = addslashes($title2);
$title3 = addslashes($title3);
$title4 = addslashes($title4);
$title5 = addslashes($title5);
$title6 = addslashes($title6);
$title7 = addslashes($title7);
$title8 = addslashes($title8);
$date1 = addslashes($date1);
$date2 = addslashes($date2);
$date3 = addslashes($date3);
$date4 = addslashes($date4);
$date5 = addslashes($date5);
$date6 = addslashes($date6);
$date7 = addslashes($date7);
$date8 = addslashes($date8);
$subevent1 = addslashes($subevent1);
$subevent2 = addslashes($subevent2);
$subevent3 = addslashes($subevent3);
$subevent4 = addslashes($subevent4);
$subevent5 = addslashes($subevent5);
$subevent6 = addslashes($subevent6);
$subevent7 = addslashes($subevent7);
$subevent8 = addslashes($subevent8);
$price1 = addslashes($price1);
$price2 = addslashes($price2);
$price3 = addslashes($price3);
$price4 = addslashes($price4);
$price5 = addslashes($price5);
$price6 = addslashes($price6);
$price7 = addslashes($price7);
$price8 = addslashes($price8);
$month2 = addslashes($month2);
$month_num = addslashes($month_num);
$year = addslashes($year);
$day = addslashes($day);


   }
   include 'config.php';
   include 'opendb.php';

   $query = "INSERT INTO Registration (event, startdate, enddate, description, location, month, title1, title2, title3, title4, title5, title6, title7, title8, date1, date2, date3, date4, date5, date6, date7, date8, subevent1, subevent2, subevent3, subevent4, subevent5, subevent6, subevent7, subevent8, price1, price2, price3, price4, price5, price6, price7, price8, month2, shutoff)
            VALUES ('$event', '$startdate', '$enddate', '$description', '$location', '$month', '$title1', '$title2', '$title3', '$title4', '$title5', '$title6', '$title7', '$title8', '$date1', '$date2', '$date3', '$date4', '$date5', '$date6', '$date7', '$date8', '$subevent1', '$subevent2', '$subevent3', '$subevent4', '$subevent5', '$subevent6', '$subevent7', '$subevent8', '$price1', '$price2', '$price3', '$price4', '$price5', '$price6', '$price7', '$price8', '$month2', '$shutoff')";
   mysql_query($query) or die('Error, query failed');
   include 'closedb.php';

   
   echo "<pre>".print_r($_POST, true)."</pre>";
 $target_path = "uploads/public/uploads/admin/u1p2l3o4a5d6s789/98437e10ec5605a849c3bd9641494560_/";

/* Add the original filename to our target path.  
Result is "uploads/filename.extension" */
$target_path = $target_path . basename( $_FILES['uploadedfile']['name']); 
if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) {
    echo "The file ".  basename( $_FILES['uploadedfile']['name']). 
    " has been uploaded";
} else{
    echo "There was an error uploading the file, please try again!";
}

}

?>but it didn't work.....

Hello


I have a simple question about file handling...


Is it possible to list all files in directories / subdirectories, and then read ALL files in those dirs,
and put the content of their file into an array?

Like this:

array:
[SomePath/test.php] = "All In this php file is being read by a new smart function!";
[SomePath/Weird/hello.txt = "Hello world. This is me and im just trying to get some help!";

and so on, until no further files exists in that rootdir.

All my attempts went totally crazy and none of them works... therefore i need to ask you for help.


Do you have any ideas how to do this?
If so, how can I be able to do it?


Thanks in Advance, pros

So far I have managed to create an upload process which uploads a picture, updates the database on file location and then tries to upload the db a 2nd time to update the Thumbnails file location (i tried updating the thumbnails location in one go and for some reason this causes failure)

But the main problem is that it doesn't upload some files

Here is my upload.php

<?php
include 'dbconnect.php';

$statusMsg = '';

$Title = $conn -> real_escape_string($_POST['Title']) ; 
$BodyText = $conn -> real_escape_string($_POST['ThreadBody']) ; 
	 

// File upload path
$targetDir = "upload/";
$fileName = basename($_FILES["file"]["name"]);
$targetFilePath = $targetDir . $fileName;
$fileType = pathinfo($targetFilePath,PATHINFO_EXTENSION);
$Thumbnail = "upload/Thumbnails/'$fileName'";

if(isset($_POST["submit"]) && !empty($_FILES["file"]["name"])){
    // Allow certain file formats
    $allowTypes = array('jpg','png','jpeg','gif','pdf', "webm", "mp4");
    if(in_array($fileType, $allowTypes)){

        // Upload file to server
        if(move_uploaded_file($_FILES["file"]["tmp_name"], $targetFilePath)){

            // Insert image file name into database
            $insert = $conn->query("INSERT into Threads (Title, ThreadBody, filename) VALUES ('$Title', '$BodyText', '$fileName')");
            if($insert){
               $statusMsg = "The file ".$fileName. " has been uploaded successfully."; 

		$targetFilePathArg = escapeshellarg($targetFilePath);
		$output=null;
		$retval=null;
		 //exec("convert $targetFilePathArg -resize 300x200 ./upload/Thumbnails/'$fileName'", $output, $retval);
		 exec("convert $targetFilePathArg -resize 200x200 $Thumbnail", $output, $retval);
		echo "REturned with status $retval and output:\n" ; 
		if ($retval == null) { 
		echo "Retval is null\n" ;
		echo "Thumbnail equals $Thumbnail\n" ; 
		}

            }else{
                $statusMsg = "File upload failed, please try again.";
            } 
        }else{
            $statusMsg = "Sorry, there was an error uploading your file.";
        }
    }else{
        $statusMsg = 'Sorry, only JPG, JPEG, PNG, GIF, mp4, webm & PDF files are allowed to upload.';
    }
}else{
    $statusMsg = 'Please select a file to upload.';
}

//Update SQL db by setting the thumbnail column to equal $Thumbnail
$update = $conn->query("update Threads set thumbnail = '$Thumbnail' where filename = '$fileName'");
            if($update){
               $statusMsg = "Updated the thumbnail to sql correctly.";
		echo $statusMsg ;  } 
else 
{ echo "\n Failed to update Thumbnail. Thumbnail equals $Thumbnail" ; } 


// Display status message
echo $statusMsg;
?>

And this does work on most files however it is not working on a 9.9mb png file  which is named "test.png" I tested on another 3.3 mb gif file and that failed too?

For some reason it returns the following

Updated the thumbnail to sql correctly.Updated the thumbnail to sql correctly.

Whereas on the files it works on it returns

REturned with status 0 and output: Retval is null Thumbnail equals upload/Thumbnails/'rainbow-trh-stache.gif' Failed to update Thumbnail. Thumbnail equals upload/Thumbnails/'rainbow-trh-stache.gif'The file rainbow-trh-stache.gif has been uploaded successfully.

Any idea on why this is?

I have a brain twister in a script i'm working on. It have a multidimensional array that hold values to populate a google charts js script. To make it work as I plan I need to merge the data from similar arrays together.

I'll give an example and hopefully it will make more sense. Also, this page is being loaded over ajax so, the faster/smaller the better.

Example Array:
Code: [Select]
Array
(
    [0] => Array
        (
            [item] => 1
            [quant] => 2
            [price] => 12.5
            [day] => 18
            [onl] =>
        )

    [1] => Array
        (
            [item] => 1
            [quant] => 2
            [price] => 12.5
            [day] => 18
            [onl] =>
        )

    [2] => Array
        (
            [item] => 1
            [quant] => 5
            [price] => 12.5
            [day] => 17
            [onl] => 1
        )

    [3] => Array
        (
            [item] => 1
            [quant] => 12
            [price] => 12.5
            [day] => 19
            [onl] => 1
        )

    [4] => Array
        (
            [item] => 1
            [quant] => 4
            [price] => 12.5
            [day] => 21
            [onl] =>
        )

)

So since array 0 and 1 both have data from sales on the 18th for the same item I would want to merge them into a single array and leave all others in the parent array the same.

I apologize in advance if this doesn't make sense, I've been working too many hours. X|

If anyone knows of a good solution for this or perhaps a better approach, that would be great.

Thank  You,

E

$f15 = 0.345677 (output from sql data pull)

<?php echo number_format ($f15,3); ?>
 output = 0.345

<?php echo ltrim($f15,"0"); number_format ($f15,3); ?>
output = .345677

How do I combine these so that I am BOTH rounding the result AND trimming a leading zero?  Seems I can get one or the other, but not both.

Suggestions on the syntax?