PHP - $_session Data Storing Help

hey gang:

i have a number of variables stored in the $_SESSION array and wanted to know how i can keep them handy for use AFTER PayPal has done it's thing.  to help clarify, the desired process here is client fills out form. clicks PayPal button. form data is then used to create some documents which are then sent to client.  i have the flow working but without the PayPal part because i'm not sure how to preserve the form data while PayPal does it's thing so i can use it when PayPal is done.  am i making sense?  i'd like to steer away from client-side cookies because of security issues and our paranoid client insists on it...

bah.  first the JSON shuffle from JavaScript to PHP and now this PayPal mess. 

any help is MOST welcome.  TIA!

WR!

The below should choose the radio button that is set by the $_SESSION variable or default to 3. However, it's defaulting to 1.

Code: [Select]
$content.='
<p class="form_item"><label>Product Rating:</label><br />
<div class="rating_radio"><input type="radio" name="review_product_rating" value="1"';
if(isset($review_product_rating) && $review_product_rating=="1"){$content.='checked';}
$content.=' /> <br />1</div>
<div class="rating_radio"><input type="radio" name="review_product_rating" value="2"';
if(isset($review_product_rating) && $review_product_rating=="2"){$content.='checked';}
$content.=' /> <br />2</div>
<div class="rating_radio"><input type="radio" name="review_product_rating" value="3"';
if(isset($review_product_rating) && $review_product_rating=="3" || !isset($review_product_rating)){$content.='checked';}
$content.=' /> <br />3</div>
<div class="rating_radio"><input type="radio" name="review_product_rating" value="4"';
if(isset($review_product_rating) && $review_product_rating=="4"){$content.='checked';}
$content.=' /> <br />4</div>
<div class="rating_radio"><input type="radio" name="review_product_rating" value="5"';
if(isset($review_product_rating) && $review_product_rating=="5"){$content.='checked';}
$content.=' /> <br />5</div>
<div class="worst">(Worst)</div><div class="best">(Best)</div>
</p>

I'm figuring it's because it's multiple if statement (with no elseif) so it's evaluating the first if and being set to true. I tried changing everything else after the first one to elseif, and it's throwing an unexpected T_ELSEIF error.

This problem happens in both IE9 and Chrome 13.0.782.112 m on Windows

If I close the browser down, my session data is gone on browser restart, if however I just close the tab leaving other tabs say with BBC news and restart my app in a new tab, both browsers remember the old session data.

Since the intended user could do this at any time before completing a transaction, I don't actually get a chance to destroy the session this only happens if they complete payment for their order via..
Code: [Select]
  session_destroy();
  $conn->commit();
  $conn->autocommit(TRUE);

In an attempt to clean up I tried various combinations at the top of the start page "index.php"..

Code: [Select]
  session_start();
//  $_SESSION = array();
  session_destroy($_SESSION['cart']);
  session_destroy($_SESSION['address']);
//  $_SESSION['cart'] = array();
//  $_SESSION['address'] = array();
//  session_destroy();

Can anyone please shed any light on this behaviour difference?

Jamie

Im making a application but many users can access it at the same time, also the data that needs to be stored into the database in 3 parts firstly the user will enter some details the comany will fill out the reamining details and the user will then accept or decline the companies proposal. The issue im havign will it be easier to just store all of this information into session variables and then save them into the database at the end when all of the details are ready ?

Thank You

Can anyone tell me whats wrong with this:

The file uploads fine, the url however does not get posted to the database?
I added a 'or die' but it didn't execute...Do I need to move the query higher up the script?

<?php
include ('base.php');
$id = $_GET['id'];

if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 20000))
  {
  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"],
      "imgs/pictures/" . $_FILES["file"]["name"]);
      echo "Stored in: " . "upload/" . $_FILES["file"]["name"];
      }
    }
  }
else
  {
  echo "Invalid file";
  }
$file = $_FILES["file"]["name"];
 $sql = "UPDATE `chillp_security`.`staff` SET `picture` = \'imgs/pictures/$file\' WHERE `staff`.`id` = $id;";
?>

Hi,

I have a XHTML/PHP page that loads a PHP file each couple of seconds for building up the page. The PHP file should retreive data that keeps changing.

What would be the best way to store and retreive the data? Obviously i can do this with a database but that will put a lot of stress on the server as each user keeps polling the database. So i was looking into other methods of doing this.

I have tried doing this with a plain text file and CSV files using fwrite to put the initial data into a file with separators. Then retrieving that file and explode it into a multidimensional array again. I am unsuccessful here to assign the key values to the new array. I have also tried many snippets for this but these where also not working properly for me.

Maybe XML is the key, i didn't really delve into it yet but it seems i have to get extra programs or parser to actually write and change files? But then again i can't find any working tutorials on how to put multi dimensional strings back and forth between PHP and XML.

So what needs exactly to be done. Well i'm creating a game where you can fight each other with 4 units on a turn base. The units have a speed stat that determines when it's there turn to act. Like if (unit 1) has 3 speed and (unit 2) 5 speed they will move like this on the time line (unit 1) -> (unit 2) -> (unit 1) -> (unit 1) -> (unit 2). So the plan is each time the user acts with a unit to increment it's speed by the base value. A script will run each time picking up the next unit in line.

The PHP page does a check on which player the unit belongs to and if that matches the players ID it will sent the necessary information. The other player will get something like "not your turn".

Tx,

I want to store a series of data which are called in a main php file. Do you suggest to store them in xml as

file1.xml:
<title>TITLE</title>
<content>CONTENT</content>

or
file1.php:
$title="TITLE";
$content="CONTENT";


AND is it better to create separate file for each article or storing all data in one single file?

Here is my code...

Code: [Select]
<?php
mysql_connect("localhost", "user", "pass")or die("cannot connect"); 
mysql_select_db("database")or die("cannot select DB");
 
$myemail = mysql_real_escape_string($_POST['myemail']);  
$mypassword = mysql_real_escape_string($_POST['mypassword']); 
$mypassword = md5($mypassword);

$myemail = stripslashes($myemail);
$mypassword = stripslashes($mypassword);

$sql="SELECT * FROM users WHERE email='$myemail' and password='$mypassword'";
$result=mysql_query($sql);

$count=mysql_num_rows($result);

if($count==1){
session_start();  
$_SESSION["myemail"]= "$myemail"; 
header("location:home.php");
}
else {
header("location:fail.php");
}
?>
What can I do to this code so that it will also store first name from the database inside a session?

First let me explain my code.
It comprises of three php files.

inc_fn_header_and_menu.php,  contains the HTML and CSS header details and it initializes the session via session_start();

 

This  is later included in project_status.php] .

 

In project_status.php] , I have included another file project_status_app.php which contains a HTML form.

 project_status.php:

<?php
 include 'inc_fn_header_and_menu.php';
function includeFile($file,$variable) {
    $var = $variable;
    include($file);
}
if (isset($_GET['id']) && $_GET['id']!="") {
    $pid    = $_GET['id'];
    $_SESSION['pidForApproval'] = $_GET['id'];
    $query = 'SELECT * FROM `profile` WHERE pid ='.'\''.$pid.'\'';
    $result=mysqli_query($db,$queryToRetrievePP) or die("There are no records to display ... \n" . mysqli_error());
    foreach ($result as $row) {
        $status = $row['status'];
    }        
}
...........some PHP and HTML code.......
	<div id="customerPurchaseApprovalForm">
<?php  
  echo '<p>APPROVAL FOR CUSTOMER PURCHASE</p>';
  $discountApprovalStatus = "Granted";
  if ($discountApprovalStatus == "Granted") {  
 
  includeFile("project_status_app.php",$highestannualvalue);
  } else {
     //.........
  }

In project_status_app.php I am attempting to retrieve pidForApproval from the $_SESSION array.

<?php
        // put your code here  UPDATE `pp` SET `customer_purchase_remarks` = 'hahaha' WHERE `pp`.`id` = 207;
        
        if ($_SERVER['REQUEST_METHOD'] == 'POST') {
            include '../../inc/fastlogin.php';      
            $sql = "UPDATE pp SET customer_purchase_remarks ='{$_POST['remarkstxt']}' WHERE pp.pid='{$_SESSION['pidForApproval']}'"; 
            $result = mysqli_query ( $fastdb, $sql ) ;
            if (mysqli_affected_rows($fastdb) != 1) { 
               $_SESSION['err_cpa_rmks'] = "<p>Error while updating WHERE id='{$_SESSION['pidForApproval']}'</p>";
                //echo "<p>Error while updating WHERE id='{$_POST['pidForApproval']}'</p>".mysqli_error($fastdb);                 
            } else { 
                $_SESSION['suc_cpa_rmks'] = "<p>Records was updated successfully.</p>";
                //echo "Records was updated successfully."; 
            }
            header ("location: project_status.php?id="$_SESSION['pidForApproval']);
            exit();
        }    
        
        ?>

When I load  project_status.php,  project_status_app.php is supposed to display the form. Once the user fills in the form the and the submit button has been pressed, the UPDATE statement is supposed to run and then it is supposed to navigate back to project_status.php?id=FA142. But the update is failing and the when the project_status.php is loaded back, the url looks like this http://localhost/fast/project_status.php?id= . The id is empty. It is supposed to be something like this http://localhost/fast/project_status.php?id=FA142. With the id being populated at the 

header ("location: project_status.php?id=".$_SESSION['pidForApproval']);

I suspected that my $_SESSION['pidForApproval'] is not being populated in project_status.php but I echoed back $_SESSION['pidForApproval'] in that file itself and I can see it is being populated. Hence, I suspect that the $_SESSION['pidForApproval'] is not being passed to project_status_app.php. I have already attempted to include session_start(); clause in project_status_app.php but that gives an error, stating that the session has already started, in inc_fn_header_and_menu.php. Can someone help me as to why the $_SESSION['pidForApproval'] is not being passed on to the project_status_app.php file. Thank you.

Edited August 9, 2020 by Robinson
Missing some information.

hi everyone,

i just signed up on this forum. I have issue, my clients wants to save time by copying data into a textarea and then letting the script process it and store it in database.

the problem is never done that. the data is made up for eg.

Title   Mr
Name   Radio86
Address  Chiltren House
etc....

how do i split this data up and store it in database, btw ive just started programming in php in other words newbie

Please help me, thanks in advance

To me it is logical to store config data such as site name, meta, etc in a php file rather than storing ina  table in mysql database. This will reduce the number of calls to the mysql database, as these are key parameters and needed in every page.

But, a well-developed CMS like Wordpress uses a mysql table to store such basic data. What is your idea? Ain't it better to reduce mysql loads?

Hi all

I have a question about how to store parsed data into a multidimensional arrays -- I can store items into an array, but multidimensional arrays mystify me a bit.  Any help would be greatly appreciated. 

I'm storing the images in a table, grouped according to their table and their descriptions, so that later when I call the images, I can display them accordingly. I'm using the Simple HTML DOM Parser.  So say I have two tables, one with three images, and another with one.  I'd like the resulting to array to look like:

Code: [Select]
Array
(
    [0] => Array
        (
            [0] => image1.jpg
            [1] => 1st Variation Description
        )

    [1] => Array
        (
            [0] => image2.jpg
            [1] => image3.jpg
            [2] => image4.jpg
            [3] => 2nd Variation Description
        )

)

This is what I have so far:
Code: [Select]
$html = str_get_html($vartables);   
$varinfo = array();
foreach($html->find('table') as $table){
        $varinfo[] = $table->innertext;
}
print_r($varinfo);

Which yields:

Code: [Select]
Array
(
    [0] =>
 <tr>
  <td width=150>
Description1
 </td>

 <td><a href="image1.jpg">
<img src="image1" height=100 border=1></a>
  </td>
 </tr>

    [1] =>
 <tr>
  <td width=150>
Description2
  </td>

<td><a href="image2.jpg">
<img src="image2.jpg" height=200 border=1></a>
  </td>
  <td><a href="image3.jpg">
<img src="image3.jpg" height=200 border=1></a>

  </td>
 <td><a href="image4.jpg">
<img src="image4.jpg" height=200 border=1></a>
  </td>
 </tr>

)

I'd like to strip out the html and keep the .jpg's and descriptions together in a multidimensional array...unfortunately my newbness is getting the better of me there, I'm researching but running into a roadblock.  Thanks in advance for any help.

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 am having some problems with part of the code. What is going on is a user registers info with a form and is sent an email with a confirmation link. The info that was in a temp DB table is moved to a member table. All of this works fine, but I am trying to be able to store an ID and username associated with their passkey info and echo that variable out. This part I am having trouble with. Code is here.


<?
session_start();
include('config.php');

// Passkey t from link
$passkey=$_GET['passkey'];

$tbl_name1="Profile_temp";

// Retrieve data from table where row matches passkey
$sql1="SELECT * FROM $tbl_name1 WHERE confirm_code ='$passkey'";
$result1=mysql_query($sql1);


// If successfully queried
if($result1){

// Count how many row has this passkey
$count=mysql_num_rows($result1);

// if passkey is found retrieve info from temporary DB
if($count==1){

$rows=mysql_fetch_array($result1);
$FirstName=$rows['FirstName'];
$LastName=$rows['LastName'];
$UserName=$rows['UserName'];
$Password= md5($rows['Password']);
$Password2=md5($rows['Password2']);
$email=$rows['email'];
$Zip=$rows['Zip'];
$Birthday=$rows['Birthday'];
$Security=$rows['Security'];
$Security2=$rows['Security2'];

$tbl_name2="Profile";

// Insert data that retrieves from "temp_members_db" into table "registered_members"
$sql2="INSERT INTO $tbl_name2(`FirstName`,`LastName`,`Username`,`Password`,`Password2`,`email`,`Zip`,`Birthday`,`Security`,`Security2`) VALUES ('$FirstName','$LastName','$UserName','$Password','$Password2','$email','$Zip','$Birthday','$Security','$Security2')"; 
//echo $sql2;
$result2=mysql_query($sql2);
}

// if passkey is not found, display message "Wrong Confirmation code"
else {
echo "<h2>Sorry, Your passkey was not found.</h2>";
}
while ($row = mysql_fetch_assoc($result2)) {
    $_SESSION['id'] = $row['id'];
$_SESSION['UserName']=$user_name; 
}

// if successfully moved data from table"temp_members_db" to table "registered_members" displays message "Your account has been activated" and don't forget to delete confirmation code from table "temp_members_db"
if($result2){

echo "<h2>Your account has been activated,  </h2>";
echo "$user_name"; 
echo"<p>You may now upload a profile picture</p>";

// Delete information of this user from table "temp_members_db" that has this passkey
$sql3="DELETE FROM $tbl_name1 WHERE confirm_code = '$passkey'";
$result3=mysql_query($sql3);

}

}
?>


getting an error for this part

while ($row = mysql_fetch_assoc($result2)) {
    $_SESSION['id'] = $row['id'];
$_SESSION['UserName']=$user_name; 
}


the error is "Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in confirmation.php on line 62"

Hello,   I have a table with these columns (database)    table.JPG   34.95KB   0 downloads   and i have a static form through which user define the installments. Static 24 input boxes are there like this

 <form name="installment"  method="post" action="" enctype="multipart/form-data" onsubmit="return validate()">
                                <table id="dt_hScroll" class="table table-striped">
                            <thead>
                                <tr>

<th>SL No.</th>
<th>Amount</th>
<th>Due Date</th>
</tr>
<tr>
<td> 1. </td>
<td>

<input type="text" name="installment1" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date1" class="tcal span4" value="<?php //echo date("Y-m-d"); ?>" />
</td>


</tr>

<tr>
<td> 2. </td>

<td>

<input type="text" name="installment2" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date2" class="tcal span4" />
</td>
</tr>


<tr>
<td> 3. </td>

<td>

<input type="text" name="installment3" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date3" class="tcal span4" />
</td></tr>


<tr>
<td> 4. </td>

<td>

<input type="text" name="installment4" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date4" class="tcal span4" />
</td></tr>


<tr>
<td> 5. </td>

<td>

<input type="text" name="installment5" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date5" class="tcal span4" />
</td></tr>

<tr>
<td> 6. </td>

<td>

<input type="text" name="installment6" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date6" class="tcal span4" />
</td></tr>


<tr>
<td> 7. </td>

<td>

<input type="text" name="installment7" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date7" class="tcal span4" />
</td></tr>

<tr>
<td> 8. </td>

<td>

<input type="text" name="installment8" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date8" class="tcal span4" />
</td></tr>

<tr>
<td> 9. </td>

<td>

<input type="text" name="installment9" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date9" class="tcal span4" />
</td></tr>

<tr>
<td> 10. </td>

<td>

<input type="text" name="installment10" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date10" class="tcal span4" />
</td></tr>

<tr>
<td> 11. </td>

<td>

<input type="text" name="installment11" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date11" class="tcal span4" />
</td></tr>

<tr>
<td> 12. </td>

<td>

<input type="text" name="installment12" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date12" class="tcal span4" />
</td></tr>

<tr>
<td> 13. </td>

<td>

<input type="text" name="installment13" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date13" class="tcal span4" />
</td></tr>

<tr>
<td> 14. </td>

<td>

<input type="text" name="installment14" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date14" class="tcal span4" />
</td></tr>

<tr>
<td> 15. </td>

<td>

<input type="text" name="installment15" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date15" class="tcal span4" />
</td></tr>

<tr>
<td> 16. </td>

<td>

<input type="text" name="installment16" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date16" class="tcal span4" />
</td></tr>


<tr>
<td> 17. </td>

<td>

<input type="text" name="installment17" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date17" class="tcal span4" />
</td></tr>


<tr>
<td> 18. </td>

<td>

<input type="text" name="installment18" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date18" class="tcal span4" />
</td></tr>

<tr>
<td> 19. </td>

<td>

<input type="text" name="installment19" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date19" class="tcal span4" />
</td></tr>

<tr>
<td> 20. </td>

<td>

<input type="text" name="installment20" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date20" class="tcal span4" />
</td></tr>

<tr>
<td> 21. </td>

<td>

<input type="text" name="installment21" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date21" class="tcal span4" />
</td></tr>

<tr>
<td> 22. </td>

<td>

<input type="text" name="installment22" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date22" class="tcal span4" />
</td></tr>

<tr>
<td>23. </td>

<td>

<input type="text" name="installment23" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date23" class="tcal span4" />
</td></tr>

<tr>
<td> 24. </td>

<td>

<input type="text" name="installment24" id="installment" class="span4" value="0" />
</td>
<td>

<input type="text" name="due_date24" class="tcal span4" />
</td></tr>

<tr><td></td><td>

<input type="submit"  name="save" id="save" value="Save" class="btn btn-info span3"   />
<input type="hidden" readonly="readonly" name="roll_no" value="<?php echo $roll_no; ?>" class="span5" />

</td><td></td></tr>


</thead>
</table>
</form>

Here i am not getting how to store it in that table. Actually all the 24 inputs are not mandatory. If user fills only 2 then also it should store it in the database table.    I tried to do like this

if(isset($_POST['save']))
{
$roll_no = 	$_POST['roll_no'];
$ins_amt1 = $_POST['installment1'];
$due_date1 = $_POST['due_date1'];
$ins_amt2 = $_POST['installment2'];
$due_date2 = $_POST['due_date2'];
$ins_amt3 = $_POST['installment3'];
$due_date3 = $_POST['due_date3'];
$ins_amt4 = $_POST['installment4'];
$due_date4 = $_POST['due_date4'];
$ins_amt5 = $_POST['installment5'];
$due_date5 = $_POST['due_date5'];
$ins_amt6 = $_POST['installment6'];
$due_date6 = $_POST['due_date6'];
$ins_amt7 = $_POST['installment7'];
$due_date7 = $_POST['due_date7'];
$ins_amt8 = $_POST['installment8'];
$due_date8 = $_POST['due_date8'];
$ins_amt9 = $_POST['installment9'];
$due_date9 = $_POST['due_date9'];
$ins_amt10 = $_POST['installment10'];
$due_date10 = $_POST['due_date10'];
$ins_amt11 = $_POST['installment11'];
$due_date11 = $_POST['due_date11'];
$ins_amt12 = $_POST['installment12'];
$due_date12 = $_POST['due_date12'];
$ins_amt13 = $_POST['installment13'];
$due_date13 = $_POST['due_date13'];
$ins_amt14 = $_POST['installment14'];
$due_date14 = $_POST['due_date14'];
$ins_amt15 = $_POST['installment15'];
$due_date15 = $_POST['due_date15'];
$ins_amt16 = $_POST['installment16'];
$due_date16 = $_POST['due_date16'];
$ins_amt17 = $_POST['installment17'];
$due_date17 = $_POST['due_date17'];
$ins_amt18 = $_POST['installment18'];
$due_date18 = $_POST['due_date18'];
$ins_amt19 = $_POST['installment19'];
$due_date19 = $_POST['due_date19'];
$ins_amt20 = $_POST['installment20'];
$due_date20 = $_POST['due_date20'];
$ins_amt21 = $_POST['installment21'];
$due_date21 = $_POST['due_date21'];
$ins_amt22 = $_POST['installment22'];
$due_date22 = $_POST['due_date22'];
$ins_amt23 = $_POST['installment23'];
$due_date23 = $_POST['due_date23'];
$ins_amt24 = $_POST['installment24'];
$due_date24 = $_POST['due_date24'];
$items = array();
$installment[] =array($ins_amt1, $ins_amt2, $ins_amt3, $ins_amt4, $ins_amt5, $ins_amt6, $ins_amt7, $ins_amt8, $ins_amt9, $ins_amt10, $ins_amt11, $ins_amt12, $ins_amt13, $ins_amt14, $ins_amt15, $ins_amt16, $ins_amt17, $ins_amt18, $ins_amt19, $ins_amt20, $ins_amt21, $ins_amt22, $ins_amt23, $ins_amt24);

//$in_values= serialize($installment);


$due_date[] = array($due_date1, $due_date2, $due_date3, $due_date4, $due_date5, $due_date6, $due_date7, $due_date8, $due_date9, $due_date10, $due_date11, $due_date12, $due_date13, $due_date14, $due_date15, $due_date16, $due_date17, $due_date18, $due_date19, $due_date20, $due_date21, $due_date22, $due_date23, $due_date24);
//$in_dates= serialize($due_date);
//$s1 = "insert into installment(id, fee_id, student_id, amount, due_date, paid_date, status, rec_no) values ('', ".$fee_id.", '".$roll_no."', ".$in_values.", '".$in_dates."', '', 'unpaid', ''";

foreach($installment as $row_key => $value)
{
    $item  = $value;
	$uom = $due_date[$row_key];
	
$items[] = sprintf("(%d, %d, '%s', %d, '%s', '%s', '%s', '%s')", '',
                                                                           $fee_id,
																		   mysql_real_escape_string($roll_no),  
                                                                           intval($item),
																		   $uom,
																		   '',
                                                                           '', 
                                                                           ''
																		   );
}


$msql = 'INSERT INTO installment (id, fee_id, student_id, amount, due_date, paid_date, status, rec_no) VALUES '.implode(', ', $items);

But it is taking only one data. Can somebody please suggest. The data has to be saved like this  saveddata.JPG   70.92KB   0 downloads   Somebody please help. Thank you