PHP - The Php Code Works But I Have No Variables Returned

I have some code that works fine on my dev server but does not work on my production server.  Dev server has PHP version 5.2.5 and production server has PHP version 5.1.6.

This is the part of the code that isn't working on the prod. server:
$xmlDoc=new DOMDocument();
$xmlDoc->loadXML($tmpDoc);

$x=$xmlDoc->getElementsByTagName('link');

//get the q parameter from URL
$q=$_GET["q"];

//lookup all links from the xml file if length of q>0
if (strlen($q)>0)
{
$hint="";
for($i=0; $i<($x->length); $i++)
{
$y=$x->item($i)->getElementsByTagName('title');
$z=$x->item($i)->getElementsByTagName('url');
if ($y->item(0)->nodeType==1)
{
//find a link matching the search text
if (stristr($y->item(0)->childNodes->item(0)->nodeValue,$q))
{
     if ($hint=="")
     {
     $hint="<tr><td><a href='" .
         $z->item(0)->childNodes->item(0)->nodeValue .
        "' target='_blank'>" .
        $y->item(0)->childNodes->item(0)->nodeValue . "</td></tr>";
     }
     else
    {
     $hint=$hint . "<tr><td><a href='" .
         $z->item(0)->childNodes->item(0)->nodeValue .
         "' target='_blank'>" .
         $y->item(0)->childNodes->item(0)->nodeValue . "</a></td></tr>";
     }
}
     }
   }
}

$tmpDoc is a variable that holds database information in xml form.  It basically looks like this:
$tmpDoc = $tmpDoc . "<link><title>" . $row['CustomerName'] . "****" . $row['Rep'] . "****" . $row['InstallDate'] . "****" . $row['PaidDate'] .  "</title><url>accountPage.php?AccNum=" . $row['AccountNum'] . "</url></link>";

...that is inside a while loop that loops through the rows returned by a query.

Basically, as I said, the whole thing works fine on my dev server but on the production server it never makes it into the for loop so I guess the condition $i<($x->length) isn't being met.  I'm at a bit of a loss here.  Is there anything like the PHP version or Apache version that may cause the "->" operator to not work?  The prod PHP version isn't that much older than my dev PHP version so I doubt that's the issue but it's about all I can think of.

Thanks!

Hi all, Having an issue with some of my php code. The goal is to have two drop-down menus, one that pulls from "ahevents_scenarios". The second pulls the "sides" involved, however it does not go into dropdown. The other issue is that even though there are only 3 sides specified, all 5 show up on the webpage. This is in Joomla.     Here is my code...I think I've looked over this way too much and just can't find my errors anymore.

<?php



if (! $my->id) {

  // shouldn't even get here since menu is viewable only through logged in status

print "<b>Sorry, you must be registered and logged into this site to continue</b>\n";

}

else {



// include standard functions and db info

require_once($_SERVER['DOCUMENT_ROOT'] . "/inc/admin_functions.php");

require_once($_SERVER['DOCUMENT_ROOT'] . "/inc/db_admin_functions.php");



// which scenario we doing?  -- replace with table lookup in future



opendb('ahevents_scenarios');



if(!isset($_POST['action'])) { // display form

    $sqlstr2 = "select id, name from scenarios order by name";

    $result2 = mysql_query($sqlstr2) or die("Error: ".mysql_error()."<br>Query: $sqlstr2");

  // display form

?>



<form name="edit_reg" method="post" action="<? echo $_SERVER[ 'REQUEST_URI' ]; ?>"

<table>

<tr>

<td>Select Scenario: </td>

<td>

<select name="id">

<? while ( $row = mysql_fetch_array($result2)) {

    printf("<option value=\"%s\">%s</option>\n",$row['id'], $row['name']);

}

?>

</td></tr>

<tr>

<td>Which Side?</td>

<td><select name="side">

<option value="side_1">side_1</option>

<option value="side_2" >side_2</option>

<option value="side_3" >side_3</option>

<option value="all" selected>All</option>

</select>

</td></tr>

</table>

<p>

<input type="submit" name="action" value="Get Registrants">&nbsp;

<input type="reset" value="Reset">&nbsp;

<input type="button" name="" value="Back" onClick="history.back()">

</form>

The goal is to download the registrants into a .csv file, which it does, however due to not being able to select a "side", the .csv is blank with only headers, no content.   Thanks for your time Rob

Hi,

I'm having a first attempt at sanitising code, but I'm not actually sure what I'm doing and how I know if it works.

This is the code I have inserted, if I enter "description=re#d%widget" the description query ends so it displays everything 'red'.  Not just everything 'red widget'.


Code: [Select]
$description = mysql_real_escape_string($description);
$description = stripslashes($description);
$description = htmlentities($description);
return $var;

$price = mysql_real_escape_string($price);
$price = stripslashes($price);
$price = htmlentities($price);
return $var;




Code: [Select]
<?php

ini_set('display_errors', 1);
error_reporting(-1);



$query = "SELECT * FROM productfeed";

if(isset($_GET['description']) && !empty($_GET['description']))
{
$description = $_GET['description'];
$query .= " WHERE description like '%$description%'";
}

if(isset($_GET['price']) && !empty($_GET['price']))
{
$price = explode('-', $_GET['price']);
$lowPrice = (int)$price[0];
$highPrice = (int)$price[1];

$query .= " AND price BETWEEN $lowPrice AND $highPrice";
}


$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))

{

$id = $row['id'];
$image = $row['awImage'];
$link = $row['link'];
$description = $row['description'];
$fulldescription = $row['fulldescription'];
$price = $row['price'];

echo "<div class='productdisplayshell'>
<div class='productdisplayoutline'>
<div class='productborder'><center>
<a href='$link' target='_blank'><img src='$image' width=\"95%\" /></a>
</center> </div></div>
<div class='productdescriptionoutline'>
<div class='productdescriptionbox'>
<a href='$link' target='_blank' >$description</a>
</div>
<div class='productfulldescriptionbox'>$fulldescription</div>
</div>
<div class='productpriceoutline'>
<div class='productpricebox'>
<center>&#38;#163; $price</center>
</div>
<div class='productbuybutton'>
<center><a href='$link' target='_blank' ><img src=/images/buybutton.png /></a></center>
</div>
</div>
</div>";
} 

if ($_GET['description'] == $description ) {
echo 'Sorry, this product is not available.  Please visit our <a href="http://www.domain.co.uk">Homepage</a>.';
}


?>

<?php
function sanitizeString($description)
{
$description = mysql_real_escape_string($description);
$description = stripslashes($description);
$description = htmlentities($description);
return $var;

$price = mysql_real_escape_string($price);
$price = stripslashes($price);
$price = htmlentities($price);
return $var;


}
?>

Greetings to all!

Newbie here, I just signed up this morning. I have an issue with a code I have been using for several years with multiple files/directories. Until recently all of the files have worked flawlessly. Now I have one file in a directory that does not display the text I which I am attempting to call up and it was working until recently.

As stated above I have the same code in multiple directories and files and it works flawlessly in all files except for the one. I have spent a few hours attempting to remedy the situation with no success. I have looked at the source code for the errant file and that shows the text to be displayed but it is not displayed in any browser on several computers, whether Windows or Mac OSX. I even went so far as to delete the directory the file was in and re-uploaded the entire directory from a backup that is 2 or 3 years old, no change. I copied the entire coding from a working file with the same coding, deleted all the coding in the errant file and pasted the working coding into the errant file. - no change

I have attached screen shots of the coding in errant file and one of many other files that work flawlessly with the php code that is involved highligted. Also attached are the browser page source files for the same errant and working files. The screen shots in order are errant file code, working file code, errant file source, and working file source.

Every file with the same code as the errant one work flawlessly except for the errant one, and I have 11 files to be displayed on my website at https://TheLoveOfGod.org They are all listed under the Devotionals menu button except for one which is displayed on the home page. I have absolutely no training in web design, I am self taught. I began by hand typing html coding over 30 years ago and am now using Word Press with Elementor . I do not understand why this is happening. Can any of you offer assistance to resolve this. I thank you in advance for your assistance.

Respectfully,
dan

 

Edited September 25, 2020 by namednad
more explanation

I have made a bit of code that queries the database for articles published within the last year.

<?php echo $numposts = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish' AND post_type = 'post' AND 'post_date' > '" . date("Y") . "-01-01-01 00:00:00'");
if (0 < $numposts) $numposts = number_format($numposts); ?>

I really don't even know how it works and need to because I want to figure out how to make it also get articles published within the last day, month and week.

I suppose if I understood what needs changing I might be able to work with it but so far everything I've tried either returns the exact same number or nothing at all.

It's for Wordpress just to note.

Any ideas?

Dear php freaks,

In my test file the following code works perfectly:

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml">
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 <script language="javascript" type="text/javascript">
 function dropdownlist(listindex)
 {
 
document.formname.subcategory.options.length = 0;
 switch (listindex)
 {
 
case "1" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 
break;
 
case "2" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 
break;
 
case "3" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 
break;

case "4" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 
break;

case "5" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 
break;

case "6" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 document.formname.subcategory.options[7]=new Option("6","6");

break;

case "7" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 document.formname.subcategory.options[7]=new Option("6","6");
 document.formname.subcategory.options[8]=new Option("7","7");
break;

case "8" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 document.formname.subcategory.options[7]=new Option("6","6");
 document.formname.subcategory.options[8]=new Option("7","7");
 document.formname.subcategory.options[9]=new Option("8","8");
break;

case "9" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 document.formname.subcategory.options[7]=new Option("6","6");
 document.formname.subcategory.options[8]=new Option("7","7");
 document.formname.subcategory.options[9]=new Option("8","8");
 document.formname.subcategory.options[10]=new Option("9","9");
break;

case "10" :
 document.formname.subcategory.options[0]=new Option("Select kinderen thuis","");
 document.formname.subcategory.options[1]=new Option("0","0");
 document.formname.subcategory.options[2]=new Option("1","1");
 document.formname.subcategory.options[3]=new Option("2","2");
 document.formname.subcategory.options[4]=new Option("3","3");
 document.formname.subcategory.options[5]=new Option("4","4");
 document.formname.subcategory.options[6]=new Option("5","5");
 document.formname.subcategory.options[7]=new Option("6","6");
 document.formname.subcategory.options[8]=new Option("7","7");
 document.formname.subcategory.options[9]=new Option("8","8");
 document.formname.subcategory.options[10]=new Option("9","9");
 document.formname.subcategory.options[11]=new Option("10","10");
 
break;
 
}
 return true;
 }

 </script>
 </head>
 <title>Dynamic Drop Down List</title>
 <body>
 
<form id="formname" name="formname" method="post" action="submitform.asp" >
 <table width="50%" border="0" cellspacing="0" cellpadding="5">
 <tr>
 <td width="41%" align="right" valign="middle">Aantal kinderen :</td>
 <td width="59%" align="left" valign="middle"><select name="category" id="category" onchange="javascript: dropdownlist(this.options[this.selectedIndex].value);">
 <option value="">------</option>
 <option value="1">1</option>
 <option value="2">2</option>
 <option value="3">3</option>
 <option value="4">4</option>
 <option value="5">5</option>
 <option value="6">6</option>
 <option value="7">7</option>
 <option value="8">8</option>
 <option value="9">9</option>
 <option value="10">10</option>
 </select></td>
 </tr>
 <tr>
 <td align="right" valign="middle">Waarvan thuiswonend :
 </td>
 <td align="left" valign="middle"><script type="text/javascript" language="JavaScript">
 document.write('<select name="subcategory"><option value="">-----</option></select>')
 </script>
 <noscript><select name="subcategory" id="subcategory" >
 <option value="">Select Sub-Category</option>
 </select>
 </noscript></td>
 </tr>
 </table>
 
</form>
 
 
</body>
 </html>
 


When i want to implement it in my signup page, it doesnt do anything. I've checked it a thousand times, i double checked that also the

-formname of my signup page is 'formname'
-the element name stays 'subcategory'

I really need this to be implemented. Where can be the problem? What should i look for?

Hi all,
I am a bit of a noob when it comes to website building and php etc so please have patients with me I am learnig as I go.

I have come across this problem before and cannot remember what I did to fix it but any way it is presenting its self to me again.

I have this page: http://minecraftcons...a.com/index.php with an include file loading random images, however the same code on these pages:
http://minecraftconsolecrafting.comxa.com/sections/build-navi.php
http://minecraftconsolecrafting.comxa.com/sections/springhill-kingdom-01.php
are not working.

I have other websites that this method of coding is working fine on for example here is another of my websites:
http://divinegardensandlandscapes.com/index.php here the include code for random image loader is working fine on all pages it appears on so what is happening when this fail takes place?

Any help and or advice would be hugely appreciated, Thanks in advance.

Please remeber I am a noob when answering. Thanks
Edited by eGate-Network, 12 July 2014 - 10:55 PM.

Hi,

I have some code which works but when I created a function and call this same code it doesn't. The error I get is as follows:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/fhlinux010/l/languageschoolsuk.com/user/htdocs/admin/email.php on line 42
Error retrieving schools

The code
function CreateSchoolCheckboxes()
{
echo '<div style="height:400px;width:400px;font:16px/26px Georgia, Garamond, Serif;overflow:scroll;">';

$querySchools = "SELECT * FROM school";
$result = mysql_query($querySchools, $conn)
or die ("Error retrieving schools ".mysql_error());

while($row = mysql_fetch_array($result))
{
$schoolname = $row['name'];    
echo '<input type="checkbox" name="school" value="'.$schoolname.'">';
echo $schoolname . '<br>';
}      

echo '</div>';
}

Im sure that this is probably something simple but any suggestions would be much appreciated.

Thanks,
Joe

PHP = 5.5.14 MySQL = 5.2.17   This simple .php script works as a standalone OK:

<?php

require '<snip partial URL>mysqli.php';

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$result = mysqli_query($con,"SELECT `callsign`, `qth`, `submitted` FROM `lqplogs` ORDER BY `callsign`");

echo "<table>
<tr>
<th><u>CALLSIGN</u></th><th><u>QTH</u></th><th><u>LOG SUBMITTED</u></th>
</tr>";


while($row = mysqli_fetch_array($result)) {
  echo "<tr>";
  echo "<td>" . $row['callsign'] . "</td>";
  echo "<td>" . $row['qth'] . "</td>";
  echo "<td>" . $row['submitted'] . "</td>";
  echo "</tr>";
}

echo "</table>";

mysqli_close($con);
?>

A separate .html page with other info works by itself OK too, but when I try to embed the PHP script (with PHP start & end tags, of course)  *between* these HTML tags:   <table> <tr> <td>   ... Full PHP Script Embedded here...   </td> </tr> </table>   I get this mess:

"; while($row = mysqli_fetch_array($result)) { echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
CALLSIGN	QTH	LOG SUBMITTED
" . $row['callsign'] . "	" . $row['qth'] . "	" . $row['submitted'] . "
"; mysqli_close($con); ?> 

Any thoughts as to why are appreciated.   Thanks!   - FreakingOUT    

Code: [Select]
<?php
$objConnect = mysql_connect("localhost","","cgdfgdfg") or die(mysql_error());
$objDB = mysql_select_db("ffdfvbbd");
$pic2 = "SELECT * FROM images";
if (!isset($_GET['Page'])) $_GET['Page']='0';
$pic1 = mysql_query($pic2);
$Num_Rows = mysql_num_rows($pic1);
$Per_Page = 16;   // Per Page
$Page = $_GET["Page"];
if(!$_GET["Page"])
{$Page=1;}
$Prev_Page = $Page-1;
$Next_Page = $Page+1;
$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{$Num_Pages =1;}
else if(($Num_Rows % $Per_Page)==0)
{$Num_Pages =($Num_Rows/$Per_Page) ;}
else
{$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;}
$pic2 .="ORDER by thumbnailID DESC LIMIT $Page_Start , $Per_Page" ;
$pic1  = mysql_query($pic2);
$cell = 0;
$link1 = "SELECT * FROM images";
echo '
    <div id="tablediv">
      <table border="0" cellpadding="17" cellspacing="0" class="table">
        <tr>';

  while($pic = mysql_fetch_array($pic1)) {

    if($cell % 4 == 0) {
      echo '</tr><tr>';
    }

    if($cell == 2) {
      echo '
        <td>
          filler
        </td>';
    } elseif ($cell == 3) {
      echo '
        <td>
          filler
        </td>';
    } else {
      echo '
        <td>
          <a href="/' . $pic["link"] . '.php">
            <div class="image">
              <img src="https://s3.amazonaws.com/images/' . $pic["pic"] . '.png" 
                   alt="' . $pic["alt"] . '" 
                   height="200" 
                   width="200" 
              />
            </div>
          </a>
        </td>'; 
    }
    $cell++;
  }
  echo '</tr></table></div>';
?>The code above works just fine.

However, once I add a WHERE function,as shown below, I get a "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource" error.

Code: [Select]
<?php
$objConnect = mysql_connect("localhost","","cgdfgdfg") or die(mysql_error());
$objDB = mysql_select_db("ffdfvbbd");
$pic2 = "SELECT * FROM images WHERE folder = 'blog' "; //WHERE FUNCTION IS HERE
if (!isset($_GET['Page'])) $_GET['Page']='0';
$pic1 = mysql_query($pic2);
$Num_Rows = mysql_num_rows($pic1);
$Per_Page = 16;   // Per Page
$Page = $_GET["Page"];
if(!$_GET["Page"])
{$Page=1;}
$Prev_Page = $Page-1;
$Next_Page = $Page+1;
$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{$Num_Pages =1;}
else if(($Num_Rows % $Per_Page)==0)
{$Num_Pages =($Num_Rows/$Per_Page) ;}
else
{$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;}
$pic2 .="ORDER by thumbnailID DESC LIMIT $Page_Start , $Per_Page" ;
$pic1  = mysql_query($pic2);

My mysql table includes column thumbnailID   folder   link   pic   alt   time

The folder column is there so I can specify what I want in the page.

Anyhow, why won't it work?

Hello everyone,

I'm having this problem which is really annoying, tried to solve it but couldn't, I write that code in PHPMyAdmin and it works great, but it doesn't work in the website it self

ok long story short, there are three tables, hotels, cities, countries
hotels include in addition to hotel info, 2 columns (city_id) and (country_id)
Cities include id and name and also countries include id and name

what I was trying to do, that when a person inputs a city or country name in the search form, it should get the hotels that exists in this city or country, but unfortunately it shows all the hotels in all cities and countries, although the pagination code for number of pages works just fine, it count the number of hotels in that city or country and show the number of pages correctly

so here is the code for both

for hotel search

Code: [Select]
class hotelManager
{


public function getHotel($where)
{
$where = isset($_POST['where']) ? $_POST['where'] : "";
$dbObj = new DB();
$sql = "select * from hotels where city_id = (select id from cities where name = '$where' ) or country_id = (select id from countries where name = '$where' )";
$result = MYSQL_QUERY($sql);
$arr = array();
echo "<table>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td valign=\"top\" width=\"120px\">";
$rowid = $row['id'];
$imageqry=mysql_query("SELECT * FROM `hotelphotos` where hotel_id='$rowid' LIMIT 1");
$image=mysql_fetch_array($imageqry);
$imagename=$image['attachmentName'];
echo "<img src=\"foxmaincms/webroot/files/small/$imagename\"/>";
echo "</td>";
echo "<td valign=\"top\">";

echo "<table>
<tr>
<td valign=\"top\">
<a href=\"hotels.php?id=".$row['id']."\" class=\"titleslink\">".$row['name']."</a>
</td>
</tr>
<tr>
<td class=\"text\" valign=\"top\">
".$row['location']."
</td>
</tr>
</table>";

echo "</td>";
echo "</tr>";
}
echo "</table>";

for hotel pagination

Code: [Select]
<?php
  include("includes/hotelsManager.php");
  $hotelObj = new hotelManager();
  $where = isset($_POST['where']) ? $_POST['where'] : "";
  if(isset($_POST['where']))
  {
    
$hotelObj -> getHotel($where);


$per_page = 9;

//Calculating no of pages
$sql = "select * from hotels where city_id = (select id from cities where name = '$where' ) or country_id = (select id from countries where name = '$where' )";
$result = MYSQL_QUERY($sql) or die("<br />No Hotels found in this city, please check the city name and try again");
$count = mysql_num_rows($result);
$pages = ceil($count/$per_page)
?>


<div id="loading" ></div>
<div id="maincontent" ></div>
<ul id="pagination">
thank you in advance

Hi guys, I need a help to find out what is a problem. Some of my code does not work on my local comp and in the same time it works well when I place it on Internet server.
First example:
Code: [Select]
<body>
<?php 
if($_POST['submit_form'] == "Submit") 
{ $varNewTeam = $_POST['Reg_Team']; 
$varNewCity = $_POST['Reg_City']; 

 $db = mysql_connect('localhost', 'root', '') or die ('no connection with server');
  mysql_select_db('db_m ,$db) or die('DB error');
mysql_query ("INSERT INTO reg2012 VALUES ('$varNewTeam','$varNewCity')") or die('insert error');
} 
?>
<form action="registration_2012_form.php" method="post">
<p>Team: <input type="text" name="Reg_Team" size="20" maxlength="50" value="<?=$varNewTeam;?>" /><br /></p>
<p>City: <input type="text" name="Reg_City" size="20" maxlength="50" value="<?=$varNewCity;?>" /><br /></p>
<p><input type="Submit" value="Submit" name="submit_form" /></p>
</form>
</body>
On local comp: It gives me message "Undefined index: submit_form".
On Net server works well.
If I split the code in two files. In the first one I leave the form with "action=FILE2.php" and put my php code in the second file "FILE2.php" - it starts work even on local server.

second example:
Code: [Select]
<body>
<?php 
  $db = mysql_connect('localhost', 'root', '') or die ('no connection with server');
  mysql_select_db('db_m' ,$db) or die('DB error');
mysql_query ("CREATE TABLE temp1 (team char(50), city char(50) )") or die('create tables error');
?>
</body>
It works in the Net and can not create the TABLE on my local comp.

I use XAMPP on my local comp (if it's important)

This is my current code (actually it's heavily based off of a code a fellow phpfreak made. Basically, this makes it easy to put up images. When I want to put up a linkable image, I simply need to add to the image_links my subfolder, and add to the image_description my description.
Anyways, here it is, you can try and run it yourself:

Code: [Select]
<?php
$rows_per_page = 2;
$cols_per_page = 2;
$image_href = '<a href=/';
$image_links = array('otherstuff/nature>', 'otherstuff/volcanoes>', 'otherstuff/papersupplies>'');
$img_srcs = '<img src="https://s3.amazonaws.com/imgs/';
$images = array();

for($i = 1; $i < 10; $i++)
{
    $images[$i] = $i;
}
$image_ending = '.png" height="200" width="200" /></a>';
$image_break = '<br /><div class="timeago"><div id="submitted">submitted&nbsp;</div>';
$image_descriptions = array('<abbr class="timeago" title="2011-03-13T07:24:17Z"></abbr></div>', '<abbr class="timeago" title="2011-03-13T07:24:17Z"></abbr></div>', '<abbr class="timeago" title="2011-03-13T07:24:17Z"></abbr></div>');  
$total_images = count($images);
$images_per_page = $rows_per_page * $cols_per_page;
$total_images = count($images);
$total_pages = ceil($total_images / $images_per_page);
$current_page = (int) $_GET['page'];
if($current_page<1 || $current_page>$total_pages)
{
    $current_page = 1;
}

//Get records for the current page
$page_image_links = array_splice($image_links, ($current_page-1)*$images_per_page, $images_per_page);
$page_images = array_splice($images, ($current_page-1)*$images_per_page, $images_per_page);
$page_image_descriptions = array_splice($image_descriptions, ($current_page-1)*$images_per_page, $images_per_page);
$slots = "<table border=\"0\">";
for($row=0; $row<$rows_per_page; $row++)
{
    $slots .= "<tr>";
    for($col=0; $col<$cols_per_page; $col++)
    {
        $imgIdx = ($row * $rows_per_page) + $col;
        $img = (isset($page_images[$imgIdx])) ? "{$image_href}{$page_image_links[$imgIdx]}{$img_srcs}{$page_images[$imgIdx]}{$image_ending}{$image_break}{$page_image_descriptions[$imgIdx]}" : '&nbsp;';
        $slots .= "<td class='tables'>$img</td>";
    }
    $slots .= "</tr>";
}
$slots .= "</table>";

//Create pagination links
$first = "First";
$prev  = "Prev";
$next  = "Next";
$last  = "Last";
if($current_page>1)
{
    $prevPage = $current_page - 1;
    $first = "<a href=\"w4rmoemfdoiemroifmeromfxdnxvl.php?page=1\">First</a>";
    $prev  = "<a href=\"w4rmoemfdoiemroifmeromfxdnxvl.php?page={$prevPage}\">Prev</a>";
}
if($current_page<$total_pages)
{
    $nextPage = $current_page + 1;
    $next = "<a href=\"w4rmoemfdoiemroifmeromfxdnxvl.php?page={$nextPage}\">Next</a>";
    $last = "<a href=\"w4rmoemfdoiemroifmeromfxdnxvl.php?page={$total_pages}\">Last</a>";
}

?>
<html>
<title></title>
<head><style type="text/css">
#submitted {color: #888888; font-family:Verdana, Geneva, sans-serif; font-size: .8em; float:left;}
.tables {padding-left: 20px; padding-right: 20px;}
.timeago {color: #888888; font-family:Verdana, Geneva, sans-serif; font-size: .8em; float:right;}
</style><script src="/static/jquery-1.5.1.js" type="text/javascript"></script>
<script src="/static/jquery.timeago.js" type="text/javascript"></script>
<script type="text/javascript">
jQuery(document).ready(function() {
  jQuery("abbr.timeago").timeago();
});</script></head>
<body>
<h2>Here are the records for page <?php echo $current_page; ?></h2>
  <ul>
    <?php echo $slots; ?>
  </ul>
Page <?php echo $current_page; ?> of <?php echo $total_pages; ?>
<br />
<?php echo "view mo  {$next}"; ?>
</body>
</html>
---------------------------------------------------------------------

Now, I want to prepare for the long run. If I ever get up to say 1000 images, it's gonna take a while to parse 1000 image_links and 1000 image_descriptions, so instead, I want it to be read off of a database instead. I know low-level mySQL, I can usually understand the syntax. My problem is, I can never wrap my head around the logic. You can lock me in a week for a week and I still wouldn't be able to figure it out. But show me the code, and I'd say "I get it!" Can anyone please help me out, rather by giving a rough code or good thorough advice to carry it out? I'd prefer a good rough code but I'll take anything at this point :[

Thanks!

MOD EDIT: [code] . . . [/code] tags added.