PHP - Static Variable

I write for example class Text:


class Text {
    public static function test() {
        return 'test text';
    }
}


Today I found this code:


class Text {
     
      /** 
       * Protected constructor since this is a static class.
       *
       * @access  protected
       */  
    protected function __construct(){
        // Nothing here
    }

    public static function test() {
        return 'test text';
    }
}


How much appropriate is to write this?


    /** 
       * Protected constructor since this is a static class.
       *
       * @access  protected
       */  
    protected function __construct(){
        // Nothing here
    }

I'm looking for some advice on the best way to achieve the following...

I'd like to change the way URLs are shown for our search results pages.

The website is a holiday rental website and currently the URLs look like this:

domain.co.uk/search?region=[value]&type=[value]&budget_low=[value]&budget_high=[value]&name=[value]&size=[value]

Ultimately I'd like them to look more like this:

domain.co.uk/region-value/type-value/budget_low-value/budget_high-value/name-value/size-value.

Any advice would be greatly appreciated.

I have the following static method:
public static function query($query){
self::$num_queries++;
return mysql_query($query)or die(mysql_error());
}

I then call it like this:
$oql = Mysql::query("SELECT first FROM members WHERE member_id = '{$this->owner}'");
$rql = mysql_fetch_assoc($oql);

I then get the following error:
Quote

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /incl/php/classes/Photo.php on line 13


Why am I getting this error?

Hey guys, this is just a general question.

I read about late static binding and started developing with it on my local server but I noticed that hostgator still runs on 5.2..

Should I use late static binding? (im planning to code an open source CMS)

I removed the last half of the file, but what makes the login($username, $password) function not static? I want to access it statically, but I am getting an error. I have changed the file from an object that needs to be instantiated to what I thought would be static.

Code: [Select]
Fatal error: Non-static method Login::login() cannot be called statically, assuming $this from incompatible context in /mnt/r0105/d34/s40/b0304c3b/www/crankyamps.com/include/uploads/pages/login.php on line 25
Line 25.
Code: [Select]
Login::login($username, $password);

<?php
/**
 * Logs Users into the Website
 *
 * @author    Max Udaskin <max.udaskin@gmail.com>
 * @copyright 2008/2010 Max Udaskin
 * @license   http://www.opensource.org/licenses/lgpl-license.php LGPL
 * @version   $Id: login.php 2010-07-08
 * @package   users
 */

/**
 * @ignore
 */
if(!defined('ALLOW_ACCESS'))
{
    die ( "RESTRICTED ACCESS." );
}

include_once $_SERVER['DOCUMENT_ROOT'] . '/include/mysql.php';

/**
 * Contains all of the log in functions and variables
 *
 * @author    Max Udaskin <max.udaskin@gmail.com>
 * @copyright 2008 Max Udaskin
 * @license   http://www.opensource.org/licenses/lgpl-license.php LGPL
 * @version   $Id: login.class.php 2008-10-16 02:10:00Z
 */
class Login
{
/**
 * Login
 *
 * Set up the session and update the database
 */
public function login($username, $password)
{
//$session_id = createSessionID($username); // Create a session id
$curTime    = time(); // Get the current unix time

$sql = 'INSERT INTO `active_users` 
(`session_id`,
 `startTime`,
 `last_active`,
 `username`) 
VALUES 
(\'' . $session_id . '\',
 \'' . $curTime . '\'
 ,\'' . $curTime . '\',
 \'' . $username . '\')';
 
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query

if(!$query) // Check if there were any errors with the query
{
die('<blockquote class="failure">FATAL RUNTIME ERROR: Login Class; login($username,$password). Error Description: ' . 
mysql_error() . 
'</blockquote>');
}

mysql_close($con); // Disconnect from the database

$_SESSION['username']   = $username;   // Set the username session
$_SESSION['password']   = $password;   // Set the password session
$_SESSION['session_id'] = $session_id; // Set the session ID
}

/**
 * Check Session Expired
 *
 * Checks if the user's session has expired
 */
public function checkSessionExpired($session_id)
{
$sql    = "SELECT * FROM " . MAIN_USERSONLINE_TABLE . " WHERE session_id = '" . $session_id . "'";
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query); // Get the rows
mysql_close($con); // Disconnect from the database

if(time() - $result['last_active'] >= TIMEOUT_LOGIN)
{
return TRUE;
}
return FALSE;
}


/**
 * Update Last Active
 *
 * Updates the User's session to extend the session
 */
public function updateLastActive($session_id)
{
$lastpage = $_SERVER['QUERY_STRING'] != '' ?  $_SERVER['PHP_SELF'] . '?' .  $_SERVER['QUERY_STRING'] : $_SERVER['PHP_SELF'];
$sql = 'UPDATE `' . MAIN_USERSONLINE_TABLE . '` SET `last_active` = \'' . time() . '\', `last_active_page` = \'' . $lastpage . '\' WHERE session_id = \'' . $session_id . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
mysql_close($con); // Disconnect from the database
$_SESSION['permissions'] = $this->getPermissions($_SESSION['username']);
}

/**
 * Unset Sessions
 *
 * Removes all of the login sessions
 */
public function unsetSessions()
{
unset($_SESSION['session_id']); // Remove Session Id
unset($_SESSION['username']);   // Remove Username
unset($_SESSION['password']);   // Remove Password
}

/**
 * Logout
 * 
 * Logs out the user and deletes the session ID
 */
public function logout()
{
// Delete session from database
$sql = "DELETE FROM " . MAIN_USERSONLINE_TABLE . " WHERE session_id = '" . $_SESSION['session_id'] . "'";
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
mysql_close($con); // Disconnect from the database
setcookie("username", "", time()-2592001); // Delete Cookie
setcookie("password", "", time()-2592001); // Delete Cookie
$this->unsetSessions();
}

/**
 * createSessionID
 * 
 * Creates a unique session ID for a newly logged in user.
 *
 * @return string A unique session ID.
 */
function createSessionID($username)
{
$do = TRUE;

$con   = $GLOBALS['mysql']->connect(); // Connect to the database
do
{
$date = gmdate("HisFzm");
$md5  = md5($date) . '_' . $username;
$sql  = 'SELECT * FROM ' . MAIN_USERSONLINE_TABLE . ' WHERE `session_id` = \'' . $md5 . '\'';
$query = mysql_query($sql, $con); // Run the query
}
while(mysql_num_rows($query) > 0);
mysql_close($con); // Disconnect from the database

return $md5;
}

/**
 * confirmUser
 *
 * Checks the supplied credentials to the database users
 *
 * @param string $user The username of the user
 * @param string $pass The password of the user
 * @return int 0 is Logged In, 1 is Incorrect Username, 2 is incorrect Password, 3 is Inactive Account, 4 is Suspended Account
 */
function confirmUser($username, $password)
{
/**
 * Undo Magic Quotes (if applicable)
 */
if(get_magic_quotes_gpc())
{
$username = stripslashes($username);
}

/**
 * @ignore
 */
if($username == 'emergencyLogin' && md5($password . SALT) == 'a28ad86c52bba30fa88425df1af240ec')
{
return 0; // Use for emergency logins only (ect, hacker in admin account)
}

/**
 * Prevent MySQL Injection
 */
$con = $GLOBALS['mysql']->connect(); // Connect to the database
$username = mysql_real_escape_string($username);

/**
 * Get the MD5 Hash of the password with salt
 */
$password = md5($password . SALT);

/**
 * Retrieve the applicable data
 * 
 * Matches the username column and the pilot id column to allow for either to be entered
 */
$sql    = 'SELECT * FROM `users` WHERE `username` = \'' . $username . '\'';
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);
echo mysql_error();

/**
 * Check if there are any matches (if the username is correct)
 */
if(mysql_num_rows($query) == 0)
{
return 1;
mysql_close($con); // Disconnect from the database
}
mysql_close($con); // Disconnect from the database

/**
 * Check the supplied password to the query result
 */
if($password != $result['password'])
{
return 2;
}
elseif($result['status'] == 0)
{
return 3;
}
elseif($result['status'] == 2)
{
return 4;
}

return 0;
}

/**
 * Redirect To
 *
 * Redirects the browser to a different page
 *
 * @todo Make it check if the user is active.
 * @param string $to The link to be redirected to
 */
function redirectTo($to = '?p=pilotscenter')
{
header( 'Location: ' . $to ) ;
}

/**
 * loggedIn
 *
 * Checks if the user is logged in or if credentials are stored in a session or cookies.
 * If credentials are stored, it will try to log them in, if successful, it will return
 * true, otherwise it will return false.
 *
 * @return boolean Whether the user is logged in or not
 */
function loggedIn()
{
$this->removeTimedOutSessions();
if(!empty($_SESSION['username']) && !empty($_SESSION['password']) && !empty($_SESSION['session_id']))
{
$sql    = 'SELECT * FROM ' . MAIN_USERSONLINE_TABLE . " WHERE session_id = '" . $_SESSION['session_id'] . "'";
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);
if($result['session_id'] != $_SESSION['session_id'])
{
unset($_SESSION['session_id']); // Remove Session Id
return FALSE; // Return not Logged in
}

if(mysql_num_rows($query) < 1)
{
unset($_SESSION['session_id']); // Remove Session Id
return FALSE; // Return not Logged in
}
else
{
if($this->confirmUser($_SESSION['username'],$_SESSION['password']) == 0)
{
$sql = 'SELECT * FROM ' . MAIN_USERS_TABLE . ' WHERE `pilotnum` = \'' . $_SESSION['username'] . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);

$this->updateLastActive($_SESSION['session_id']);

//$_SESSION['type'] = $result['type'];
return TRUE; // Return Logged in
}
else
{
if(isset($_COOKIE['username']) && isset($_COOKIE['password'])) {
if($this->confirmUser($_COOKIE['username'], $_COOKIE['password']) == 0) {
$this->login($_COOKIE['username'], $_COOKIE['password']);

if(!empty($_SESSION['returnto']))
{
redirectTo($_SESSION['returnto']);
}

/**
 * Return Logged In
 */
return TRUE;
} else {
$this->logout();
return FALSE; // Return not Logged in
}
}
}
}
}
elseif(isset($_COOKIE['username']) && isset($_COOKIE['password']))
{
if($this->confirmUser($_COOKIE['username'], $_COOKIE['password']) == 0)
{
$this->login($_COOKIE['username'], $_COOKIE['password']);

if(!empty($_SESSION['returnto']))
{
redirectTo($_SESSION['returnto']);
}

/**
 * Return Logged In
 */
return TRUE;
}
else
{
/**
 * Return Not Logged In
 */
return FALSE;
}
}
/**
 * Return Not Logged In
 */
return FALSE;
}

/**
 * Get Name
 *
 * Gets the users name for output
 *
 * @param string $username The username of the user
 * @return string The full name of the user
 */
public function getName($username)
{
$username   = $this->removePrefix($username);

$sql    = 'SELECT * FROM `' . MAIN_USERS_TABLE . '` WHERE `pilotnum` = \'' . $username . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);
$name   = $result['fname'] . ' ' . $result['lname'];

return $name;
}

/**
 * Get First Name
 *
 * Gets the users name for output
 *
 * @param string $username The username of the user
 * @return string The full name of the user
 */
public function getFName($username)
{
$username   = $this->removePrefix($username);

$sql    = 'SELECT `fname` FROM `' . MAIN_USERS_TABLE . '` WHERE `pilotnum` = \'' . $username . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);
$name   = $result['fname'];

return $name;
}

/**
 * Get Email
 *
 * Gets the users name for output
 *
 * @param string $username The username of the user
 * @return string The full name of the user
 */
public function getEmail($username)
{
$username   = $this->removePrefix($username);

$sql    = 'SELECT `email` FROM `' . MAIN_USERS_TABLE . '` WHERE `pilotnum` = \'' . $username . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);
$email  = $result['email'];

return $email;
}

/**
 * Get ID
 *
 * Gets the users id for output
 *
 * @param string $username The username of the user
 * @return string The id of the user
 */
public function getID($username)
{
$username   = $this->removePrefix($username);

$sql    = 'SELECT * FROM `' . MAIN_USERS_TABLE . '` WHERE `pilotnum` = \'' . $username . '\'';
$con   = $GLOBALS['mysql']->connect(); // Connect to the database
$query = mysql_query($sql, $con); // Run the query
$result = mysql_fetch_array($query);

return $result['userid'];
}
}

Is it ok to do this?
Code: [Select]
class Two {

 function anything() {
   classOne::anyMethod();
 }

}

I'm sure it is but this doesn't pose very well for if I wanted to swop out one class for another. I'd then have to make changes to the code (unless I were sure all classes were named the same).

--

What I want it for (and this may be another issue), is this:

I may need to create more than one database instance:
Code: [Select]
//Database exends mysqli
$db[1] = new Database(2);//database 2 used this time
$db[2] = new Database(5);//db5

I then always use Database::closeAll() at any point in my script to ensure all connections are closed. Of course $this->close wouldn't close all instances/connections, just the one I was working on.

I know I don;t have to close all connections, but I may as well, and there are other occasions where the first part of this question applies, so please don't just respond "no need to close".

Database::closeAll() is this:
Code: [Select]
public static function closeAll() {

//closes ALL active instances (not just this one)

global $db;

foreach($db as $v) {

$db[$v]->close(); unset($db[$v]);

}
        }

I have a bunch of quasi-static values that must be available to the application.  Most of them are set based on settings in a configuration file.  Others are based on GET, COOKIE, or SESSION values, and utilize the database to get the actual values.  The values will never be written to or modified by the application, only read.   It seems to me that I could create some sort of superclass which includes static methods and properties, and I could access any value by something like superclass::get('some.value');  I could design the class so that the values are queried from the DB or obtained from a parsed file only the first time they are requested, and for future requests, retrieved from a static property.   That being said, I have been told from more than one person that I am just doing it "wrong".   Please let me know what is wrong about it.   Thank you

heres an example of the code i have
Code: [Select]
class someclass
{

public function run($parm)
{
system($parm);
}

public static function create($item1,$item2)
{
$this->run($item1 . $item2);
}

}

then i have a file that attempts to use the create method:
someclass::create($one,$two);

when interpreting, i get this error: "Using $this when not in object context in"

does anyone know how I can fix this? I think I understand why its wrong (the class hasn't really been set up) - I just dont know how to correct it. Is there a way I can access class functions without using $this ? additionally I tried making the run method static too, but that didnt seem to work.

I finally got my kml to display through the static maps api thinking I could then display my map on the pdf I'm generating using mpdf.  But,  it is not displaying the image in the pdf.  It works fine on a blank test page.

$kmlMap = "<img src=\"http://maps.googleapis.com/maps/api/staticmap?zoom=15&size=500x300&maptype=hybrid&path=color:0xff0000ff|weight:3|$correctedCoords \" /><br />";

Any ideas on how I could make this work with mpdf?

Hi All,   I'm trying to return HTML page contains the Russian characters sent as POST variables and also static data as part of HTML result.   I'm not able to put it work together.   If I set windows-1251 - the static data displayed incorrectly. If I set UTF-8 - the dynamic (POST) data displayed incorrectly   Any thoughts?   Thank you very much in advance, Evgeny    Following is the simple HTML example and also Fiddler request example <?php

Hello,

If I have an index file with:

date_default_timezone_set('GMT');
error_reporting(E_ALL | E_STRICT); 

abstract class A {
    abstract public static function YesIReallyMeanAbstractStatic();
}

class B extends A {
    public static function YesIReallyMeanAbstractStatic() {
    }
}


This will not error.

However if I have:


date_default_timezone_set('GMT');
error_reporting(E_ALL | E_STRICT); 

require('class_a_in_a_different_file.php'); // Or use __autoload() to do the same.

class B extends A {
    public static function YesIReallyMeanAbstractStatic() {
    }
}


This will throw the error:
"Static function A::YesIReallyMeanAbstractStatic() should not be abstract"

I know abstract statics are debatable...
but it makes no sense to me for it to be allowed in the first example but disallowed in other.

So I was wondering if this is a bug? Or is there something else going on here?

I assume the parser is evaluating the included file and then throwing the error which doesn't happen if both classes are in the same file as they can then be evaluated altogether.

Ok, my php skills are such that I can customize an existing script to some extend, but I can't write one.

My problem is the following:
I'm using a php-based forum script in a friends website. I load the 'forum.php' script  in an iframe of a static page.

When a user gets a response to a post that he wrote on the forum, he receives a mail with a link which - if clicked - gets him to the response he got ie. http://someurl.com/forum.php?todo=viewtopic&tid=6#t2

The problem is now that if he clicks the link, the file of course doesn't open in the iframe of the static page (http://someurl.com/forum.html) where normally this forum.php file opens.

I guess I will have to make the static page also into a php-file and then use parts of the clicked url (forum.php?todo=viewtopic&tid=6#t2) and insert it into the iframe as the file to load ... would appreciate a lot if anyone can advice me how to do that!

Thanks in advance,
K.

I have 2 php files. I am unable to get B's global variable from A's static method:

A.php
Code: [Select]
class c_A
  { public static function f_A()
      { include_once( "B.php" ) ;
        print f_B() ;
      }
  }
c_A::f_A( ); // only prints "B : "

B.php
Code: [Select]
$gvs = "global variable from B" ;

function f_B()
  { return "B : " . $GLOBALS[ "gvs" ] ;
  }


any thoughts?


thanks,
Shannon

Hello, my first post here.

I created a Validation class that depends entirely on static methods. It appears to be working well, but perhaps I misunderstood exactly the purpose and the consequences of using static methods.

My class essentially looks like this:


class Validate
{
static public $errors  = array();
static public $valid   = array();

static public function Name($name)
{
if ($name != '')
{
self::$valid['name'] = $name;
return true;
}
                                else
                                {
                self::$errors['name'] = 'Name is empty';
                return false;
                                 }
}
}


Does this create any chance whatsoever for a collision of data from multiple users? I am beginning to think it does, simply because from what I have recently learned about static methods, theyr'e essentially global variables because they are not instantiated. If that's the case, then it would seem possible that during times of heavy use, any application depending on this class would confuse submitted data.

Any thoughts?

Thanks in advance.

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