PHP - Late Static Binding

I have an application that uses the PHP LDAP library to connect to the Windows Active Directory:

$ds = ldap_connect($ini['ad_server']) or die("Could not connect");
$admin = $ini['ad_user'];
$passwd = $ini['ad_password'];
$passwd = base64_decode($passwd);
$dn = $ini['ad_basedn'];

ldap_set_option($ds, LDAP_OPT_PROTOCOL_VERSION, 3);
ldap_set_option($ds, LDAP_OPT_REFERRALS, 0);
$rInTouch = ldap_bind($ds, $admin, $passwd);

I am wondering if anyone knows if this upcoming patch "2020 LDAP channel binding and LDAP signing" coming from Microsoft will break any PHP applications that are using this ldap library.

Thanks in advance,

 

M

We are able to access Static/Non-static methods with :: operator along with Class name.
What for static in this case?  I am using php5.2.x.  Please give some light on using static in php?


class One{
   function disp(){
      echo " disp here";
   }

       static function show() {
            echo "show here";
      }

}
   One::disp();
        One::show();

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
    }

hey guys i have a static attribute $_exception_handler which is set to Exception and....now this value could change to a customer exception_handler but what i want to do is


<?php

catch (self::$_exception_handler $e)
{

}


but im getting an error...is there a way of doing this...any help would be greatful thanks

class below
<?php

class Autoloader
{

protected static $_exception_handler = Exception;

protected static $_classes           = array();

public static function load_library($class_name)

{

$file = ROOT . DS. LIBRARY_DIRECTORY . DS . $class_name . CLASS_EXTENSION;

try

{

self::load_class($class_name, $file);

}

catch (self::$_exception_handler $e)

{

echo $e->getMessage();

}

}

public static function load_exception($class_name)

{

}

public static function load_class($class_name, $file)

{

if (!class_exists($class_name, FALSE))

{

if (file_exists($file))

{

require_once $file;

}

else

{

throw new Exception(sprintf('Class %s not found.', $class_name));

}

}

}

}

Is it possible to have a static variable in php?  I want the value of a variable to remain unchanged the next time a function is called.

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

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?

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]);

}
        }

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?

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  

so my situation is something like this , i'm trying to fetch user details based on `id` that isset is getting, but some how the `variable that contains the $_GET value doesn't work` in query but when i put an static value to pdo query then it works and show the result. i have checked by doing `var_dump` of variable `$user` before query and it shows the correct value but not working in query. Below is the code i'm working with:

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