PHP - Can Anyone Spot A Problem With This?

Guys thanks for helping me solve the problem i had but now i have another problem and i am lost. i have included the code below for you to have overview.

On the home page the url shows how it should be: http://localhost/board/italian.php?country=Italian
BUT 
When you mouse over the NEXT link to go to next page you get this : http://localhost/board/?page=1&country=Italian  and then an error 404 when you click on the link
page = 1  no matter if you are mousing over link for page 5 or 2

This is the code:

<table style="width:100%; margin-left:auto; margin-right:auto">
        <?php    
            
            $items_per_page = 5;//how many records/rows to display per page
                        
            $page_url      = "http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
                                    
            $cleaned_current_page_country = htmlspecialchars($_GET["country"]);
                        
            $page_number = (isset($_GET['page']))? filter_var($_GET['page']) : 1;
            //$page_number = filter_var($_GET['page']);
            //$page_number = $_GET['page'];
                
            $selected_restaurant_type = $_GET['country'];
                                                            
            // find number of rows in the db
                $query = "SELECT * FROM menu_update WHERE special_of_theday = 1 AND restaurant_type = '".$selected_restaurant_type."' ";
                $query_result = mysqli_query($connection, $query); 
                $row_count = mysqli_fetch_array($query_result);
                $total_rows = mysqli_num_rows($query_result);
                                                
            $expected_number_of_pages = ceil($total_rows/$items_per_page); //expected number of pages 
                                                
            $page_position = (($page_number - 1) * $items_per_page); //get starting position to fetch record
                        
            //fetch a group of records using sql LIMIT clause
                $query = "SELECT * FROM menu_update WHERE special_of_theDay = 1 AND restaurant_type = '".$selected_restaurant_type."' LIMIT " .$page_position. ',' .$items_per_page;
                $query_result = mysqli_query($connection, $query);
        ?>
                        
            <table width="100%" border=0>
                <tr bgcolor = "#cccccc">
                    <td>Meal</td>
                    <td>Meal name</td>
                    <td>Meal Price</td>
                    <td>Order Now</td>
                    <td>Full Menu</td>
                    <td>Our Gallery</td>
                    <td>Find Us</td>
                    <td>Our Chef</td>
                    <td>Our Manager</td>
                </tr>
        <?php
                while($row_count = mysqli_fetch_array($query_result)){
                    echo "<tr>";
                        echo"
                            <td style ='width:200px; text-align:center; height:120px; background:#eaedf2'><a href='meal_fullPic.php'><img src= ".$row_count['img']." /></a></td>
                            <td style ='width:119px; text-align:center; height:120px; background:#eaedf2'> ".$row_count['meal_name']."</td>
                            <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'>".$row_count['price']."</td>
                            <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'><a href='order_processor.php'><img src= ".$row_count['order_now']." /></a></td>
                            <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'><a href='full_menu.php'><img src= ".$row_count['full_menu_img']." /></a></td>
                                    
                            <td style ='width:170px; text-align:center; height:120px; background:#eaedf2'><a href='restaurant_gallery.php'><img src= ".$row_count['restaurant_pic']." /></a></td>
                            <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'><a href='restaurant_location.php'><img src= ".$row_count['location_pic']." /></a></td>
                            <td style ='width:119px; height:120px; background:#eaedf2'> ".$row_count['chef_name']."</td>
                            <td style ='width:119px; height:120px; background:#eaedf2'> ".$row_count['admin']."</td>
                        "; 
                    echo "</tr>";
                }
                mysqli_close($connection);
        ?>    
            </table>
        <div class="board_pagination">
        <?php
            //display the links to the pages
            for($current_page = 1; $current_page <= $expected_number_of_pages; $current_page++){
                 if ($page_number != $expected_number_of_pages){
                    $data = array(
                        'page' => $page_number,
                        'country' => $cleaned_current_page_country,
                    );
                    $the_query = http_build_query($data);
                    $page_url .= '?' . $the_query;
                    echo '<li><a href=" '.$the_query.' ">'.$current_page.'</a></li> ';
                }
            }
        ?>
        </div>
    </table>
 

so i want to call my php file with a query string to select a record out of a XML file... im close but cant get the variable i pass to be the record selected..

example... index.php?auction=1

i highlighted in red, where it doesnt pick up the proper row


Code: [Select]
<?php
ini_set('display_errors', 1); 
error_reporting(E_ALL);

$auction = $_GET{auction}; 


// parse the xml
$xmlFileData = file_get_contents("items.xml");
$xmlData = new SimpleXMLElement($xmlFileData);

[color=red]$location = $xmlData->item[$auction];[/color]

//Retrieving the content from the selected item
$title = $location->title;
$value = $location->value;
$itemnumber = $location->itemnumber;
$description = $location->description;
$donatedby = $location->donatedby;
$image1 = $location->image1;
$image2 = $location->image2;
$image3 = $location->image3;
$image4 = $location->image4;
$image5 = $location->image5;
$image6 = $location->image6;
$image7 = $location->image7;
$image8 = $location->image8;

?>


<style>
.itemimages img {width: 10px; height: 10px;}
img.large {width: 100px; height: 100px;}
</style>
<script language="JavaScript" src="http://code.jquery.com/jquery-1.5.min.js" type="text/javascript"></script>
<script>
$().ready(function() {

$(".itemimages img").click(
$("#largepic").attr("src","this");
 });


});
</script>


<table border="1" cellpadding="10">
<tr>
<td valign="top">
<img src="<?php echo $image1 ?>" alt="" border="0" class="large" id="largepic"><br>
<div class="itemimages">
<?php 
// image 1
if (trim(''.$image1) != '') { 
echo "<img src='";
echo $image1;
echo "' alt='' border='0'/> ";
}
// image 2
if (trim(''.$image2) != '') { 
echo "<img src='";
echo $image2;
echo "' alt='' border='0'/> ";
}
// image 3
if (trim(''.$image3) != '') { 
echo "<img src='";
echo $image3;
echo "' alt='' border='0'/> ";
}
// image 4
if (trim(''.$image4) != '') { 
echo "<img src='";
echo $image4;
echo "' alt='' border='0'/> ";
}
// image 5
if (trim(''.$image5) != '') { 
echo "<img src='";
echo $image5;
echo "' alt='' border='0'/> ";
}
// image 6
if (trim(''.$image6) != '') { 
echo "<img src='";
echo $image6;
echo "' alt='' border='0'/> ";
}
// image 7
if (trim(''.$image7) != '') { 
echo "<img src='";
echo $image7;
echo "' alt='' border='0'/> ";
}
// image 8
if (trim(''.$image8) != '') { 
echo "<img src='";
echo $image8;
echo "' alt='' border='0'/> ";
}
?>
</div>


</td>
<td valign="top">

<?php echo $title ?><br>
Estimated Value: <?php echo $value ?><br>
Item Number: <?php echo $itemnumber ?><br><br>

<?php echo $description ?><br><br>

Donated by: <?php echo $donatedby ?><br>
</td>
</tr>
</table>

I am trying to understand PHP OOP and I have some code that is not working. here is the error code.
Code: [Select]
Parse error: parse error, expecting `T_FUNCTION' in C:\wamp\www\testing\armor_lib.php on line 11
And here is the armor_lib.php file:
<?php
class armor {
// Head
public $head;
public $torso;
public $pants;
public $gloves;
public $boots;

// new stuff here
class head extends armor {
function __construct($head){
$this->set_head($head);
}
}
// Torso
class torso extends armor {
function __construct($torso){
$this->set_torso($torso);
}
}
// Pants
    class pants extends armor {
function __construct($pants){
$this->set_pants($pants);
}
}
// Gloves
class gloves extends armor {
function __construct($gloves){
$this->set_gloves($gloves);
}
}
// Boots
class boots extends armor {
function __construct($boots){
$this->set_boots($boots);
}
}
}
?>

And here is the php in the armor.php file I have:
<?php
$head = new armor("Leather Helm");
$torso = new armor("Leather Shirt");
$pants = new armor("Leather Pants");
$gloves = new armor("Chain Mail Gloves");
$boots = new armor("Leather Boots");

echo "You are wearing: " . $head->get_head() . "on your Head";
echo "<br />";
echo "You are wearing: " . $torso->get_torso() . "on your Torso";
echo "<br />";
echo "You are wearing: " . $pants->get_pants() . "on your Legs";
echo "<br />";
echo "You are wearing: " . $gloves->get_gloves() . "on your Hands";
echo "<br />";
echo "You are wearing: " . $boots->get_boots() . "on your Feet";
?>

Any Help in understanding this will be much appreciated. Thanks.

Hello everyone

Just found this forum and really need some help. I'm trying to create a popup contact form for my product pages. I managed to get a php form from a random site and i cant get the form to pop up.

http://www.e-sol.co.uk/printer-scanner-copier.php

If someone could help i would be very grateful.

Code: [Select]
<?php
require('config.php');
$sql = "SELECT m.Title as title , f.Reg_URL as reg
        FROM
                website_main as m   
                JOIN               
                website_front as f               
         LIMIT 0,01
              ";


$result = @mysql_query($sql) or die(mysql_error());
echo "<table border='3'>";
echo "<font size='9'><tr> <th><FONT COLOR=red><center>Title</center></font></th> <th><FONT COLOR=red>reg</th> </tr></font>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
   // Print out the contents of each row into a table
$reg = $row['reg'];
      echo "<tr><td bgcolor=''><center>";       
   echo $row['title'];
   echo "</td><td bgcolor=''><center>";
echo '.$reg.';
   echo "</td></tr>"; 
}
?>
I got a problem i try to use an attribute for $reg but only appears as .$reg. on website anyone know why?
Parts i have problems with are $reg = $row['reg']; and echo '.$reg.';.

thank you

im making a website it works fine on firefox but on ie doesnt work correctly.
page looks weird i see the error is

<?
include("index/index_files/front/php/include.php");
?>

anyone can help me its in a <html> tab.

Hi there,

I have a map of America made in flash, where you click on a state and the page should display the SQL database information for that state in the HTML table - but instead all it shows is the first entry of the database regardless of which state you click and it doesn't display the 2 radio buttons.

My code is as follows

Flash Actionscript 3 (just showing one state)
Code: [Select]
function waClick(event:MouseEvent):void {
var waURL:URLRequest = new URLRequest("restaurants.php?state=Washington");
navigateToURL(waURL, "_self");
}
wa_btn.addEventListener(MouseEvent.CLICK, waClick);
PHP code

Code: [Select]
<?php
  include("mvfconnect.php");
  $theChoice = $_GET['state'];
  $query = "SELECT * FROM restaurants WHERE" .$theChoice;
  $result = @ mysql_query($query);
  if (!$result) {
   $message="Unfortunately we are having problems with this page, we promise to have it fixed as soon as possible";
    die($message);
  }
  $num = mysql_num_fields($result);
  $i=0;
  while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
   $show1=substr($row['state'],0,50)."...";
   $show2=substr($row['city'],0,50)."...";
   $show3=substr($row['rname'],0,50)."...";
   $show4=substr($row['address'],0,50)."...";
   $show5=substr($row['pnum'],0,50)."...";
   $show6=substr($row['web'],0,50)."...";
   $show7=substr($row['dishes'],0,50)."...";
   $show8=substr($row['dish_details'],0,50)."...";
   $show9=substr($row['challenges'],0,50)."...";
   $show10=substr($row['challenge_details'],0,50)."...";
   $show11=substr($row['youtube'],0,50)."...";
   $show12=substr($row['images'],0,50)."...";
   echo "<tr>".
          "<td>".$row['city']."</td>". 
          "<td>".$row['rname']."</td>".
          "<td>".$row['address']."</td>".
          "<td>".$row['pnum']."</td>". 
          "<td>".$row['web']."</td>".
          "<td>".$row['dishes']."</td>".
          "<td>".$row['challenges']."</td>". 
              "<td id='state".$i."' style='display:none'>".$row['state']."</td>".
          "<td id='city".$i."' style='display:none'>".$row['city']."</td>".
          "<td id='rname".$i."' style='display:none'>".$row['rname']."</td>".
          "<td id='address".$i."' style='display:none'>".$row['address']."</td>".
          "<td id='pnum".$i."' style='display:none'>".$row['pnum']."</td>".
          "<td id='web".$i."' style='display:none'>".$row['web']."</td>".
          "<td id='dishes".$i."' style='display:none'>".$row['dishes']."</td>".
          "<td id='dish_details".$i."' style='display:none'>".$row['dish_details']."</td>".
          "<td id='challenges".$i."' style='display:none'>".$row['challenges']."</td>".
          "<td id='challenge_details".$i."' style='display:none'>".$row['challenge_details']."</td>".
          "<td id='youtube".$i."' style='display:none'>".$row['youtube']."</td>".                 
                  "<td id='images".$i."' style='display:none'>".$row['images']."</td>".        
                  "<td><input type='radio' name='vid' id='vid".$i."' onclick='openVideo(".$i.")' /></td>".
          "<td><input type='radio' name='pic' id='pic".$i."' onclick='openImage(".$i.")' /></td>".
          "<td class='last'style='display:none'>".$show1." ".$show2." ".$show3." ".$show4." ".$show5." ".$show6."
                  ".$show7." ".$show8." ".$show9." ".$show10."</td>".
         "</tr>";
    $i++;
   }
?>

I have used this code before and it has worked fine, can someone please help me out! 

 
 

Hi
I make 3 querys first Order by DESC, second RAND() and third ASC. Now I want that in the second query can't be the same ids (produgg_users.id) that already taken in the first. And in the third not the ids from first and second. Like I have it now the same users can show up in the RAND() and the ASC like in DESC. Here my Script so far:

$rs = mysql_query("select produgg_users.id, twitterUser, credits from produgg_users where twitterUser != '' and  
                produgg_users.id IN (select concat_ws(',', id) from produgg_users where credits > 0 and id != ".$usersClass->userID().") and produgg_users.id NOT IN (select concat_ws(',', followedID) from produgg_activity where followerID = '".$usersClass->userID()."') and produgg_users.id NOT IN (select concat_ws(',', userid) from produgg_featured) ORDER BY credits DESC LIMIT 10") or die(mysql_error()); 


$nr = @mysql_num_rows($rs);



if($nr != 0) {
    
    print "<p>Simply click <strong>get 1 point</strong> and you will automatically FOLLOW the USER and earn the credit!</p>";

print "<p><font color=\"#0066FF\">Top Members</font></p>";
    
    while($row=@mysql_fetch_object($rs))
    {

        $divLeft = '<div id="thediv_'.$row->id.'"><div style="float:left;width:400px;">';
        $divRight = '<div style="float:left;width:150px;">';
        $clearDiv = '<div style="clear:both;"></div>';

        print "$divLeft<img src=\"http://api.twitter.com/1/users/profile_image/".strip_tags($row->twitterUser)."?size=mini\" alt=\"\" />&nbsp;&nbsp;".strip_tags($row->twitterUser)."&nbsp;&nbsp;<font color=\"#999999\" size=\"1\">$row->credits&nbsp;Points</font></div>$divRight <a href='javascript:void(0);' id='vote_$row->id' class='getPoint'>Get 1 Point</a></div>$clearDiv<hr /></div>";
$z = 1;
    }
}

//Lucky Riders

$rs = mysql_query("select produgg_users.id, twitterUser, credits from produgg_users where twitterUser != '' and  
                produgg_users.id IN (select concat_ws(',', id) from produgg_users where credits > 0 and id != ".$usersClass->userID().") and produgg_users.id NOT IN (select concat_ws(',', followedID) from produgg_activity where followerID = '".$usersClass->userID()."') and produgg_users.id NOT IN (select concat_ws(',', userid) from produgg_featured) ORDER BY RAND() LIMIT 5") or die(mysql_error());    
$nr = @mysql_num_rows($rs);

if($nr != 0) {
    

print "<p><font color=\"#0066FF\">Lucky Riders</font></p>";
    
    while($row=@mysql_fetch_object($rs))
    {
        $divLeft = '<div id="thediv_'.$row->id.'"><div style="float:left;width:400px;">';
        $divRight = '<div style="float:left;width:150px;">';
        $clearDiv = '<div style="clear:both;"></div>';

        print "$divLeft<img src=\"http://api.twitter.com/1/users/profile_image/".strip_tags($row->twitterUser)."?size=mini\" alt=\"\" />&nbsp;&nbsp;".strip_tags($row->twitterUser)."&nbsp;&nbsp;<font color=\"#999999\" size=\"1\">$row->credits&nbsp;Points</font></div>$divRight <a href='javascript:void(0);' id='vote_$row->id' class='getPoint'>Get 1 Point</a></div>$clearDiv<hr /></div>";
$z = 1;
    }
}

//Lucky Riders

$rs = mysql_query("select produgg_users.id, twitterUser, credits from produgg_users where twitterUser != '' and  
                produgg_users.id IN (select concat_ws(',', id) from produgg_users where credits > 0 and id != ".$usersClass->userID().") and produgg_users.id NOT IN (select concat_ws(',', followedID) from produgg_activity where followerID = '".$usersClass->userID()."') and produgg_users.id NOT IN (select concat_ws(',', userid) from produgg_featured) ORDER BY credits ASC LIMIT 5") or die(mysql_error());    
$nr = @mysql_num_rows($rs);

if($nr != 0) {
    

print "<p><font color=\"#0066FF\">Last Rides</font></p>";
    
    while($row=@mysql_fetch_object($rs))
    {
        $divLeft = '<div id="thediv_'.$row->id.'"><div style="float:left;width:400px;">';
        $divRight = '<div style="float:left;width:150px;">';
        $clearDiv = '<div style="clear:both;"></div>';

        print "$divLeft<img src=\"http://api.twitter.com/1/users/profile_image/".strip_tags($row->twitterUser)."?size=mini\" alt=\"\" />&nbsp;&nbsp;".strip_tags($row->twitterUser)."&nbsp;&nbsp;<font color=\"#999999\" size=\"1\">$row->credits&nbsp;Points</font></div>$divRight <a href='javascript:void(0);' id='vote_$row->id' class='getPoint'>Get 1 Point</a></div>$clearDiv<hr /></div>";
$z = 1;
    }

}

 

i have written a script using touch() function for creating new pages.. but the url's appear are not search engine frendly
i want the urls to appear like this everyspace filled with - oder than a space because the space makes the url display as
http://localhost/gl/uploads/movies/2010/08/The%20Hangman%202010%20Hindi%20Movie%20Watch%20Online/The%20Hangman%202010%20Hindi%20Movie%20Watch%20Online.php
I want it to appear this way
http://www.onlinewatchmovies.net/hindi/vroom-2010-hindi-movie-watch-online.html

any suggestion how can i do this?

I have a simple text file called bio.txt:
Code: [Select]
wohlersr; Richie Wohlers; Intermediate; Four Aces
meyersg; Greg Meyers; Novice; Four Aces
I wrote a little script, to return the info for Greg Meyers if the user id is correct, or say "Member not found" if incorrect.  For some reason, my output is giving me both.  I assume it's a context error, but can't figure it out.

Here's my script:
Code: [Select]
<?php
$file=file("bio.txt");
$count=count($file);

$i=0;
while($i<=$count)
{
$row = explode(";", $file[$i]);

$id = $row[0];
$name = $row[1];
$class = $row[2];
$club = $row[3];

if($id=="meyersg"){
echo $name."</br>";
echo $class."</br>";
echo $club."</br>";
}else{
echo "Member not found.";
} 

$i++;
}

?>
And here's the output I'm getting:
Code: [Select]
Member not found. Greg Meyers
Novice
Four Aces
Member not found.

i'm getting this erro
"Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 3 in /***/***/*****.php on line 278
not an active session, starts new"

this is the code:
if ($phase = mysql_result(mysql_query("SELECT `phase` FROM `as_support` WHERE `mission` = '$var2'"),0,0))
 {
   if ($phase=='5') {
//      mysql_query("DELETE FROM `as_support` WHERE `mission` = '$var2'");
//      header("Location: https://www.**********/*******/*******.php");
   }
   else {
      echo date('h:i:s') . ": PHASE is $phase<br />";
      echo "\$var1=$var1,\$var2=$var2<br />";
   }
}
else {
   echo "not an active session, starts new<br />";
   echo "\$var1=$var1,\$var2=$var2<br />";
   mysql_query("INSERT INTO `as_support` (`mission`, `phase`) VALUES ('$var2', '0')") OR DIE(mysql_error());

the first line is line no. 278

can someone please tell me what to do?

tnx

shirley

Hi. I am from poland. I am 17 old age and like webmastering. I write my social network. I have new server 10 GB VPS and my script no runing  In my server. in my server do can not login. No runing function
Code: [Select]
mb_strtolower();as delete function mb_strtolower() ; this login runing.
In my server haven`t installing liberary GD and no runing upload avatars.

my code upload is:
elseif ($_GET['act'] == "upload") {
echo <<< KONIEC
<hr>
<center>
        <p>
                <h2>Dodaj zdj&#281;cie</h2> 
                <ul class="gallery clearfix">
                        <li class="extra">
KONIEC;

error_reporting(E_ALL);

// we first include the upload class, as we will need it here to deal with the uploaded file
include('include/class.upload.php');


// retrieve eventual CLI parameters
$cli = (isset($argc) && $argc > 1);
if ($cli) {
    if (isset($argv[1])) $_GET['file'] = $argv[1];
    if (isset($argv[2])) $_GET['dir'] = $argv[2];
    if (isset($argv[3])) $_GET['pics'] = $argv[3];
}

// set variables
$dir_dest = (isset($_GET['dir']) ? $_GET['dir'] : 'test');
$dir_pics = (isset($_GET['pics']) ? $_GET['pics'] : $dir_dest);

if (!$cli) {

}


// we have three forms on the test page, so we redirect accordingly
if ((isset($_POST['action']) ? $_POST['action'] : (isset($_GET['action']) ? $_GET['action'] : '')) == 'simple') {


    // ---------- SIMPLE UPLOAD ----------

    // we create an instance of the class, giving as argument the PHP object
    // corresponding to the file field from the form
    // All the uploads are accessible from the PHP object $_FILES
    $handle = new Upload($_FILES['my_field']);

    // then we check if the file has been uploaded properly
    // in its *temporary* location in the server (often, it is /tmp)
    if ($handle->uploaded) {
        
        // yes, the file is on the server
        // now, we start the upload 'process'. That is, to copy the uploaded file
        // from its temporary location to the wanted location
        // It could be something like $handle->Process('/home/www/my_uploads/');
        $handle->Process($dir_dest);
                
                
         function TestProcess(&$handle, $title = 'test', $details='') {
            global $dir_pics, $dir_dest;
                        $unlink = 'test/'. $handle->file_dst_name;
$myid = $_SESSION['id'];
$opis = htmlspecialchars(stripslashes(strip_tags(trim($_POST["opis"]))), ENT_QUOTES);
            $handle->Process($dir_dest);

            if ($handle->processed) {
                                unlink("$unlink");
                                $link = ''.$dir_pics.'/' . $handle->file_dst_name .'';
                                $addphoto = mysql_query("INSERT INTO photo VALUES('', '$myid', '$link', '$opis')");
                                echo <<< KONIEC
                                <br>
                                <center>
                                <img src="$link" >
                                <br>
                                <br />
                                </center>
KONIEC;
            } else {
                echo '<fieldset class="classuploadphp">';
                echo '  <legend>' . $title . '</legend>';
                echo '  Error: ' . $handle->error . '';
                if ($details) echo '  <pre class="code php">' . htmlentities($details) . '</pre>';
                echo '</fieldset>';
            }
        }
        if (!file_exists($dir_dest)) mkdir($dir_dest);

        

        // -----------
                $handle->image_convert         = 'jpg';
                $handle->image_resize          = true;
        $handle->image_ratio_y         = true;
        $handle->image_x               = 500;
        $handle->image_precrop         = 15;
        $handle->image_watermark       = "watermark_large.png";
        $handle->image_watermark_x     = 20;
        $handle->image_watermark_y     = -20;
        TestProcess($handle, '15px pre-cropping (before resizing 800 wide), large watermark automatically reduced, position 20 -20', "\$foo->image_convert         = 'jpg';\n\$foo->image_resize          = true;\n\$foo->image_ratio_y         = true;\n\$foo->image_x               = 800;\n\$foo->image_precrop         = 15;\n\$foo->image_watermark       = 'watermark_large.png';\n\$foo->image_watermark_x     = 20;\n\$foo->image_watermark_y     = -20;");

        } else {
            // one error occured
            echo '<fieldset>';
            echo '  <legend>file not uploaded to the wanted location</legend>';
            echo '  Error: ' . $handle->error . '';
            echo '</fieldset>';
        }

        // we copy the file a second time
        

        // we delete the temporary files
        $handle-> Clean();





    } else {
        // if we are here, the local file failed for some reasons
        echo '<fieldset>';
        echo '  <legend>local file error</legend>';
        echo '  Error: ' . $handle->error . '';
        echo '</fieldset>';
    }



echo <<< KONIEC
<li>
                </ul>
                
        </p>
</center>
KONIEC;
 

is it the only problem that isn`t installing GD as i have something off in php.ini ? Plise Help me

Hi,
i use mysql_real_escape_string() function when insert in db, but when echo i use htmlentities($var, ENT_QUOTES, "UTF-8")
Now problem is '\ in that text.

In db it write text with single quote with \, example That\'s wrong, and when echo it show just the same like in db..
How can i fix this ?

I am trying to use the following code snippet to return values from a database with a "," after each value apart form the last one. At the moment for testing I have 2 rows with values 1 and 3

$totalRows_Recordset3    equals 2 (I echoed this to check)

$i=1;
  while($row_Recordset3 = mysql_fetch_assoc($Recordset3))
  {
    if($i < $totalRows_Recordset3)
    {
      $str = $str.$row_Recordset3['reading'].",";
      $i=$i+1;
    }
    else
    {
      $str = $str.$row_Recordset3['reading'];
      $i=$i+1;
    }
  } 

I get the number 3 which is the last value in the database, but I can't see why I don't get "1,3"

I am sure it is something simple but it just escapes me.

Thanks in advance for any help

Gordon

Hi,

I am trying to write in an existing excel file. But for some reason, I can't open the workbook (but I know I have made similar code work before). Here I am just pasting the code upto the error line

$filename="C:\\apache\\htdocs\\GAC2\\dload\\template.xls";
$excel = new COM("excel.application") or die("Unable to instanciate excel");
$excel->Visible = 1;
$excel->DisplayAlerts = 1;
try{
     $wkb = $excel->Workbooks->Open($filename);
}catch (Exception $e) {
     echo 'Caught exception: ',  $e->getMessage(), "\n";
}

//........ Later part of the code


This returns the following error
Code: [Select]
Caught exception:
Source: Microsoft Office Excel
Description: Unable to get the Open property of the Workbooks class

For record, the I have already validated the file location. And I have tried the following line instead without any positive result.
Code: [Select]
$filename="C:\apache\htdocs\GAC2\dload\template.xls";
Looking for any help please.

-Abd