PHP - Weird Array Problem

Hello there,

I am making a function to execute every time with a new demand no. in the while loop below. Every thing goes fine for the first time when the page loads, all the taxes come perfectly and each record is being read with the function calculateTaxes($demandno). But, when I press the search button with blank entries... All the entries come with only the first record. Means, the calculateTaxes function is not being loaded again and again with the loop when the press the search button.

Please help.

Please have a look in the below given code:

Code: [Select]
<?php
function renderform($wardno, $demandno, $name)
{
include_once $_SERVER['DOCUMENT_ROOT'].'/npms/header.php';
include_once $_SERVER['DOCUMENT_ROOT'].'/npms/config/config.php';
include_once $_SERVER['DOCUMENT_ROOT'].'/npms/functions/functions.php';
include_once $_SERVER['DOCUMENT_ROOT'].'/npms/functions/connect-db.php';
extract($GLOBALS);

if ($demandno == '' && $wardno == '' && $name == '') // all empty.
{
$result = mysql_query("SELECT * FROM sform where paid=false order by wardno, id, demandno limit 0,$maxrecords") or die(mysql_error());
}
if ($demandno != '' && $wardno != '' && $name != '') // all full.
{
$result = mysql_query("SELECT * FROM sform where demandno='$demandno' and wardno='$wardno' and (name like '%$name%') and paid=false order by wardno, id, demandno") or die(mysql_error());
}
if ($demandno != '' && $wardno == '' && $name == '') // demand full else empty.
{
$result = mysql_query("SELECT * FROM sform where demandno='$demandno' and paid=false order by wardno, id, demandno") or die(mysql_error());
}
if ($demandno != '' && $wardno != '' && $name == '') // demand and ward full else empty.
{
$result = mysql_query("SELECT * FROM sform where demandno='$demandno' and wardno='$wardno' and paid=false order by wardno, id, demandno") or die(mysql_error());
}
if ($demandno == '' && $wardno != '' && $name == '') // ward full else empty.
{
$result = mysql_query("SELECT * FROM sform where wardno='$wardno' and paid=false order by wardno, id, demandno") or die(mysql_error());
}
if ($demandno == '' && $wardno != '' && $name != '') // ward and name full else empty.
{
$result = mysql_query("SELECT * FROM sform where wardno='$wardno' and (name like '%$name%') and paid=false order by wardno, id, demandno") or die(mysql_error());
}
if ($demandno == '' && $wardno == '' && $name != '') // name full else empty.
{
$result = mysql_query("SELECT * FROM sform where (name like '%$name%') and paid=false order by wardno, id, demandno") or die(mysql_error());
}
if ($demandno != '' && $wardno == '' && $name != '') // demand and name full else empty.
{
$result = mysql_query("SELECT * FROM sform where demandno='$demandno' and (name like '%$name%') and paid=false order by wardno, id, demandno") or die(mysql_error());
}

usleep(200000); // wait for 2 seconds
?>
<link rel=stylesheet HREF="/npms/css/sp.css" type="text/css" media="screen">
<div id="content">
<div id="labelopt"></div>
<h2>okMZokj ukxfjdksa dh lwph</h2>
<div id="list">
<form name="spsearchform" action="" method="post">
<table border="1" cellpadding="2px">
<tr>
<td id="labelmust" width="10%">fM- dz- %</td>
<td><input class="english" type="text" size="15%" name="demandno" maxlength="40" value="<?php echo $demandno; ?>" /></td>
<td id="labelmust" width="10%">okMZ dz- %</td>
<td><input class="english" size="20%" type="text" size="15%" name="wardno" maxlength="3" value="<?php echo $wardno; ?>"/></td>
<td id="labelmust" width="10%">uke %</td>
<td><input class="hindi" size="30%" type="text" name="name" maxlength="100" value="<?php echo $name; ?>"/></td>
<td><input type="submit" value="Search" name="btnsearch" /></td>
</tr>
</table>
</form>
<div style="color: red;"><small><cite>List is limited to <? echo $maxrecords; ?> records. For precise searching, use the search options above.</small></cite></div>

<table border="1" cellpadding="2px">
<tr>
<td colspan="8" id="english"><div style="float: right; color: red; text-align: right; margin-right: 10px;"><small><cite><strong><? echo mysql_num_rows($result); ?> records</strong> dumped.</cite></small></div></td>
</tr>

<tr>
<td id="labelcenter">okMZ dz-</td>
<td id="labelcenter">fMeka.M dzekad</td>
<td id="labelcenter">uke</td>
<td id="labelcenter">irk</td>
<td id="labelcenter">'kq} dj</td>
<td id="labelcenter">dj fooj.k</td>
<td id="labelcenter">fu;kstu</td>
<td id="labelcenter">feVk;sa</td>
</tr>

<?php
if (mysql_num_rows($result) > 0) {
while($row = mysql_fetch_array( $result ))
{
echo "<tr>";
echo "<td id='english'><center>" . $row['wardno'] . "</center></td>";
echo "<td id='english'><center>" . $row['demandno'] . "</center></td>";
echo "<td id='hindi'>" . $row['name'] . "</td>";
echo "<td id='hindi'>" . $row['address'] . "</td>";
$taxes = calculateTaxes($row['demandno']);
echo "<td id='english' align='right'>" . number_format($taxes['grosstax'],2) . "</td>";
                echo '<td><center><a href="payments/taxreport.php?demandno=' . $row['demandno'] . '"><img src="../images/payment.jpeg" width="15" height="15" /></center></a></td>';
echo '<td><center><a href="spedit.php?demandno=' . $row['demandno'] . '"><img src="../images/edit.gif" width="15" height="15" /></center></a></td>';
echo '<td><center><a href="spdelete.php?demandno=' . $row['demandno'] . '"><img src="../images/delete.jpeg" width="15" height="15" /></center></a></td>';
}
}
else
{
echo "<tr>";
echo "<td colspan='7' align='center'><blink><strong>lwph miyC/k ugha gS A</strong></blink></td>";
echo "</tr>";
}
?>
</tr>
</table>
</div>
<div id="menu">
<table>
<tr>
<td>
<input type="button" value="New" name="btnnew" onclick="location.href='spnew.php';" />
<input type="button" value="Back" name="btnspback" onclick="location.href='../sp.php';" />
</td>
</tr>
</table>
</div>
</div>

<?php include_once $_SERVER['DOCUMENT_ROOT'].'/npms/footer.php';
}
include_once $_SERVER['DOCUMENT_ROOT'].'/npms/functions/connect-db.php';
include_once $_SERVER['DOCUMENT_ROOT'].'/npms/functions/functions.php';
if(isset($_POST['btnsearch']))
{
$wardno = mysql_real_escape_string(htmlspecialchars($_POST['wardno']));
$name = mysql_real_escape_string(htmlspecialchars($_POST['name']));
$demandno = mysql_real_escape_string(htmlspecialchars($_POST['demandno']));

renderform($demandno, $wardno, $name);
}
else
{
renderform('', '', '');
}
?>

I am simple using include to include a file within the webpage.

include $file;

$file does exist and is a string. This works fine locally but when testing on my live server it isnt included and nothing below the include is executed, not even plain html.

The error log shows nothing, and there are no errors on screen even when using E_ALL. So i decided to make $file point to the file on the server to see if it was picking it up and it does. So why doesnt the live server want to include this file?

The file consists of php and html but there arent any errors. It wouldnt work locally if there were.

Any ideas?

Hey guys!

Well this is actually kind of a weird problem I have been having, and not too sure why I'm getting this problem. I've tried a lot of stuff, and it doesnt seem like I've been able to find a solution. I've been trying for about a month.

Anyways, I have a website created with some OOP. Well, once I write an include statement to include a file, which then includes all my classes, it messes up my font, moves my website content down, and well.. it just does weird stuff.

However, once I comment the include out, the website looks normal again.

so basically, I can comment out the file itself and everything is just fine. But it only happens when I include my class files.

Any ideas or suggestions would be amazing! Thank you!

I have a function that contains 2 UPDATE commands. One updates a table whenever the function is ran. The second updates only if a condition is met.

When the page loads the function is ran. For some reason the table is updated twice. So my table looks like this:

Initially
Viewed: 0 Replies: 0

Navigate to page:
Viewed:2 Replies:0

Enter a reply and submit:
Veiwed:4 Replies:1

No matter where I move the "viewed +1" code, it fires twice per page impression. Is this a glitch? Do functions run twice for some reason? If so why doesn't "reply +1" fire twice?



//page loads as forum.php?goto=innertopic
function connectForum(){
     //connects DB
     if($_GET['goto'] == "innertopic"){
          detailTopic();
     }
}
function detailTopic(){
     if(isset($_POST['content']{ //if there is a reply to a post
          mysql_query("UPDATE topics SET Replies=Replies+1") //works fine
     }
     else{ //no reply, just show all posts
          mysql_query("UPDATE topics SET Views=Views+1") //fires 2 times per page load .. ?!?!?
          //show posts
          //show reply window, posts to forum.php?goto=innertopic&&content=whateverTheUserTyped
     }
}

//html of page

if($_GET['goto'] == "innertopic"){
     connectForum();
}

I have a very odd cookie problem that's hard to explain so please bare with me...

The first piece of code found below is the login process, where the login is checked and the cookie is created or not, the second piece of code below is a library which is called to display the login menu and get the connection to the database.

The problem I'm having is I cant put these 2 files in the same folder. The cookie gets created if i put the process login into a directory and the library into a sub directory called inc ... then i "include("inc/library.php");" in the login process. I then point the form for the login to http://www.alcaeos.com/blog/loginProcess.php...

If I do these 2 things then the cookie is created but if I place both files in the inc folder (The code below is the example of when both files are IN the inc folder) then the cookie does not get created. the login system still works and tells the user if they successfully logged in or not, it just wont create the cookie... It's an odd problem I think. Has anybody got any ideas... Thanks


Code: [Select]

<?php


include("library.php");



connectToDatabase();


$username = $_GET['username']; 
$password = $_GET['password'];

$sql = "SELECT * FROM theUsers WHERE user = '$username' AND pass = '$password';";

$result = mysql_query($sql) or die(mysql_error());  

if ($obj = mysql_fetch_object($result)) 
{
$expire=time()+60*60*24*30;
setcookie("shopusername",$username,$expire);
echo "<A HREF='http://www.alcaeos.com/blog/test.php'>You are logged in</A>";

}

else
{
loginScreen();
echo "You are NOT Logged In";
}

$db->close();

?>

Code: [Select]

<?php 

function loginScreen()
{

$output = <<<LOGIN
 
<FORM method ="GET" action="http://www.alcaeos.com/blog/loginProcess.php">
<table>
<tr>
<td>Username: </td>
<td><INPUT TYPE = "text" NAME = "username"></td>
</tr>
<tr>
<td>Password: </td>
<td><INPUT TYPE = "password" NAME = "password"></td>
</tr>
</table>

<INPUT TYPE="submit">
</FORM>

LOGIN;

echo $output;
}

function connectToDatabase()
{
$dbhost = 'mysql*******';
$dbuser = 'kem*******';
$dbpass = 'ya****';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');

$dbname = 'ke********';
mysql_select_db($dbname); 
}

I'm trying to get a remote html page but I'm having a really weird problem.
I'm using curl for that and I'm getting the page url from an rss item using simpelpie.

Code: [Select]
$url = $item->get_permalink();//simplepie function
echo "<p>Getting $url. </p>";
    $options = array(
        CURLOPT_RETURNTRANSFER => true,     // return web page
        CURLOPT_HEADER         => false,    // don't return headers
        CURLOPT_ENCODING       => "",       // handle all encodings
        CURLOPT_CONNECTTIMEOUT => 120,      // timeout on connect
        CURLOPT_TIMEOUT        => 120,      // timeout on response
        CURLOPT_MAXREDIRS      => 10,       // stop after 10 redirects
    );

    $ch      = curl_init( $url );
    curl_setopt_array( $ch, $options );
    $content = curl_exec( $ch );
    $err     = curl_errno( $ch );
    $errmsg  = curl_error( $ch );
    $header  = curl_getinfo( $ch );
    curl_close( $ch );

    $header['errno']   = $err;
    $header['errmsg']  = $errmsg;
    $header['content'] = $content;
    if($err != 0)
        echo " $err : $errmsg</p>";
    echo $header['content'];

My problem is that although the page is loading fine ( no curl errors ) , some tags are missing (and particularly the tags that containing the article content of that page).
When I'm hardcoding the url then everything is fine.
I tried to print the url that simpepie gets from rss and it's identical with the one that I'm harcoding.
So,

Code: [Select]
$url = $item->get_permalink();
not working

Code: [Select]
$url = "http://www.the_same_url.com"
working.

Any help whould be really appreciated.
Thanks in advance.

Hi!

To calculate my real time hours worked for/at a client I've made 3scripts, 1 to start the time, 1 to show the running time and 1 for stopping it.
The first and last are put into my hosted DB. I'm accessing them through SSH so that I don't need my laptop all the time.

Now here's the problem, when I start the time and I look into my DB I see the actual correct time and date (timestamp), but when I execute the script for stopping it the start time changes, so for example I started at 9:00, that time will be changed to for example 11:00 when I stop it... very strange, here are my scripts:

start:

<?php
date_default_timezone_set('Europe/Brussels');
$timestamp = date('Y-m-d H:i:s');
$conn = mysql_connect('server' 'user', 'pw') or die(mysql_error());
mysql_select_db('hystudi_timesheets', $conn) or die(mysql_error());
mysql_query("INSERT INTO timesheet (t_start_timestamp) VALUES ('$timestamp')", $conn) or die(mysql_error());
?>



stop:

<?php
date_default_timezone_set('Europe/Brussels');
$timestamp = date('Y-m-d H:i:s');
$conn = mysql_connect('server', 'user', 'pw') or die(mysql_error());
mysql_select_db('hystudi_timesheets', $conn) or die(mysql_error());
$records = mysql_query("SELECT id, t_start_timestamp FROM timesheet ORDER BY id DESC LIMIT 1");
while ($row = mysql_fetch_array($records)) {
        $id = $row['id'];
        $start_timestamp = date("U", strtotime($row['t_start_timestamp']));
}
$duration = (date("U", strtotime($timestamp)) - $start_timestamp) / 3600; // duration
mysql_query("UPDATE timesheet SET t_end_timestamp = '$timestamp', t_calculated_time = '".round($duration,2)."' WHERE id = $id", $conn) or die(mysql_error());
?>



Anyone sees what I'm doing wrong here? Or could it be my server? It's a shared host

I use my desktop (Windows) to make websites and then once it's completed transfer to my Linux server but I've come across a weird issue.

On Windows the file location is like this:

C:\Server\Apache\htdocs\RSCEmulation

On Linux the file location is like this:

/home/rscemulation/public_html

Now in those folders I have a folder called 'include', in that I have 2 files: header.php, functions.php

In the base folder I have index.php. I then include header.php by using: include "include/header.php";

Then I include functions.php (from header.php) by using: include "functions.php";

Now on Linux this chucks an error, even with "./functions.php" -- I have to use include "include/functions.php" even though I'm already in that directory from the file I'm calling it from, although admittedly the file is being included from the directory below but this works fine on Windows with a base PHP install.

This Linux box was given to me and I'm not sure if any PHP settings have been changed or not.

I also have a config.php that I keep below the public directory (htdocs or public_html) but it won't let me include it on the Linux server by using "../../config.php" (I've tried all levels ranging from 0-5 with no luck)

Can anyone shed some light on this please? I need it to work the same both on the Windows and Linux boxes as I copy and paste the files regularly and it's annoying changing them!

Cheers.

Hello guys, this is so weird, very weird indded!
PHP is generating some strange problem here over with me.
Below are a short context of code that I have used to make a registration script.
At the first inititial stage of code testing, everything goes well so smooth according to the plans. Then, I insert the Quote

exit;

function at the end of each Quote

If() functions

so as to curtail off completely from further execution of the script below and thereafter.  Then, suddenly all the !ISSET values stop to functions. I then removed exit(); function off from my code and restore back to the last known good working stage of my code. But it seems like the ISSET function accompanied with the !(stop operator) cease to fucntion any more ever since then even though the script exhibit the same code when it was working normally good. It makes me wonder and now i'm totally frustrated, Please help!!!

Now even all the operator values like ==, !=, <, > doesnt work anymore!!!

P.S.
I know someone would suggest me to write

Quote

if(!isset($_POST['Name']))

.........
in this format instead of Quote

$Name

but as i mentioned it earlier, i'm able to execute the script using the later one  as desired in accordance to what is planned.


Quote

<?php
$IP=$_SERVER['REMOTE_ADDR'];
$Date=date('d/m/Y');
$proID=$_GET['proID'];
$ref=$_GET['ref'];
$Name=$_POST['Name'];
$Email=$_POST['Email'];
$Country=$_POST['Country'];
$Username=$_POST['Username'];
$Password=$_POST['Password'];
$Con_Password=$_POST['Con_Password'];
if(!isset($Name))
{
 header ('Location: reenter.php');
   exit();
}
if(!isset($Email))
{
   header ('Location: reenter.php');
   exit();
}
if(!isset($Country))

I am extracting an array from the database in sorted form with respect to it's parent_id. Now I have to make a sub tree of this array in such a way that related nodes would be inserted in 'pages' field.

cleths->upper->shirts

Okay the problem is that it wont find the correct carrier. it dont even find it. i dont know whats wrong. Please take a look at the code. i dont know how to explain it better

$carriers = array('verizon'=>'@vtext.com','tmobile'=>'@tomomail.com','sprint'=>'@messaging.sprintpcs.com','att'=>'@txt.att.net','virgin'=>'@vmobl.com','textnow'=>'@textnow.me','metro'=>'@mymetropcs.com','unknown'=>'@teleflip.com');

if (array_key_exists($carrier, $carriers))

{

$correctCarrier = $carriers[$carrier];

$i = 0;

While($i < $_POST['amount'])

{

$i++;

$formatted_number = $to.$correctCarrier;

$result = ("$i of Your Messages Has been sent to the number ". $_POST['to'] . ".<br>" . mail("$formatted_number", "$subject", "$message") . "");

}

mysql_query("INSERT INTO `msgssent` (`number`, `numberofmsg`, `subject`, `message`) VALUES ('". $formatted_number ."', '". $i ."', '". $subject ."', '". $message ."')") Or die(mysql_error());

Echo $result;

}

Hey guys i have a table of pages set up with the possability of inserting pages inside pages. I am trying to make a delete button that would delete every child pages creating an array of page id's.

page 1
 L page 1.1
 L page 1.2
 L page 1.3
 L page 1.4
page 2

my code looks like this so fare

class delete_page
{

    function page($cat_id, $x = ''){
        
        $sql = mysql_query("SELECT * FROM pages WHERE parent='$cat_id' order by id asc");
        while ($select = mysql_fetch_assoc($sql)) {
            
            $this->x[] = $select['id'];
            $this->x = $this->page($select['id'], $this->x);
        }
        
        return $this->x;
        
    }

    function get_page($cat_id){
        return $this->page($cat_tid);
    }

}

$page = new delete_page;
$get_array_page = $page->get_page(1);

For some reason the above code sends me an array of all the pages in the database instead of returning only the child pages of the ID i inserted in the $get_array_page = $page->get_page(1)

Code: [Select]
Array
(
    [0] => 1
    [1] => 2
    [2] => 3
    [3] => 4
    [4] => 5
    [5] => 6
)
It should normaly return only

page 1
 L page 1.1
 L page 1.2
 L page 1.3
 L page 1.4

with out
page 2

like this

Code: [Select]
Array
(
    [0] => 1
    [1] => 2
    [2] => 3
    [3] => 4
    [4] => 5
)
What did i miss?

Hello All -

I have the following array:

Code: [Select]
array
  0 =>
    array
      'farmName' => string 'Hallinan' (length=8)
      'farmInsNum' => string '' (length=0)
      'farmFSA' => string '' (length=0)
  1 =>
    array
      'farmName' => string 'Holt' (length=4)
      'farmInsNum' => string '' (length=0)
      'farmFSA' => string '' (length=0)
  2 =>
    array
      'farmName' => string 'Holt' (length=4)
      'farmInsNum' => string '' (length=0)
      'farmFSA' => string '' (length=0)
  3 =>
    array
      'farmName' => string 'Holt' (length=4)
      'farmInsNum' => string '' (length=0)
      'farmFSA' => string '' (length=0)
  4 =>
    array
      'farmName' => string 'Holt' (length=4)
      'farmInsNum' => string '' (length=0)
      'farmFSA' => string '' (length=0)
  5 =>
    array
      'farmName' => string 'Holt' (length=4)
      'farmInsNum' => string '' (length=0)
      'farmFSA' => string '' (length=0)
  6 =>
    array
      'farmName' => string 'Home' (length=4)
      'farmInsNum' => string '' (length=0)
      'farmFSA' => string '' (length=0)
  7 =>
    array
      'farmName' => string 'Home' (length=4)
      'farmInsNum' => string '' (length=0)
      'farmFSA' => string '' (length=0)
  8
    array
      'farmName' => string 'Home' (length=4)
      'farmInsNum' => string '' (length=0)
      'farmFSA' => string '' (length=0)
The data comes from a flat file that has (as you can see) many of the same names like Home and Holt.  Is there a way to extract the first Holt and Home from the array and put those values in a new array?  So my new array would look something like:

Code: [Select]
array
  0 =>
    array
      'farmName' => string 'Hallinan' (length=8)
      'farmInsNum' => string '' (length=0)
      'farmFSA' => string '' (length=0)
  1 =>
    array
      'farmName' => string 'Holt' (length=4)
      'farmInsNum' => string '' (length=0)
      'farmFSA' => string '' (length=0)
  2 =>
    array
      'farmName' => string 'Home' (length=4)
      'farmInsNum' => string '' (length=0)
      'farmFSA' => string '' (length=0)

I look through php.net and really couldn't find a function that could handle what I was after.  I'm sure I'd have to use a combination of each() and reset() or maybe not?  Any help would be very welcome.  Thanks!

Hello all,

I think I have a simple question.  I have several arrays that I need the output from but I need the output from each array to be together.  I know WHAT?!

I'll try to explain:

I have a dynamic jQuery form that fills in a table with data.  Each "field" or <td> has separate information in each.  The way I output the data is in an input box so that I can capture the value of each.  The name attribute is the array for each input. So for example the output for each would look like this:

Code: [Select]
<tr>
  <td>
     <input type="text" name="fullName[]" value="input_from_user"/>
  </td>
  <td>
     <input type="text" name="Address[]" value="input_from_user"/>
  </td>
</tr>

If you can visualizes this we could have several rows of data from each array (fullName[] and Address[]).

How would I extract the data in such a way that I can clump them into their appropriate rows?  I know how to extract them one by one using foreach loop on each array but that won't do what I want.

I would like the output to be like this:

John Doe - 22 S Main Street
Jim Smith - 111 N Main Street
and so on...

This is what I have so far but I'm sure this isn't how to accomplish what I'm after.



$name = $_POST['fullName'];
$address  = $_POST['Address'];

$outputArry = array( "FullName" => $name, "Address" => $address );

foreach ( $outputArry as $output ) {

foreach ( $output as $row ) {

  $rowFullName = $row['FullName'];   
  $rowAddress = $row['Address'];
  
  $rowOutput .= 'Name: ' . $rowFullName . ' Address: ' . $rowAddress . '<br />';

}

}

         echo $rowOutput;




Thanks for any help on this issue.

Damian

I'm sure there must be a way to do whatI am after, as it seems like such an obvious thing to do, but I can't figure it out.

1. I have an array which contains a list of database's and their connections

$slaveRes_array[0] = array('server' => 'localhost:3306',
                             'user' => $u,
                             'password' => $p,
                             'database' => 'MySQL01_5083',
                             'sendmail' => '0',
                             'repeat' => '0',
                             'dbID' => '1'
                                           );
and so on 10 times


I then have a list of MySQL Queries: (at the moment there is only one, but there will be more later on).

$query_array[] = array( 'query1' => "SHOW SLAVE STATUS");


The idea is that I take the first database from $slaveRes_array, connect to it, and run each query from the $query_array in turn against that database, and ultimately pass that resultset into an array that I can refer back to later on.

Within $slaveRes_array I have a DB name (e.g. MySQL01_5083), I want this to be the first entry in my resultset array, so I can reference this.

However, not all database's will return a result.

So what I want to end up with is something like:

=> Array ( [name] => MySQL02_5083 )
                    ( [Slave_IO_State] => Waiting for master to send event)...

(in this case the first server (MySQL01) didn't return a result, so the first item in the array is MySQL02.

I have found lots of ways to achieve bits of this, but none that work together.

I can get a list of database names that returned a result, but can't get the data to return to the array (or any array).

I can get the data into an array, but not the database names.

Surely this must be something straight forward that people do all the time, right?