PHP - Strange Syntax Problem(large Array Declaration)

Hi there i have an array that catches all appropriate records from my database and selects a random row which is then outputted as a hyperlink.

Code: [Select]
$colname_Class3 = "3";
$colname_Ships3 = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_Ships3 = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_swb, $swb);
$query_Ships3 = sprintf("SELECT * FROM ships WHERE PlayerName = %s AND Class=%s AND Template='1'", GetSQLValueString($colname_Ships3, "text"),
GetSQLValueString($colname_Class3, "int"));
$Ships3 = mysql_query($query_Ships3, $swb) or die(mysql_error());
$totalRows_Ships3 = mysql_num_rows($Ships3);

$count = 0;
while ($row = mysql_fetch_assoc($Ships3)){
$array[$count]['ShipID'] = $row['ShipID'];
$array[$count]['ShipName'] = $row['ShipName'];
$array[$count]['Class'] = $row['Class'];
$count++;
}

$total3 = count($array3);
$random3 = rand(0,$total3 - 1);
$random_ship3 = $array3[$random3];
$ShipID3 = $random_ship3['ShipID'];
$url3 = '<a href="add_ship.php?recordID='.$ShipID3.'">Test3</a>';
echo '<span style="color: #009900">';
echo $url3;}

This all worked fine until i added another similar query:
Code: [Select]
$colname_Class4 = "4";
$colname_Ships4 = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_Ships4 = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_swb, $swb);
$query_Ships4 = sprintf("SELECT * FROM ships WHERE PlayerName = %s AND Class=%s AND Template='1'", GetSQLValueString($colname_Ships4, "text"),
GetSQLValueString($colname_Class4, "int"));
$Ships4 = mysql_query($query_Ships4, $swb) or die(mysql_error());
$totalRows_Ships4 = mysql_num_rows($Ships4);

$count = 0;
while ($row = mysql_fetch_assoc($Ships4)){
$array[$count]['ShipID'] = $row['ShipID'];
$array[$count]['ShipName'] = $row['ShipName'];
$array[$count]['Class'] = $row['Class'];
$count++;
}

$total4 = count($array4);
$random4 = rand(0,$total4 - 1);
$random_ship4 = $array4[$random4];
$ShipID4 = $random_ship4['ShipID'];
$url4 = '<a href="add_ship.php?recordID='.$ShipID4.'">Test4</a>';
echo $url4;}

On first look it seems fine, however once the page is refreshed the parsed recordID's both become the same number,
e.g: Test3 recordID 8 Test4 recordID 24
then after refreshed: Test3 recordID 24 Test4 recordID 24

Is there anything wrong with my code??

Thanks

I am working with the Amazon API, and I am trying to display a default image if a product does not have an image associated with it.  The query is coming back as an array.  Typically, each product image array looks like this:

$d = SimpleXMLElement Object ( http:// => [url]http://ecx.images-amazon.com/images/I/51aUIul6XjL._SL160_.jpg [Height] => 160 [Width] => 112 )

The code goes like this:

Code: [Select]
if ($d=$E->MediumImage)
            {
                $iu=$d->URL;
                $ih=$d->Height;
                $iw=$d->Width;
               
                echo count($d);
               
                if (strlen($iu) > 0)
                {echo "<center><a href='$url' target='_blank'><img src='images/amazon_noimage.jpg' width='175' height='175' border='0'></a></center>";}
                else
                {echo "<center><a href='$url' target='_blank'><img src='$iu' width='$iw' height='$ih' border='0'></a></center>";}
            }
However, images/amazon_noimage.jpg never shows up (even though it is linked correctly, as I've tested this link).  I have tried the following:

if (strlen($iu) > 0)
if (count($iu) > 0)
if (strlen($d->URL) > 0)
if (count($d->URL) > 0)
if (isset($d))
if (!isset($d))
etc ...

If I display the following, where there is no image, I get nothing displayed:

echo $iu;
print_r($iu);
echo $d->URL;
etc ...

However, if there is an image, I get a link, such as the following:

http://ecx.images-amazon.com/images/I/51c2BFpDN0L._SL160_.jpg

There seems to be NOTHING that I can do to trigger the 'ELSE' part of the if statement.  This is a total enigma to me ... any ideas??

Hi,
I am performing some whois query using phpwois.
http://www.phpwhois.org/


So after doing its object output i.e.
Code: [Select]
$whois = new Whois();
$result = $whois->Lookup($domain);
$winfo = '';
$utils = new utils;
$winfo = $utils->showHTML($result);




, I am getting following data for for phpfreaks.com>
Code: [Select]
regrinfo->Array
 domain->Array
  name->phpfreaks.com
  nserver->Array
   ns1.serverpowered.net->204.13.168.4
   ns2.serverpowered.net->216.12.222.4
   ns3.serverpowered.net->66.97.171.74
   ns4.serverpowered.net->66.97.171.254
  status->Locked
  changed->2011-08-29
  created->2001-10-11
  expires->2016-10-11
 registered->yes
 owner->Array
  name->Web Freaks
  address->Array
   0->Contact Administrative ()
 admin->Array
  email->domains@thewebfreaks.com
  name->Contact Administrative
  phone->4072751117
  fax->+1.4072757706
  address->Array
   0->Web Freaks
   4->3700 Commerce Blvd
   5->Suite 154
   6->Kissimmee, FL 34741
   7->US
 tech->Array
  email->domains@thewebfreaks.com
  name->Contact Administrative
  phone->4072751117
  fax->+1.4072757706
  address->Array
   0->Web Freaks
   4->3700 Commerce Blvd
   5->Suite 154
   6->Kissimmee, FL 34741
   7->US
regyinfo->Array
 registrar->ENOM, INC.
 referrer->http://www.enom.com
 servers->Array
  0->Array
   server->com.whois-servers.net
   args->domain =phpfreaks.com
   port->43
  1->Array
   server->whois.enom.com
   args->phpfreaks.com
   port->43
 type->domain


Now I want to show Domain registrar (Enom, INC.)

So I did following

Code: [Select]
echo $winfo['regyinfo'];

Now above code shows following >>
Code: [Select]
registrar->ENOM, INC.
referrer->http://www.enom.com
servers->Array
 0->Array
  server->com.whois-servers.net
  args->domain =phpfreaks.com
  port->43
 1->Array
  server->whois.enom.com
  args->phpfreaks.com
  port->43
type->domain

To obtain I mean to show ENOM, INC, I used following >

Code: [Select]
echo $winfo['regyinfo']['registrar'];
But it gave error, so I used following >>
Code: [Select]
$temp = $winfo['regyinfo'];
echo $temp['registrar'];

But it give output as follows :

<


I dont know what wrong I am doing ?
If it is showing regyinfo, then it should also show registrar.

Thanks

Hi..

I create mysql syntax for query testing before i input to my php code

here is my mysql code:

Code: [Select]
set @t = 0;
set @rqty=31968;
SELECT LOT_CODE as code,  DATE_ENTRY,   
CASE WHEN @t+OUTPUT_QTY > @rqty
THEN @rqty  -@t 
ELSE OUTPUT_QTY
END as qty,
@t := @t + d.OUTPUT_QTY as cumulative   
FROM dipping d  WHERE SUBSTR(LOT_CODE, 9,4) = 'P28' AND (@t < @rqty);

and i attach the sample output of the above query.

Now that query test is work i  will input that code to my php codes.


     $sql = "SELECT SKUCode, Materials, Comp, Qty 
     FROM bom  WHERE SKUCode = '$SKUCode'";
     $res = mysql_query($sql, $con);

    ($row = mysql_fetch_assoc($res));
     $Materials = $row['Materials'];
     $Qty = $row['Qty'];
     $Comp = $row['Comp']; //P28
//-----Compute Req Qty and Save to table---//     

     $ReqQty = $Qty * $POReq; // 31968


     
$sql = "UPDATE bom SET ReqQty = '$ReqQty' WHERE SKUCode = '$SKUCode' AND Materials = '$Materials'";
$resReqQty = mysql_query($sql, $con);

$t = 0;

$sql = "SELECT LOT_CODE as code,  DATE_ENTRY,   
CASE WHEN $t+OUTPUT_QTY > $ReqQty 
THEN $ReqQty  -$t  
ELSE OUTPUT_QTY 
END as qty,
$t := $t + d.OUTPUT_QTY as cumulative   
FROM dipping d  WHERE SUBSTR(LOT_CODE, 9,4) = '$Comp' AND ($t < $ReqQty)";



when I echo the query:

I got this:

 SELECT LOT_CODE as code, DATE_ENTRY, CASE WHEN 0+OUTPUT_QTY > 31968 THEN 31968 -0 ELSE OUTPUT_QTY END as qty, 0 := 0 + d.OUTPUT_QTY as cumulative FROM dipping d WHERE SUBSTR(LOT_CODE, 9,4) = 'P28' AND (0 < 31968)

then I run it to the sql

and I got an error:

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':= 0 + d.OUTPUT_QTY as cumulative FROM dipping d WHERE SUBSTR(LOT_CODE, 9,4) = '' at line 1
(0 ms taken)


Any help is highly appreciated

Thank you so much

Quick question,

When I run the code below I get an undefined index error for the array.  If I define all the indexes I have no problem making it work correctly.   I thought writing it like I did below would define the indexes as they are needed.   What am I doing wrong?

Thanks for looking,


$call_data = array();

if($call_segment['did_digits'] == '3300'){
//Check if call was answered
if($call_segment['answered'] == 'No'){
$call_data['3300']['abandoned'] ++;
}
else{
if(in_array($call_segment['finished_on'],$phoneroom_ext)){
$call_data['3300']['phoneroom'] ++;
}
elseif(in_array($call_segment['finished_on'],$anoka_ext)){
$call_data['3300']['store'] ++;
}
}
}

Hey guys,

First of all thanks in advance for all the help you can give me. I'm using a php shopping script called plaincart to create a webstore. All is fine but the admin part is not working properly.  When i go to http://localhost/admin it redirects to http://localhost/admin/admin/login.php

The index.php is in the root of the server and the admin files are in a folder called admin... What is wrong?
Please tell me if you need any code.
Thank you

Ok, not sure what the problem is....hard to explain.   I am trying to setup a login script but I get the normal: Warning: session_start() [function.session-start]: Cannot send session cache limiter error code.  I have no white space above to cause problem.  I have used this same code written by Jpmaster77 on a number of sites.  What the strange thing is it also messed up a couple of my css text boxes.   

See the difference: 
http://www.monstersgonewild.ca/index.php - Problem
http://www.monstersgonewild.ca/index1.php - Without session()

I would post the code of the original page but it is 600+lines and growing.

Anybody have any ideas?

Im installing and testing a web application, and im having a strange bug that annoyes me because it dint have any sense and also it dont affects really to the web functionality:



if($_POST["eliminar"]==""){

$consulta='SELECT * FROM impressora where Activa=0';

$result=mysql_query($consulta,$conexion);

echo"<table align=CENTER class='sample'>";

echo"<p align=center>LLISTA D'IMPRESSORES INACTIVES.</p>";

printf("<th>MODEL</th><th>MARCA </th>");

while($fila=mysql_fetch_array($result,MYSQL_ASSOC)){

echo"<tr>";

echo "<td>" . $fila["Model"] . "</td>";

echo "<td>" . $fila["Marca"] . "</td>";

echo"</td>";

if($_SESSION["admin"]!=0){ 
?>

<form method= "post" ACTION="impressores_inactives.php?idr=<?php echo($fila["Id_impressora"])?>">

<td colspan="2"><INPUT TYPE ="SUBMIT" NAME="eliminar" VALUE="Eliminar"></td>

</form></td>
<?php

}

echo "</tr>";

}

echo"</table>";

}else{

echo 'eliminado';
echo $_POST["eliminar"];

//BORRAMOS DE LA BBDD LA IMPRESSORA

$consulta="delete from impressora where Id_impressora='".$_GET["idr"] ."'";

$result=mysql_query($consulta);

echo "<meta http-equiv=Refresh content=\" ; url=../Impressores/impressores_inactives.php\">"; 
}

The problem is that php say that eliminar is undefinded, and if i test $_POST it says its empty. See that eliminar is the name of the submit post and its checked for a function that deletes a item.

The problem is that script is actually working. I can delete the printer  but with that error... and if i test the value of eliminar is always empty.

Ask for any other explanation without a problem , the code is in spanish.

Hi, I have an output of print_r he

Google_Service_Calendar_Acl_Resource Object
(
    [stackParameters:Google_Service_Resource:private] => Array
        (
            [alt] => Array
                (
                    [type] => string
                    [location] => query
                )

            [fields] => Array
                (
                    [type] => string
                    [location] => query
                )

            [trace] => Array

I am wondering what is the right syntax to create the instance and set the variables? Thanks, Ted

Hi all!

Firstly, I'd like to say a big hello to everyone

Right, so I have a bit of a strange problem.  I get no error, but my page stalls.

So here's what I've got, a simple alphabet (A-Z) in capitals at the top of the page, created by:


$alphabet = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z');

// then further down the page I have it looped as so:
<?php foreach($alphabet as $link): ?>
    <a href="suppliers.php?filter=<?php echo $link; ?>">
        <?php echo $link; ?>
    </a> | 
<?php endforeach; ?>


So that's all cool.  I then have this at the top of the page:


$the_suppliers = (isset($_GET['filter']) && preg_match("/[^A-Z]*/",$_GET['filter'])) ? $suppliers -> get_all($_GET['filter']) : $suppliers -> get_all('all');



Now I have preg_match() in there as I was using ctype_alpha() to check for only alphabetical chars, and thought that might be my problem, but still get it with preg_match();

Anyway, my class method (get_all()) is:


                    public function get_all($filter){

global $database;

if($filter == 'all'){

$sql = "SELECT * FROM " . self::$table . " WHERE on_web = 1 ORDER BY RAND() LIMIT 10";

}else{

$sql = "SELECT * FROM " . self::$table . " WHERE on_web = 1 AND LEFT(name,1) = '" . $database -> sql_prep($filter) . "'";

}

return self::find_by_sql($sql);

}


Now this works fine for b-z, but for some reason when the filter=A it just hangs.....  I have ran the sql in phpmyamin and it returns the result straight away, so I know it's not the sql.

Does anyone here know where I might be going wrong here?  It's very odd and I've never come across this before, and not getting an error doesn't really help much.

Any suggestions or pointers will be gratefuly received

Hi. I have to check if a session is started or not, and then, check for the rank of the user. For that i use two functions like is_administrator,etc.

Well, but this isnt working. I cant get any clear way to know if a session have been already started or not.
Code: [Select]
function is_administrator() {
session_start();
if (isset($_SESSION['usr']) and empty($_SESSION['usr'])) {

$l = conect();
$user = $_SESSION['usr'];
$cons = "SELECT * FROM `users` WHERE usr='" . $user . '\';';
$res = mysql_query ($cons,$l);
$ob = mysql_fetch_array($res);

if ($ob['tipo'] == 'A') {
return true;
}

}
return false;
}

What i want to do is to check if a sesion exist, if not, return false. If the sesion exist, check for the user rank and return true/false.

Hi,

I get this error when I load the page, but after hitting ctrl f5 to refresh.. the error goes away and the page works perfectly.  I have edited out my details.

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'user'@'localhost' (using password: YES)
Access denied for user 'user'@'localhost' (using password: YES)

I know everything is set right.. I just don't get it.. I am going crazy of this. Ive cleared my browser cache.. even tried it on my android phone and it does the same thing.

Thanks,
Deceevn

I have done a simple insert query on a comment system but it works once and when i go back and try add another record it just doesnt work at all.

Code: [Select]
<?php 

include ("class.database.connection.php");   // the database connection class
include ("settings.config.php");  // hostname, password ect

$name = $_POST["UserName"];
$email = $_POST["UserEmail"];
$comment = $_POST["UserComment"];

$sql="INSERT INTO comments (name, email, comment)VALUES('$name', '$email', '$comment')";
$result=mysql_query($sql);


?>
if anyone can help me with this i would be a happy chappy!

Hi,
I was using latest php5 but as I couldn't find a ffmpeg-php extension for it, I actually swapped to latest php4, and now I'm having a problem when using fopen for urls, when it's used it just stops the script with no error / warning, i tried using the same php.ini used with my php5 too but it changes nothing.
Btw allow_url_fopen is enabled.
Thanks if someone can help.

OK, this is a strange one I am hoping someone can help with.

I have a file with a heap of functions which work fine. This file is included in my other files, and the function to display the content is called. For example I include the master file in guestbook.php, which calls showGuestbook(). Same with contact.php, it calles showContact(); etc.

The file is outside the web root of the website calling it.

So I went to add another function called downloadFile(). When I try to call the function, it gives me the "call to undefined function" error. I have tried renaming it to a few diff things, same error. So I thought there could be a brace error somewehere in the file. This is the strange bit.... When I put that function at the top of the file, the page seems to fail to parse. None of the functions are available...

The function so far is simply:
function downloadFile()
{
echo "Download File";
}


Can anyone shed some light on this strange behaviour, especially the errors that occur just because I move the code higher up the file.