PHP - Moved: Use A Temporary Table?

I have this interesting problem, I think I know how to do it.   In a java class I took there was a lab on swapping the values of variables and if there were two variables, you needed a third temporary value holder.   So this project I'm working on has a row output, currently the individual values are outputted as a concatenated string but ideally they would be independent rows with accompanying buttons.   One of those buttons is a ^ symbol, when you press this, ideally the row is moved up in ID putting the previous ID in front or ahead.   The problem is that the ID's / rows are not necessarily in sequential order.   So, when I recall a set of rows that have random sequential values for example, 2, 5, 27, 41, 43   and those are outputted by themselves, now becoming 0,1,2,3,4 respectively or 1,2,3,4,5   So when I try to move 43 to position 2, that's 4 positions away or 4 clicks of the ^ button.   Now how do you deal with that 4 difference and the difference of 41... ? thereby, when the initial set of rows are recalled again, the order is now, 43, 5, 27, 41, 2 Of course the ID I think remains the same but the data is switched... ? yeah I have to draw some pictures, but this isn't a current problem to fix, later on down the road after I update the interface.   here is a drawing to explain, I'm more of a visual person    wp_20150112_05_27_16_pro.jpg   59.67KB   0 downloads   Any ideas would be appreciated, otherwise I will post my solution when I come to it. Or I don't figure it out and find one. thanks

I'm modifying a script I built a few months ago to allow someone to upload an attachment via a form and then email it off. It is expected that this form will receive a lot of hits and so it won't be possible to store the attachment in a folder before emailing it out (right away).

Problem: If I skip the move_uploaded_file part, and just attach the tmp_name the tmp_name is how I receive it rather than the PDF that it actually is.

How can i change the documents name before sending it off, without saving it to a general location. My worry with saving it is, someone uploads their copy and at the exact moment it's supposed to email off, someone somewhere else uploads theirs and it overwrites the first persons and then the email gets sent with the newest persons data.

index.php
Code: [Select]
<form action="process.php" method="post" enctype="multipart/form-data">
<label for="file">Filename:</label>
<input type="file" name="file" />
<br />
<input type="submit" name="submit" value="Submit" />
</form>

process.php
Code: [Select]
<?php
print_r($_FILES);
if ($_FILES["file"]["type"] == "text/plain") {
if ($_FILES["file"]["error"] > 0) {
echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
} else {
echo "Upload: " . $_FILES["file"]["name"] . "<br />";
echo "Type: " . $_FILES["file"]["type"] . "<br />";
echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";

if (file_exists("upload/" . $_FILES["file"]["name"])) {
echo $_FILES["file"]["name"] . " already exists. ";
} else {
move_uploaded_file($_FILES["file"]["tmp_name"],
"upload/" . $_FILES["file"]["name"]);
echo "Stored in: " . "upload/" . $_FILES["file"]["name"];
}
}
} else {
echo "Invalid file";
}
?>

Ok here is what i got so far and now I am stuck.  The user enters a number of how many squares (rectangles is note accurate) they wish to calculate.  If its between 1 and 100 it continues, if its any other number it tells you to put in a number between 1 and 100.  That was easy for me to do.

If the number is between 1 and 100 it creates and input for length, width and height of each rectangle. creating the variables as it goes, i.e. "length$i" when $i is the while counter and increases to the ammount of rectangles you wished to view.  Again, not that hard for me.

 So I am at the point where is I put in 50 I get length1 - through length30, width1 - width50, and height1 - height50.  THis works great.  However I now what to store those variables and calculate the area of each one via a while look which again creates an area$i variable which can be added (it would create area1 - area50 which I then wish to add together)

Here is what I have so far.

<?php
session_start();  


if (isset($_REQUEST['numpack'])) {
    if ($_REQUEST['numpack'] <= 0 || $_REQUEST['numpack'] > 100 ) {
    $error = "Please enter a number between 1 and 100";    
    echo $error;

?>
<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
<table width="0" border="0" cellspacing="5" cellpadding="5">
  <tr>
    <td colspan="2">How many Squares</td>
    </tr>
  <tr>
    <td>
      <input name="numpack" type="text"  size="4" maxlength="3"></td>
    <td><input type="submit" name="button" id="button" value="Submit"></td>
  </tr>
</table>
</form>
<?php
} else {
?>
<form name="form2" method="post" action="<?php $_SERVER['PHP_SELF']; ?>">
<?php   
   
   
   
   $i=1;
   while($i<=ceil($_REQUEST['numpack']))
  {
  ?>
  <table width="325" border="0" cellspacing="5" cellpadding="5" style="float: left;" class="aluminium">
  <tr>
    <td align="center" rowspan="2"><span class="transparent" style="color: #FFF; font-weight: bold;"><?=$i; ?>.</span></td>
    <td align="center">L</td>
    <td align="center">x</td>
    <td align="center">W</td>
    <td align="center">x</td>
    <td align="center">H</td>
  </tr>
  <tr>
    <td align="center"><input name="length<?=$i; ?>" type="text"  size="4" maxlength="3"></td>
    <td align="center">x</td>
    <td align="center"><input name="width<?=$i; ?>" type="text" size="4" maxlength="3"></td>
    <td align="center">x</td>
    <td align="center"><input name="height<?=$i; ?>" type="text"  size="4" maxlength="3"></td>
  </tr>
</table>
    <?php
  $i++;
  }
?>


</form>
<?php   
   
}
}
If (!isset($_REQUEST['numpack'])) {
?>
<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
<table width="0" border="0" cellspacing="5" cellpadding="5">
  <tr>
    <td colspan="2">How many Squares</td>
    </tr>
  <tr>
    <td>
      <input name="numpack" type="text"  size="4" maxlength="3"></td>
    <td><input type="submit" name="button" id="button" value="Submit"></td>
  </tr>
</table>
</form>    
<?php    
}
?>

Now I was reading up on session data and think this might be the best way to go, but again how do I do this? and two I want to make sure that if there are 2 people accessing it at the same time, it does not change the variables on them... (i.e. user one puts in 50 values, and user two puts in 50 different values I do not want cross contamination)

Any ideas on how to proceed?

Hello folks, well what I mean by temporary variables are variables like error messages or success messages that appear after a form has been submitted.  I want to be able to kill these variables when the page is refreshed and return the page to its defualt state.  For example, I'm making this simple page which is basically a form that ask users for some information, then upon submit, stores the  in a database and prints a success message.  If the form is filled out incorrectly or some form fields are left blank, then error messages are printed. What I really want is for these messages to disappear when the page is refreshed.  My current model uses a second page to handle the form, and then upon succes or upon encountering an error, redirects to the form page, passing the error or success variables via the url to the form page where they are printed out.  What can I do differently to achieve what I want (ie kill variables upon page refresh)? Below are the form page, and the page that handles the form respectively.

Code: [Select]

<form method="post" action="send_email.php">


<div id="contact_form">


<div align="left" class="green18">Contact Us</div> <br/> <br/>


<label>Your Name:</label> <input class="texta" name ="name" size="20"      maxlength="49"/> <br/> <br/>

<div class ="error" style="position:relative;bottom:40px;left:128px" >

<?php //Retrieve the encoded errors string from send_email.php page

$errors_string=$_GET['errors_string'];

//Explode the decoded errors string back to an array.
                
$errors = explode(",", $errors_string);
echo $errors[0];?>

</div>

<label>Your Company Name:</label> <input class="texta" name ="company" size="30" maxlength="66"/> <br/> <br/>


<div class ="error" style="position:relative;bottom:40px;left:128px" >

<?php //Retrieve the encoded errors string from send_email.php page

$errors_string=$_GET['errors_string'];

//Explode the decoded errors string back to an array.
                
$errors = explode(",", $errors_string);
echo $errors[1];?>

</div>

<label>Subject(Optional):</label> <input class="texta" name ="subject" size="20" maxlength="49"/>  <br/> <br/>


<label>Email:</label> <input class="texta" name ="email" size="20" maxlength="49"/>  <br/> <br/>


<div class ="error" style="position:relative;bottom:40px;left:128px" >

<?php //Retrieve the encoded errors string from send_email.php page

$errors_string=$_GET['errors_string'];

//Explode the decoded errors string back to an array.
                
$errors = explode(",", $errors_string);
echo $errors[2];?>

</div>


<label>Message:</label> <textarea style="float:left" class="" name ="message" cols="40" rows="3"> </textarea> <br/> <br/>

<div class ="error" style="position:relative;bottom:-19px;left:-260px" >

<?php //Retrieve the encoded errors string from send_email.php page

$errors_string=$_GET['errors_string'];

//Explode the decoded errors string back to an array.
                
$errors = explode(",", $errors_string);
echo $errors[3];?>

</div>


<button class="button" type ="submit" name ="submit">Submit</button> <br/>

<div id ="sent" >

<?php //Retrieve the user id from send_email.php page

$sent=$_GET['sent'];

$send_msg = urldecode($sent);  echo $send_msg;  ?>

</div> <!--closes sent-->


</div>


</form>
 




Code: [Select]


<?php


//address error handling

ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);




if (isset($_POST['submit'])) {
 
    $errors = array();


// Connect to the database.

        require('config/config.php');


//Check for errors.


//Check to make sure they entered their name and it's of the right format.

if (eregi ("^([[:alpha:]]|-|')+$", $_POST['name'])) {

        $a = TRUE;

    } else {

        $a = FALSE;

        $errors[0] = '*Please enter a valid name.';


   }



//Check to make sure they entered their company name.

if (!empty ( $_POST['company'])) {

        $b = TRUE;

    } else {

        $b = FALSE;

        $errors[1] = '*Please enter company name.';


   }



//Check to make sure email is valid.

if(eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $_POST['email'])) { 
 

         $c = TRUE; 


}else { 

         $c = FALSE;

      $errors[2] = '*Please enter a valid email address.'; 

      } 




//Check to make sure they entered their message.

if (!empty ( $_POST['message'])) {

        $d = TRUE;

    } else {

        $d = FALSE;

        $errors[3] = '*Please enter your message.';


   }




 

//If no errors

if (empty($errors)) {

//Create variables for all the post values.

 $name = $_POST['name'];

 $company = $_POST['company'];

 $email = $_POST['email'];

 $message = $_POST['message'];

 $ip = $_SERVER[REMOTE_ADDR];

 $date = (date("Y/m/d:G:i:s"));

 $timestamp = ( mktime(date(H), date(i), date(s), date(m) , date(d) , date(Y)));


//Formulate the insert query.

        $query = "INSERT INTO emails ( email_id, name, company, email, message, ip, date,timestamp) VALUES ( 0, '$name','$company','email', '$message', '$ip' , '$date', '$timestamp' )";
       
        $result = mysql_query($query) or die("Data could not be inserted into table because: " .mysql_error());



if (mysql_affected_rows() == 1) {

    
         // Display success message


          $sent_msg =     "Your email has been sent.  We will get back to you shortly.";

$sent = urlencode($sent_msg);  


         // Display contact page

header("Location: contact_page.php?sent=$sent");  exit();

}else{die("There was a problem: " . mysql_error());}
            


//Display error messages.


} else {// if errors array is not empty

//Confer the errors array into a string

$errors_string = implode(",", $errors);

//Encode the imploded string.

$error_message = urlencode($errors_string);


         // Display page

header("Location: contact_page.php?errors_string=$errors_string");  exit();


        
    }//End of if there are errors.


}//End of if submit.




?>



Also, another problem I just noticed is that, the errors[3] variable isn't getting passed back to the form page.  I don't know if it's because the url can only pass so much info to a second page. The page in question can be located he

http://creativewizz.com/contact_page.php

Bear with me, as I'm still quite new at PHP.

I'm trying to figure out the best way to build a search function for a database that will eventually be quite large.

The path of the search I'm building is to go from a straight-forward javascript and html search page, to a paginated search result. Then the user can narrow down those query results based on a new search of their results.

In trying to get the pagination to work across several pages(unsuccessfuly, I might add), I've been learning about sessions and temporary tables. But, because the database will be very large, I'm wondering if they are the wrong way. Sessions have a time limit, and temporary tables delete once the connection is closed.

Is it possible/feasible to build a permanent table that puts in the search variables, with a unique id and use this to manage the searches, pagination and all that? Then, at some point in the process, I can put code to delete the corresponding row (or even make it a saveable search). Maybe somebody sees where I'm going with this and  can describe it better than me? I'm just thinking off the cuff at the moment. Maybe there's some terminology that will help me find a tutorial. Any bit helps.
thanks!

This topic has been moved to MySQL Help.

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

This topic has been moved to HTML Help.

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

This topic has been moved to MySQL Help.

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

This topic has been moved to JavaScript Help.

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

This topic has been moved to Third Party PHP Scripts.

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

This topic has been moved to MySQL Help.

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

This topic has been moved to MySQL Help.

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

This topic has been moved to MySQL Help.

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

This topic has been moved to MySQL Help.

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

This topic has been moved to MySQL Help.

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