PHP - Unstable Remote Site, Avoid Timeout Etc?

I have a sorting functionality, the code is he


<?php

$select_category = $_REQUEST['sort_category'];

$sort_date_var = $_REQUEST['sort_date'];

$sort_submit = $_POST['sortSubmit'];

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

if (($select_category == 'All') || (!isset($select_category)) && (!isset($sort_date_var))) {

// Retrieve the chosen category from MySQL

$query

= "SELECT * FROM con";

$data = mysqli_query($dbc, $query);

//Loop through the array of data

while ($row = mysqli_fetch_array($data)) 

{

echo "<table class='knuffixTable'>";

// Display the score data

echo "<tr><td class='knuffix_name'>";

echo "<strong>" . htmlentities($row['name']) . "</strong><br /></td></tr>";

echo "<tr><td class='knuffix_contribution'><pre>" . $row['contribution'] . "</pre><br /></td></tr>";

echo "<tr><td class='knuffix_categoryDate'>" . $row['category'] . " | " . date('M d, Y', strtotime($row['contributed_date'])) . " </td></tr>";

echo "</table>";

}

mysqli_close($dbc);

} elseif (isset($select_category) && !isset($sort_date_var)) {

// Retrieve the chosen category from MySQL

$query = "SELECT * FROM con WHERE category = '$select_category'";

$data = mysqli_query($dbc, $query) or die (mysqli_error($dbc));

//Loop through the array of data

while ($row = mysqli_fetch_array($data)) 

{

echo "<table class='knuffixTable'>";

// Display the score data

echo "<tr><td class='knuffix_name'>";

echo "<strong>" . htmlentities($row['name']) . "</strong><br /></td></tr>";

echo "<tr><td class='knuffix_contribution'><pre>" . $row['contribution'] . "</pre><br /></td></tr>";

echo "<tr><td class='knuffix_categoryDate'>" . htmlentities($row['category']) . " | " . date('M d, Y', strtotime($row['contributed_date'])) . " </td></tr>";

echo "</table>";

}

mysqli_close($dbc);

} elseif (!isset($select_category) && isset($sort_date_var)) {

// Retrieve the chosen category from MySQL

$query = "SELECT * FROM con ORDER BY contributed_date $sort_date_var";

$data = mysqli_query($dbc, $query) or die (mysqli_error($dbc));

//Loop through the array of data

while ($row = mysqli_fetch_array($data)) 

{

echo "<table class='knuffixTable'>";

// Display the score data

echo "<tr><td class='knuffix_name'>";

echo "<strong>" . htmlentities($row['name']) . "</strong><br /></td></tr>";

echo "<tr><td class='knuffix_contribution'><pre>" . $row['contribution'] . "</pre><br /></td></tr>";

echo "<tr><td class='knuffix_categoryDate'>" . htmlentities($row['category']) . " | " . date('M d, Y', strtotime($row['contributed_date'])) . " </td></tr>";

echo "</table>";

}

mysqli_close($dbc);

} elseif (isset($select_category) && isset($sort_date_var)) {

// Retrieve the chosen category from MySQL

$query = "SELECT * FROM con WHERE category = '$select_category' ORDER BY contributed_date $sort_date_var";

$data = mysqli_query($dbc, $query) or die (mysqli_error($dbc));

//Loop through the array of data

while ($row = mysqli_fetch_array($data)) 

{

echo "<table class='knuffixTable'>";

// Display the score data

echo "<tr><td class='knuffix_name'>";

echo "<strong>" . htmlentities($row['name']) . "</strong><br /></td></tr>";

echo "<tr><td class='knuffix_contribution'><pre>" . $row['contribution'] . "</pre><br /></td></tr>";

echo "<tr><td class='knuffix_categoryDate'>" . htmlentities($row['category']) . " | " . date('M d, Y', strtotime($row['contributed_date'])) . " </td></tr>";

echo "</table>";

}

mysqli_close($dbc);

}

?>



With this code I'm able to:
- showcase every category by DEFAULT when someone comes to the page.
- sort only by category,
- sort only by date,
- sort by category AND date,

The problem is as you can see I have a lot of duplicate code, if I for example want to change the table that is being printed out, I have to change it on all of them. I'd like to ask how I could avoid this duplicate code. Can I for example just have the table ONE TIME at a separate place and then insert the REFERENCE _after_ the query in each if statement?

Like this:


if (($select_category == 'All') || (!isset($select_category)) && (!isset($sort_date_var))) {

// Retrieve the chosen category from MySQL

$query

= "SELECT * FROM con";

$data = mysqli_query($dbc, $query);

table_here();

} elseif (isset($select_category) && !isset($sort_date_var)) {

// Retrieve the chosen category from MySQL

$query = "SELECT * FROM con WHERE category = '$select_category'";

$data = mysqli_query($dbc, $query) or die (mysqli_error($dbc));

table_here();

}



I'm just coding since 2 month so I don't know how do it, maybe I can do it with functions?

I've tried doing it with functions, but I got an error since the function doesn't contain any query statement and only the table because it was trying to fetch.

it looked like this:



function table_here () {

//Loop through the array of data

while ($row = mysqli_fetch_array($data)) 

{

echo "<table class='knuffixTable'>";

// Display the score data

echo "<tr><td class='knuffix_name'>";

echo "<strong>" . htmlentities($row['name']) . "</strong><br /></td></tr>";

echo "<tr><td class='knuffix_contribution'><pre>" . $row['contribution'] . "</pre><br /></td></tr>";

echo "<tr><td class='knuffix_categoryDate'>" . $row['category'] . " | " . date('M d, Y', strtotime($row['contributed_date'])) . " </td></tr>";

echo "</table>";

}

mysqli_close($dbc);

}

1 - I am using phpmailer to send an email to a people without defining the $headers = 'From:" , so the From section of the email is showing default server aekcom@xen​on.sfdns.ne​t , the email didn't go to Junk box, I am so happy.

2 - Then I apply $headers .= 'From: Pflik <admin@pflik.com>'; on the php mailer now. The email go to Junk box now. I am sad.

My question : How do I change the default email server of my hosting aekcom@xen​on.sfdns.ne​t into admin@pflik.com ? If I can change it, then the email won't go to junk box anymore.

Hello, I have a form that has a preview, before user can preview the form inputs he must login. If he is logedin, he can see preview and continue to editing form, but after user is finished with editing his values he is redirected to "preview" page for which he must be logged in. But the problem is that variables are "empty" after redirecting back to preview.

$_POST['email'] is received from login.php
$_SESSION['code'] is 5 digit code generated at start, it isn't important in this issue.

Here's the code:

preview.php
Code: [Select]
$id_user= 0;
$code = $_SESSION['code'];
    $email = $_POST['email'];
    $_SESSION['email_login'] = $email;
So now you can see that $email and $_SESSION['email_login'] are empty because when redirecting from "editing" to preview  $_POST['email'] can't be found...

Hello Everyone,

I m making an attendance application.

I have an issue with following code,

Code: [Select]
<?php 
session_start();
require_once("conf.php");
mysql_select_db('site');
$subjects=$_GET['sublen'];
$username=$_SESSION['user'];
for($i=1;$i<=$subjects;$i++)
{
$subject=$_GET[',Sub'.$i];
$query="INSERT INTO Subjects(id,Subjects,User,Classs) VALUES($i,'$subject','$username','F.Y.B.Sc')";
$true=mysql_query($query) or die("Cannot Store subjects".mysql_error());

}

?>

<html>
<head>
<link href="../css/style.css" type="text/css"  rel="stylesheet" />
<script type="text/javascript" src="../js/jquery.js"></script>
</head>
<body>
<div id="main">
<div id="logo">
KiMi...
</div>
<div id="header">
<ul>
<li><a href="index.html">Home</a></li>
<li><a href="php/subjectsTable.php">Create Subjects</a></li>
<li><a href="html/form.html">Contact Us</a></li>
<li><a href="html/register.php">Register!</a></li>
</ul>
</div>
<div id="nav">

</div>
<div id="content">
<?php 
if($true)
{
echo "<div id='dynamicDiv'>";
echo "<div> Subjects stored Successfully!</div></br></br>";
$query="SELECT * FROM Subjects Where User='$username'";
$result=mysql_query($query) or die("Cannot Fetch Data");
echo "<table id='table'>";
echo "<tr><td>&nbsp;</td><td>Subjects</td><td>Class</td></tr>";
while($row=mysql_fetch_array($result))
{
echo "<tr><td><input type='checkbox' name='box[]'/>&nbsp;</td>";
echo "<td>";
echo $row['Subjects'];
echo "</td>";
echo "<td>";
echo $row['Classs'];
echo "</td>";
echo "</tr>";
}
echo "</table>";
echo "</div>";
}
?>

</div>
<div id="footer">
&#169;&nbsp;Copyright Amit K. Goda 2011-2012
</div>
</div>
</body>
</html>

In the above code i m storing data into database which has been passed into $_GET array.
The Code is this

Quote

<?php
session_start();
require_once("conf.php");
mysql_select_db('site');
$subjects=$_GET['sublen'];
$username=$_SESSION['user'];
for($i=1;$i<=$subjects;$i++)
{
$subject=$_GET[',Sub'.$i];
$query="INSERT INTO Subjects(id,Subjects,User,Classs) VALUES($i,'$subject','$username','F.Y.B.Sc')";
$true=mysql_query($query) or die("Cannot Store subjects".mysql_error());

}

?>


the data is stored
but the issue is, since i have data coming in $_GET array when i reload my page the same data is stored again inmy database.

So any suggesstions how can i avoid that???

Any Help will be highly appreciated

I'm learning functions and I'm working on a rating script. This is a small test script that works, you can try it out yourself:


<?php

// Rating System

function while_test (){

$a = 1;
$b = 4;
$t_id = 1;

global $likes;

global $dislikes;

global $con_id;

while ($a++ <= $b){

echo "<center>";

echo "<table><tr><td>Table: </td></tr>";

echo "<tr><td>This is a table test </td></tr>"; 

echo "<tr><td><form action='' method='post'>";

echo "<button type='submit' name='likes' value='Y'>likes</button>";

echo "<button type='submit' name='dislikes' value='N'>dislikes</button>";

echo "<input type='hidden' name='hidden_id' value='" . $t_id . "' /></form></td></tr></table>"; 

echo "</center><br /><br />"; 

$t_id++;

$likes = $_POST['likes'];

$dislikes = $_POST['dislikes'];

$con_id = $_POST['hidden_id'];

}

}



while_test();


if ($likes) {

echo "likes it: " . $likes . " con_id: " . $con_id;

} elseif ($dislikes) {

echo "dislikes it: " . $dislikes . " con_id: " . $con_id;

}

?>


I've gotten recommended before not use globals, because the projects would become unmanageable, and I'm wondering how would I be able to avoid using globals in this example?

I'm able to in-ject variables through the parenthesis, but I'm not able to out-ject variables, if that makes sense. (?)
At least it doesn't work for me.

How would I use those three variables $likes, $dislikes and $con_id outside the function without setting them as globals, what would be good practice?

I'm just looking for some tips here. I am developing and selling an eccommerce shopping cart software package, and it has been received very well from the early adopters. There's just one small problem that prevents the software from being a truly out-of-the-box solution: the include path. Not all users have access to their php.ini file, and it's not always a php.ini file anyway. So this is something the installation is unable to set for the customer.

I'm using object-oriented PHP5 stuff, so I have a folder named "classes" with all the relevant stuff in there. I am unable to search for paths to the folder and hard-code those into source files (there are ajax calls and other fun stuff; hard to know the exact relation to the path).

I guess I could use set_include_path on the top of a bunch of files, but that is a small performance hit (and totally inelegant code). I could put the folder path in the database somewhere and query for it (and cache it so it's not a performance hit). None of this stuff seems good. The path seems like the best solution.

Unless you have better ideas....

Array ( [0] => Virender Sehwag|||http://abc.xyz.com/Virender-Sehwag [1] => Sachin Tendulkar|||http://abc.xyz.com/Sachin-Tendulkar )


foreach($array as $arr) {

                $topics=explode ('|||', $array);


echo '<li>'
                        .'<a rel="nofollow" target="_new" href="'.$topics[1].'"><span class="title">'.html_entity_decode($topics[0], ENT_NOQUOTES, "UTF-8").'</span></a>|</li>';



How to avoid '|' for the last element of any aaray. Also if array contains only 1 element '|' should not appear.

For eample,

In the browser it should display as "Virender Sehwag | Sachin Tendulkar".

If the array contains only 1 element then, In the browser it should display as Virender Sehwag

if array contains 3 elements,

Virender Sehwag | Sachin Tendulkar | someword

Trying to make my code more secure.

This is what I currently have, which is not secure by any means:

Code: [Select]
$query1 = "SELECT COLUMN_NAME, DATA_TYPE, ORDINAL_POSITION, COLUMN_DEFAULT, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_NAME='$table'";
 
// Run PRO query

$qresult1 = sqlsrv_query($dbPRO, $query1);
if ($qresult1 === false) {
    exitWithSQLError('Retrieving schema failed.');
}
This is how I changed it,

Code: [Select]
$query1 = "SELECT COLUMN_NAME, DATA_TYPE, ORDINAL_POSITION, COLUMN_DEFAULT, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_NAME=?";
$params = array(1, $table);
 
// Run PRO query
$qresult1 = sqlsrv_query($dbPRO, $query1, $params);
if ($qresult1 === false) {
    exitWithSQLError('Retrieving schema failed.');
}
but I'm getting this error:

Code: [Select]
SQL-Status: 22018
Code: 245
Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting the nvarchar value 'sysrscols' to data type int
Please notice I am using sqlsrv_query function because my database engine is MS-SQL 2008. That's why I'm a bit confused. Most documentation online is pointed to MySQL.

exitWithSQLError is a customized function of mine, so please ignore. 

Any help or hints is appreciated,

Thanks,

I am using this code to check if a server is running. Everything is fine when it is running, but when it's not, it takes ages for the fsockopen to fail. Is there a way to make it timeout faster?
    
if (fsockopen($settings->survival_server, $settings->survival_port, $timeout = 0.1)){
        $survival['status'] = "Up";
    }else {
        $survival['status'] = "Down"
}

Okay, I'm not quite sure how to state this, so I'll try my best.

Is it possible to setup some kind of "after so long, it changes the state of something from 'fighting' to 'active'" query or function?

What is happening is that people are fighting in my game, then choosing to just close their browser rather than quit the fight, to change the monster's state back to 'active', so other people can fight it.

Does that make sense?

Any thoughts or could someone point me in the right direction?

Thanks!!

Hi,

 

I have a heavy php page that is timing out at 30 seconds. I do not have access to change/set any ini or max_execution_time or the like. I need to find some creative workaround. First, I looked at async calls, but I'm using Yii 1.1 at the moment and it didn't look like simple to implement when I had a quick glance at that. Is it possible to load the content via ajax instead?

I have a site up where my client can enter some text in a box, and save it to a database.  But the page keeps timing out.  I can't get it to happen in Firefox or Chrome so it leads me to believe that its a setting in IE?

This is what I have tried:

set_time_limit(0) which i understand sets the time limit for the script to unlimitted.


ini_set("session.use_cookies", 1);
ini_set("session.cookie_lifetime", 0);

Turns cookies on, and makes them last forever.

session_set_cookie_params(3600);
Makes a cookies last for an hour.

I have tried all of these, and I have tried them in pieces.
[EDIT] I do places all before session_start

I have read that some of this can go into the php.ini file, but I cannot figure out exactly what I am supposed to add?

Our current php.ini is the default:

* CODE *******************************************************************************
register_globals = off
allow_url_fopen = off

expose_php = Off
max_input_time = 60
variables_order = "EGPCS"
extension_dir = ./
upload_tmp_dir = /tmp
precision = 12
SMTP = relay-hosting.secureserver.net
url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=,fieldset="

; Only uncomment zend optimizer lines if your application requires Zend Optimizer support

;[Zend]
;zend_optimizer.optimization_level=15
;zend_extension_manager.optimizer=/usr/local/Zend/lib/Optimizer-3.3.3
;zend_extension_manager.optimizer_ts=/usr/local/Zend/lib/Optimizer_TS-3.3.3
;zend_extension=/usr/local/Zend/lib/Optimizer-3.3.3/ZendExtensionManager.so
;zend_extension_ts=/usr/local/Zend/lib/Optimizer_TS-3.3.3/ZendExtensionManager_TS.so


; -- Be very careful to not to disable a function which might be needed!
; -- Uncomment the following lines to increase the security of your PHP site.

;disable_functions = "highlight_file,ini_alter,ini_restore,openlog,passthru,
;            phpinfo, exec, system, dl, fsockopen, set_time_limit,
;                     popen, proc_open, proc_nice,shell_exec,show_source,symlink"
* CODE *******************************************************************************

Where do I go from here?  What is my next step?

Thanks for taking the time to read my post, and thanks for the help!
Nick

Hey I was wondering is there a way I can set my sessions to timeout/end a session after a certain amount of time? Here is what I am dealing with...
Code: [Select]
<?php
session_start();

$username = $_SESSION['username'];
$userid = $_SESSION['userid'];
?>

Hi Im trying to keep a session open once a user logs in for a large amount of time ( months)

I have set the following in a .htaccess file

php_value session.cookie_lifetime 99999999
php_value session.gc_maxlifetime 99999999

But i still lose the session and get logged out after 10 minutes or so i have created a phpinfo page and see that for these values the following is set

session.cookie_lifetime 99999999( local) 0 (global)
session.gc_maxlifetime 99999999 ( local) 1440 (global)

What is the difference between the local and global?

Any other ides why might session keeps timing out after 10 mins or so of inactivity?

I was wanting to make some kind of session timeout ability, just purely out of curiosity.

I have tried going off my own theory, before looking at any tutorials, well have looked a bit but tried getting the jist and having a go myself the next day (anyways that being said), this code he

Code: [Select]
<?php
ini_set('display_errors', 1);
session_name("jeremysmith_test_session");
session_start();

$_SESSION['start_time'] = time();

if($_SESSION['start_time'] < $_SESSION['start_time'] + 500) {
  printf("Time out be out dated!");
}
Just does not seem to want to work, is there any reason for this, that you could think of?

I appreciate any replies,
Jeremy.