Jump to content

Need a help with PHP Code


xuykin

Recommended Posts

Hi Guys,

 

I'm new to PHP programming and hope you can help me here. I have difficulty comprehending functions in PHP.

Here is what I am trying to accomplish:

 

I have a website that automatically pulls the content from MySQL database and puts them out. I am able to connect and retrieve the content and put them on, however the problem I am encountering is automatically resizing picture and placing javascript affiliate link underneath the picture. Since, I have more than 2000 items on the database I will like to be able to split that content into 100 pages (20 in each page). I don't know how to do that.

Here is my code I am having a trouble with:

 

<?php

// this calulates resizing

 

 

function imageResize($width, $height, $target) {

 

 

if ($width > $height) {

$percentage = ($target / $width);

} else {

$percentage = ($target / $height);

}

 

//gets the new value and applies the percentage, then rounds the value

$width = round($width * $percentage);

$height = round($height * $percentage);

 

 

return "width=\"$width\" height=\"$height\"";

 

 

}

 

?>

 

 

<?php

//this creates array

 

$rcimage = getimagesize("http://images.xxxxxx.com");

 

 

?>

 

 

<img src="http://images.xxxx.com" width="125" <?php echo imageResize($rcimage[0], 

$rcimage[1], 125); ?> />

 

 

 

<?php

 

 

//Connect To Database pulls information

$hostname='xxxxxx';

$username='yyyy';

$password='zzzzz';

$dbname='aaaaa';

$usertable='bbbbbbbbbb';

 

 

mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');

mysql_select_db($dbname);

 

 

$query = 'SELECT DISTINCT `IMAGEURL`, `NAME`, `CURRENCY`, `PRICE`, `BUYURL` FROM `bbbbbbbbbb` WHERE `NAME` LIKE \'%heli%\' LIMIT 0, 20 ';

$result = mysql_query($query);

 

if($result) {

    while($row = mysql_fetch_array($result)){

    $imageurl=$row[0];

$name = $row[1];

$currency=$row[2];

$price=$row[3];

$buyurl=$row[4];

 

 

        echo "<div class=\"contenttopcenter2\" <img src=\"$imageurl\"  <?php echo imageResize($rcimage[0],$rcimage[1], 125);  /> ?> $name, $currency, $price, $buyurl

        </div>";

    }

}

 

 

 

?>

 

 

The piece of code I am having a problem is highlighted in red and orange color.

 

Link to comment
https://forums.phpfreaks.com/topic/199316-need-a-help-with-php-code/
Share on other sites

AdRock,

 

Thank you! Looks like it solved error issues and did resize images, however all images resized and given  static value as for width and height. Is it what supposed to happen? :shrug:

 

Thank you for the reply. I have learned today how to use concatenation properly!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.