PHP - Issue With Masonry - Overlapping Divs

Hi, I have this code below which groups all the SubHeading together and then queries the same table to find RiskConsequence which are grouped that match SubHeading then to query this table one more last time with all the Risk Mitigation that matches the grouped RiskConsequence.

Problem I get is it does the SubHeading, the RiskConsequences it only does one of them not all of them before it moves onto the RiskMitigation.

I know I have a php coding issue just cant see the wood from the tree's as the queries work.

Code: [Select]
<?php
include ("include.php");
$query = "SELECT * FROM tblriskassessmentdatabank GROUP BY SubHeading";
$results = mysql_query($query) or die("Error: " . mysql_error());
while($row1 = mysql_fetch_array($results)){
    

    echo'<a href="#" onClick="return(changeDisplay(';echo"'";echo($row1[SubHeading]);echo"'))";echo'">';echo($row1[SubHeading]);echo'</a><br /><br />';
echo'<div id="';echo($row1[SubHeading]); echo'" class="HideText">';

$risksub = $row1[SubHeading];

$query1 = "SELECT * FROM tblriskassessmentdatabank GROUP By RiskConsequence";
$results1 = mysql_query($query1) or die("Error: " . mysql_error());
while($row2 = mysql_fetch_array($results1)){


echo'<a href="#" onClick="return(changeDisplay(';echo"'";echo($row2[RiskConsequence]);echo"'))";echo'">';echo($row2[RiskConsequence]);echo'</a><br />';
echo'<div id="';echo($row2[RiskConsequence]); echo'" class="HideText">';
$risksub1 = $row2[RiskConsequence];
$query1 = "SELECT * FROM tblriskassessmentdatabank WHERE RiskConsequence = '$risksub1'";
$results1 = mysql_query($query1) or die("Error: " . mysql_error());
while($row3 = mysql_fetch_array($results1)){

echo'<input name="checkbox[]" type="checkbox" id="checkbox[]" value="';echo($row3[IssueNumber]);echo'" />
    <label for="checkbox[]"></label>';echo($row3[RiskMitigation]);echo'<br /><br />';
}
echo'</div>';

}

echo'</div>';
  }
?>

Im trying to print several image url's and names from an sql database into 3 columns,

Aiming to get it to go

1,2,3
4,5,6
7,8,9

etc etc. but for some reason myne is going

1,3,5
2,4,6

etc. Dont bother mentioning that my loops do nothing, i realised that about 10 minutes ago, Any help would be appreciated.



<?php
include 'config.php';
mysql_connect($host, $user, $pass) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());
$result = mysql_query("SELECT * FROM tracks");
echo '<div id="left_wrapper">';
for ($i=0;$i<mysql_num_rows($result);$i+=3) {
    $row = mysql_fetch_array($result);
    $id = $row['id'] + 1;
    echo "<img src='Thumbnails/" . $id .".gif'></img><br>";
    echo $row['name']. "<br>";
}
echo "</div>";
echo '<div id="middle_wrapper">';
for ($i=1;$i<mysql_num_rows($result);$i+=3) {
    $row = mysql_fetch_array($result);
    $id = $row['id'] + 1;
    echo "<img src='Thumbnails/" . $id .".gif'></img><br>";
    echo $row['name']. "<br>";
}
echo "</div>";
echo '<div id="right_wrapper">';
for ($i=2;$i<mysql_num_rows($result);$i+=3) {
    $row = mysql_fetch_array($result);
    $id = $row['id'] + 1;
    echo "<img src='Thumbnails/" . $id .".gif'></img><br>";
    echo $row['name']. "<br>";
}
echo "</div>";
?>
i know each of those loops does nothing, But you can see where they are meant to do, Each div is aligned to different positions, first loop is left, 2nd is center, 3rd is right.

At the moment i can retrieve information from a DB and display it nicely in a vertical line of boxes (some boxes with extra information as needed).

I basically need a version of this with exactly the same information, but instead of a top-down list of divs (boxes), I need them to be displayed going around a circle (starting top centre, going clockwise).

Does anyone know if this is possible?
And how easy would it be? Any scripts?

It's already taken me ages to get the list pulling the appropriate info and displaying in a straight line.

Thanks for any help/direction.


Added: The number of divs displayed will be variable depending on what's in the DB. So I can't count on their being a certain number. Therefore the 'circle' would need to re-size in some way?!

Hello guys!   I'm currently writing a bit of an image gallery code which is working pretty well however there seems to be a few issues with the sytling and layout of the gallery. (It's nothing flash just displays the images and caption in category order)   Now I am not sure how to go about doing this but is there any way to wrap each category in a div? I have the whole while loop wrapped in a div at present but I would like each category wrapped so I can style it a bit easier.   Can someone please point me in the right direction. Currently my code looks like this:

function Gallery(){

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

    $conn = mysqli_connect("Why","Hello","There","Friends")
        or die('Cannot Connect to the database');

    $q ="SELECT * FROM gallery_category AS c JOIN gallery_photos AS p ON p.categoryname = c.categoryname ORDER BY c.categoryid";
    $result = mysqli_query($conn, $q)
        or trigger_error("Query Failed! SQL: $conn - Error: ".mysqli_error(), E_USER_ERROR);


    echo"<div class='gallery'>";
    $categoryname='';
    while($rows = mysqli_fetch_assoc($result)){

            if ($categoryname != $rows['categoryname']) {
                    $categoryname = $rows['categoryname'];

                    echo"<div class='h'><h2>".$rows['categoryname']."</h2></div>";

                }

                echo"
                    <div class='gall'>
                        <div class='gl-img'><img src='pathway/to/gallery/".$rows['photoname']."' alt='".$rows['categoryname']."'/></div>
                        <div class='gl-cap'>".$rows['photocaption']."</div>
                    </div>";
        
            }


    echo"</div>";

    $conn-> close();
}

I don't know how to go about updating it so that it is this section that is wrapped whilst the "gall" class repeats (if that makes sense)

echo"<div class='h'><h2>".$rows['categoryname']."</h2></div>";
                }
                echo"
                    <div class='gall'>
                        <div class='gl-img'><img src='pathway/to/gallery/".$rows['photoname']."' alt='".$rows['categoryname']."'/></div>
                        <div class='gl-cap'>".$rows['photocaption']."</div>
                    </div>";

So that it looks like this:

<div class="category">
			<div class="h"><h2>Category Title</h2></div>
			<div class="gall">
				<div class="gl-img"><img src="pathway/to/gallery/polarbear2.jpg"></div>
				<div class="gl-cap">Polar Bear</div>
			</div>
			<div class="gall">
				<div class="gl-img"><img src="pathway/to/gallery/polarbear2.jpg"></div>
				<div class="gl-cap">Polar Bear</div>
			</div>
			<div class="gall">
				<div class="gl-img"><img src="pathway/to/polarbear2.jpg"></div>
				<div class="gl-cap">Polar Bear</div>
			</div>
			<div class="gall">
				<div class="gl-img"><img src="pathway/to/gallery/polarbear2.jpg"></div>
				<div class="gl-cap">Polar Bear</div>
			</div>
		</div>

Any and all help on how to achieve this would be appreciated!! thank you
Edited by laurenetherington, 26 November 2014 - 12:10 PM.

<div style="margin-left:5px;width:980px;float:left;">

  <div style="width:330px;height:310px;float:right;">
      <div style="width:320px;height:170px;float:left;"><img src="X.gif" alt=""></div>
      <div style="width:320px;height:170px;float:left;"><img src="Y.gif" alt=""></div>
  </div>
</div>

http://www.des-otoole.co.uk/se2/WoodFuel.php

Hi in this page AT THE BOTTOM   I have a large div float left. A smaller inner div float right. ( this has to inner divs with pictures) I want the text in the outer div to wrap the float right div   Any help please.      

Are either of these OK depending on circumstance or stupid things I should never do? Is one or the other sensible/idiotic? Is there an obvious 'better' way?   I think all the php tags opening and closing within the DIVs is untidy but it's static HTML therefore if there's a LOT of it it's easier on the server right/wrong?

On the other hand, maybe all the open/close of php tags defeats the object.

I'm applying for a web design apprenticeship (I know, I need one) so I'm trying to appear less stupid as much as make nice php.   Many thanks in advance, I know I'll end up better off by asking here

<?php
 
// php in here

?>
    <div class='content header'>
        <?php include("includes/header.php"); ?>
    </div>
    <div class='content content1'>
        <?php include("includes/intro.php"); ?>
    </div>
    <div class='content content2'>
        <?php include("includes/quals.php"); ?>
    </div>
    <div class='content content3'>
        <?php include("includes/experience.php"); ?>
    </div>
    <div class='content content4'>
        <?php include("includes/hobbies-and-interests.php"); ?>
    </div>
<?php

// More php here

?>

Or this one:

<?php
    print("<div class='content header'>");
        include("includes/header.php");
    print("</div> \r\n <div class='content content1'>");
        include("includes/intro.php");
    print("</div> \r\n <div class='content content2'>");
        include("includes/quals.php");
    print("</div> \r\n <div class='content content3'>");
        include("includes/experience.php");
    print("</div> \r\n <div class='content content4'>");
        include("includes/hobbies-and-interests.php");
    print("</div> \r\n");
?>

 test.zip   1.5KB   0 downloads

Dear all,

I am new to the forums, with a hope that somebody can point me in the right direction. I am coding a new photo website, and am doing it with PHP to maximize my flexibility. In essence I want to have a set of gallery folder on the server, and the site reads off these folders and automatically generates the required galleries.

My PHP code is below, along with a detail of the exact problem:

  <?php


$main  = "Collections/";  # Location of galleries
$big    = "Large/";  # Location of big versions (subdir within each gallery)
$i  = 0; #Gallery Iterator


#Searching for galleries & Checking only for directories (save them im $galleries array)
$tempgalleries = scandir($main);
    foreach ($tempgalleries as $gallery_iterate)
    { 
if (!is_dir($gallery_iterate))
{
$galleries[]=$gallery_iterate;
}
}


#Iterating galleries. Collecting each gallery's images (saving in $GalleryImages.$i). This creates an image array for each $galleries[$i]
for($i=0; $i<=sizeof($galleries)-1; $i++) 
{
#Making the title nice (from the the directory names)
$GalleryTitles[$i] = str_replace('_',' ', $galleries[$i]);;
$temp_gallery = opendir($main.$galleries[$i]);
#Checking for Images and storing in array if valid
while (false !== ($image = readdir($temp_gallery))) 
{
  if ($image != "." && $image != ".." && $image != rtrim($big,"/") && strstr($image,'.jpg')) 
  {
${$GalleryImages_.$i}[] = $image;
  }
}
#Sorting the images numerically
natsort(${$GalleryImages_.$i});
closedir($temp_gallery);
}


#Better location for the buttons!!

#Printing the galleries and all the html required for naming, separation, etc.. This is also an iteration
for($i=0; $i<=sizeof($galleries)-1; $i++) 
{
echo('<div class="galleries_hidden" id="gallery_'.$i.'"><hr><br><div class="Gallery_Title"><b><i><big>'.$GalleryTitles[$i].'</big></i></b></div><br>');
$folder=$galleries[$i];
foreach(${$GalleryImages_.$i} as $thumb_image)
{
echo  '<a href="'.$main . $folder .'/'. $big . 'large_'. $thumb_image . '" rel="lightbox['.$folder.']" title="'.$folder.'"><img src="' . $main . $folder .'/'. $thumb_image. '" alt="'.$folder.'" class="Gallery_Image" /></a>';
}
echo('</div>');
}

#Making the buttons to cycle the galleries
for($i=0; $i<sizeof($galleries); $i++) 
{
echo('<input type="button" id="gallery_'.$i.'" value="Show '.$GalleryTitles[$i].'" onclick="showgallery(');echo("'gallery_".$i."');");echo('" /><br><br>');
}

?> 

I have managed to make each aspect work, exept one. The last portion, as commented:

#Making the buttons to cycle the galleries
for($i=0; $i<sizeof($galleries); $i++) 
{
echo('<input type="button" id="gallery_'.$i.'" value="Show '.$GalleryTitles[$i].'" onclick="showgallery(');echo("'gallery_".$i."');");echo('" /><br><br>');
}

This piece of code generates buttons which shows one gallery, and hides the rest. This is done by changing the classes of the divs from "galleries_visible" to "galleries_hidden", as applicable. This is done using a javascript declared in the header as follows:

Code: [Select]
<script type="text/javascript">
function showgallery(id)
{
var divall = document.getElementsByTagName("div");
var i=0;

for (i=0;i<divall.length;i++)
{

if(divall[i].className == "galleries_visible")
{
divall[i].className = "galleries_hidden";
}

var showdiv = document.getElementById(id);
showdiv.className = "galleries_visible";

return false;
}
</script>
When I have the button-generating php code below the gallery-generating php code, then the javascript seems to work, by showing and hiding respective galleries. These galleries and their litebox viewer all work normally. However, when putting the button-creator php above the gallery-generator php, then the buttons appear as normal, and the javascript runs, but it cannot find the div with the id it searches for:

Code: [Select]
var showdiv = document.getElementById(id);
showdiv.className = "galleries_visible";
I am confused. The PHP code makes several arrays which stores all the file and folder information, and these arrays are read by the button-generator irrespective of its position (I know this because the buttons are generated based on the content of non-empty arrays).

Why can't the javascript change the gallery-containing divs when they are below the button-containing div?

Any help is greatly appreciated, I just cant seem to find whats wrong!

Kind regards,

Frederik

Hello:

I am having a brain fart on how to get this done and any ideas would greatly be appreciated. I am working on a in-house mailbox project and have my first problem. I am going to try and explain this a simple as possible as putting the words from my head to screen harder than I thought.

I have a page with 1 div called msgs_main. Inside of that div are 2 more, top one called msgs_msgs and the bottom called msgs_content. The msgs_msgs div contains a simple mysqli query displaying the records that correspond to the user. What I want/need is that when the user clicks one of the rows, the contents of the message are displayed in the msgs_content div.

I could provide the code, if it helps, but I am not really looking for answered code, but a process to learn from, like. "First, get a join and have all the records display in the msg_msgs div. Display them all to see that all the data is there. Later in production, remove the un-necessary fields from top div". Then research .... etc

Hi,   I've been looking at the Bootstrap 3 and various tutorials / example sites even from their own website. This has lead me to a question I cannot seem to find a quick answer to why do they use divs over the new HTML5 tags such as nav.   For example;

<div class="navbar navbar-inverse navbar-fixed-top" role="navigation">
      <div class="container">
        <div class="navbar-header">
          <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
            <span class="sr-only">Toggle navigation</span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
          </button>
          <a class="navbar-brand" href="#">Project name</a>
        </div>
        <div class="collapse navbar-collapse">
          <ul class="nav navbar-nav">
            <li class="active"><a href="#">Home</a></li>
            <li><a href="#about">About</a></li>
            <li><a href="#contact">Contact</a></li>
          </ul>
        </div><!--/.nav-collapse -->
      </div>
    </div>

Comapred to something more like;

<div class="container">
   <nav>
      <ul>
           <li><a href="#"> Home </a></li>
      </ul>
   </nav>
</div>

I know these two examples don't match up in the slightest but I'm not looking for the synatx just an explaniation. Is it the fact that HTML5 is still the draft stages and IE doesn't handle nav to gracefully wihtout shiv etc...   Or is the developer of the examples is just a bit lazy and couldn't be bothered to swap it to the newer tags?   The reason I ask is I'm not too sure which way would be the best for developing a site using bootstrap.   Thanks in advance.

Hi, I used to do form validations in a totally different manner before this that aside. I would like to know how can I do something like this. What happens here is if none of the conditions are met I echo a div containing the error and so on. The problem I am facing is If the first condition is not met it goes to the second condition and at the end there are two error divs at the same time. I want to perform something like, if first condition is not met script stops, echos only the div where the condition is not met and the script does not carry on. If i use the die or exit functions  it dies and html dies with it any solutions or another way?


Code: [Select]
if (strlen($title)<=19)
{

echo "<div id='error'><div id='error_img'><img src='images/warning.gif' width='16' height='16' title='error' /></div> must of be atleast 20 characters. </div>";;

}



if ($on=="-1")
{

echo "<div id='error'><div id='error_img'><img src='images/warning.gif' width='16' height='16' title='error' /></div> Please select. </div>";

} 

 any help is appreciated thanks!

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=348953.0

A friend told me vaguely that there is a possible insecurity with a RFI, in my dynamic image, that reads a players stats off of a seprate web page, parses it, and prints it on the image:


<?php
Header ('Content-type: image/jpeg');
Header('Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0');
Header('Expires: Thu, 19 Nov 1981 08:52:00 GMT');
Header('Pragma: no-cache');

// get CMID variable from the url
$cmid = htmlentities($_GET['cmid']);

if ($cmid < 100000 or $cmid > 999999);
$cmid = 563853;
elseif ($cmid > 100000 and $cmid < 999999);
$cmid = $cmid;
else 
$cmid = 563853;

// create the image using your own background
$image = imagecreatefromjpeg("background.jpg");

// dimensions of the image used
$img_width = 600;
$img_height = 9;

// set the colours
$cool = imagecolorallocate($image, 81, 86, 96);
$black = imagecolorallocate($image, 0, 0, 0);
$white = imagecolorallocate($image, 255, 255, 255);
$red = imagecolorallocate($image, 255, 0, 0);
$grey = imagecolorallocate($image, 204, 204, 204);
$green = imagecolorallocate($image, 206, 129, 18);
$blue = imagecolorallocate($image, 0, 0, 255);
$yellow = imagecolorallocate($image, 225, 225, 0);
$statcolor = $yellow;
// set the font and print text
$font = 'Verdana.ttf';

/*
// counter - CHMOD your counter file to 777
$viewss = file("views.txt");
$views = $viewss[0]; $views++;
$fp = fopen("views.txt", "w");
fwrite($fp, $views);
fclose($fp);
$counter = "$views";

// View Output
imagettftext($image, 7, 0, 16, 117, $yellow, $font, "Views:$counter");
*/

// Attempt to make web content grabber.

function get_url_contents($url){
        $crl = curl_init();
        $timeout = 5;
        curl_setopt ($crl, CURLOPT_URL,$url);
        curl_setopt ($crl, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt ($crl, CURLOPT_CONNECTTIMEOUT, $timeout);
        $ret = curl_exec($crl);
        curl_close($crl);
        return $ret;
}

// Web content grabber execution.
$returned_content = get_url_contents("http://uberstrike.cmune.com/Profile?cmid=$cmid");

// Parsing the returned content for Global Rank.
$clanstart = strpos($returned_content, 'Clan:');
$clanend = strpos($returned_content, '</h2>', $clanstart);
$clanunref = substr($returned_content, $clanstart, $clanend);
$clanrefstart = strpos($clanunref, '[');
$clanrefend = strpos($clanunref, ']', $clanrefstart);
$clan = substr($clanunref, $clanrefstart, $clanrefend);
$clan = html_entity_decode(strip_tags($clan));


// Stripping the parsed Global Rank of HTML.
$clan = html_entity_decode(strip_tags($clan));

// Filtering Clan to only show the value number, not text or formatting in between.
$clan = str_replace ("C", "", $clan);
$clan = str_replace ("l", "", $clan);
$clan = str_replace ("a", "", $clan);
$clan = str_replace ("n", "", $clan);
$clan = str_replace (":", "", $clan);
$clan = str_replace (" ", "", $clan);

// Parsing the returned content for Name.
$namestart = strpos($returned_content, '<span style="color: #FEC42C; font-size: 20px; font-weight: bold;">');
$nameend = strpos($returned_content, '</span>', $namestart);
$name = substr($returned_content, $namestart, $nameend-$namestart);

// Stripping the parsed Name of HTML elements.
$name = html_entity_decode(strip_tags($name));

// Clan and name output.
imagettftext($image, 7, 0, 50, 7, $yellow, $font, "$clan" . "$name");

// Parsing the returned content for Global Rank.
$rankstart = strpos($returned_content, '<h2 style="font-size:14px; font-weight:bold; text-indent:0px; margin-left:25px;">');
$rankend = strpos($returned_content, '<br />', $rankstart);
$rank = substr($returned_content, $rankstart, $rankend-$rankstart);

// Stripping the parsed Global Rank of HTML.
$rank = html_entity_decode(strip_tags($rank));

// Filtering Rank to only show the value number, not text or formatting in between.
$rank = str_replace ("G", "", $rank);
$rank = str_replace ("l", "", $rank);
$rank = str_replace ("o", "", $rank);
$rank = str_replace ("b", "", $rank);
$rank = str_replace ("a", "", $rank);
$rank = str_replace ("R", "", $rank);
$rank = str_replace ("n", "", $rank);
$rank = str_replace ("k", "", $rank);
$rank = str_replace (":", "", $rank);
$rank = str_replace (" ", "", $rank);

// Rank Output.
imagettftext($image, 7, 0, 230, 7, $yellow, $font, "$rank");

$killstart = strpos($returned_content, '<h3 style="color: #FEC42C;">All time record</h3>');
$killend = strpos($returned_content, '</tr>', $killstart);
$kill = substr($returned_content, $killstart, $killend-$killstart);

// Stripping the parsed kill of HTML.
$kill = html_entity_decode(strip_tags($kill));

// Filtering kill to only show the value number, not text or formatting in between.
$kill = str_replace ("K", "", $kill);
$kill = str_replace ("i", "", $kill);
$kill = str_replace ("l", "", $kill);
$kill = str_replace ("A", "", $kill);
$kill = str_replace ("t", "", $kill);
$kill = str_replace ("m", "", $kill);
$kill = str_replace ("e", "", $kill);
$kill = str_replace ("r", "", $kill);
$kill = str_replace ("o", "", $kill);
$kill = str_replace ("d", "", $kill);
$kill = str_replace ("c", "", $kill);
$kill = str_replace ("s", "", $kill);
$kill = str_replace (" ", "", $kill);
$kill = trim($kill);

// Cannon Stats output.
imagettftext($image, 7, 0, 410, 7, $yellow, $font, $kill);

// Parsing the returned content for KDR.
$KDRstart = strpos($returned_content, '<span title="Kill Death Ratio">KDR</span>');
$KDRend = strpos($returned_content, '</tr>', $KDRstart);
$KDR = substr($returned_content, $KDRstart, $KDRend-$KDRstart);

// Stripping the parsed KDR of HTML.
$KDR = html_entity_decode(strip_tags($KDR));

// Filtering KDR to only show the value number, not text or formatting in between.
$KDR = str_replace ("K", "", $KDR);
$KDR = str_replace ("D", "", $KDR);
$KDR = str_replace ("R", "", $KDR);
$KDR = str_replace (" ", "", $KDR);
$KDR = trim($KDR);

// KDR Output.
imagettftext($image, 7, 0, 323, 7, $yellow, $font, "$KDR");

// IP Logger
$logfile= 'iplog.html';
$IPlog = $_SERVER['REMOTE_ADDR'];
$logdetails=  date("F j, Y, g:i a") . ': ' . '<a href=http://www.ip2location.com/demo.aspx?ip='.$_SERVER['REMOTE_ADDR'].'>'.$_SERVER['REMOTE_ADDR'].'</a>';
$fplog = fopen($logfile, "a"); 
fwrite($fplog, $logdetails);
fwrite($fplog, "<br>");
fclose($fplog); 

// output and destroy
imagepng($image);
imagedestroy($image);

?>

I have a script that saves a full size and a cropped version that is re-sized to 200x200. The full size saves just fine the cropped and re-sized version is all messed up.

Example:



Here is the cropped and re-size code:

Code: [Select]
$new_cropped_image_resource = imagecreatetruecolor(200, 200);
      switch($photo["ext"]){
   
    case "gif":
      $cropped_image = imagecreatefromgif($processing_image_temp_name_cropped);
    break;

    case "jpg":
      $cropped_image = imagecreatefromjpeg($processing_image_temp_name_cropped);
    break;

    case "png":
      $cropped_image = imagecreatefrompng($processing_image_temp_name_cropped);
    break;

      }
      list($cropped_width, $cropped_height) = getimagesize($processing_image_temp_name_cropped);
      imagecopyresampled($new_cropped_image_resource,$cropped_image,0,0,0,0,200,200,$cropped_width,$cropped_height);
      switch($photo["ext"]){
   
    case "gif":
      imagegif($new_cropped_image_resource, $processing_image_temp_name_cropped);
    break;

    case "jpg":
      imagejpeg($new_cropped_image_resource, $processing_image_temp_name_cropped, 100);
    break;

    case "png":
      imagepng($new_cropped_image_resource, $processing_image_temp_name_cropped);
    break;

      }
Any ideas? I'm stuck :/

Thanks for any help
-Shane

Hi guys

I have IPN setup for my online shop which is working fine but when payment is confirmed, my shop should send a link confirming purchase along with list of items, so I have added that to my IPN, there is an issue, it owuldnt send the email, I have checked every table/column name and they are correct, IPN works because I receive paypal confirmation email and updates database, so something should be wrong with they way I have written the code to send this email.

Please find the code below, I have deleted some un-necessary info:

Code: [Select]

<?
include ('includes/db.php');

// PHP 4.1

// read the post from PayPal system and add 'cmd'
$req = 'cmd=_notify-validate';

foreach ($_POST as $key => $value) {
$value = urlencode(stripslashes($value));
$req .= "&$key=$value";
}

// post back to PayPal system to validate
$header .= "POST /cgi-bin/webscr HTTP/1.0\r\n";
$header .= "Content-Type: application/x-www-form-urlencoded\r\n";
$header .= "Content-Length: " . strlen($req) . "\r\n\r\n";
$fp = fsockopen ('ssl://www.sandbox.paypal.com', 443, $errno, $errstr, 30);

// assign posted variables to local variables
$item_name = $_POST['item_name'];
$item_number = $_POST['item_number'];
$payment_status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];
$order_id = mysql_real_escape_string((int)$_POST['custom']);

if (!$fp) {
// HTTP ERROR
} else {
fputs ($fp, $header . $req);
while (!feof($fp)) {
$res = fgets ($fp, 1024);
if (strcmp ($res, "VERIFIED") == 0) {

if ($payment_status=='Completed') {
$txn_check=mysql_query("SELECT txn_id FROM orders WHERE txn_id='$txn_id'");
if (mysql_num_rows($txn_check)!=1) {
if($receiver_email=='me@mydomain.com'){

//////////
$get=mysql_query("SELECT amount FROM orders WHERE amount='$payment_amount'");
while ($get_row=mysql_fetch_array($get)) {
$amount=$get_row['amount'];
}

if($amount==$payment_amount && $payment_currency=='GBP') {

$update=mysql_query("UPDATE orders SET confirmed='1', txn_id='$txn_id' WHERE order_ref='$order_id'");
$select=mysql_query("SELECT * FROM ordered_product WHERE order_ref='$order_id'");
while($row=mysql_fetch_array($select))
{
    $product_number=$row['product_ref'];
    $quantity_ordered=$row['quantity_ordered'];
$update=mysql_query("UPDATE products SET instock=instock-1 WHERE product_ref='$product_number'");
}



$select=mysql_query("SELECT * FROM orders WHERE order_ref='order_id' AND confirmed='1'");
while ($row=mysql_fetch_array($select)) {
$order_number=$row['order_ref'];
$name=$row['user_name'];
$email=$row['user_email'];
$address1=$row['address_1'];
$address2=$row['address_2'];
$address3=$row['address_3'];
$city=$row['city'];
$postcode=$row['postcode'];
$country=$row['country'];
$amount=$row['txn_id'];
$date=$row['order_date'];
}

$select=mysql_query("SELECT * FROM ordered_product WHERE order_ref='$order_id'");
while($get_row=mysql_fetch_array($select)) {
$product_ref=$get_row['product_ref'];
$quantity=$get_row['quantity_ordered'];
}

$select=mysql_query("SELECT * FROM products WHERE product_ref='$product_ref'");
while($get_row=mysql_fetch_array($select)) {
$product_name=$get_row['product_name'];
$product_price=$get_row['price'];

echo "<table width='439' border='0' cellspacing='0' cellpadding='0'>
            <tr>
              <td width='219'>$product_name</td>
              <td width='120'>$quantity</td>
              <td width='98'>&pound;$product_price</td>
            </tr>
      </table>";

}

/////////     
$headers=array(
'From:me@mydomain.com',
'Content-Type:text/html'
);
   
$body="<table width='492' border='0' cellspacing='0' cellpadding='0' style='font-family:Verdana, Geneva, sans-serif; font-size:12px; color:#333;'>
  <tr>
    <td width='492' height='374' valign='top'><table width='497' border='0' cellspacing='0' cellpadding='0'>
      <tr>
        <td width='497' height='97'><img src='../images/logo.png'/></td>
      </tr>
      <tr>
        <td>Thank you for ordering. Your order should arrive in the next 2-3 days.</td>
      </tr>
      <tr>
        <td height='48'><strong>ORDER NUMBER:</strong> $order_number</td>
      </tr>
      <tr>
        <td height='48'><p><strong>DELIVERY ADDRESS: </strong></p>
          <p>$address1 <br/> $address2 <br/> $address3 <br/> $city <br/> $postcode <br/> $country</p>
          <p>&nbsp;</p></td>
      </tr>
      <tr>
        <td height='48'><p><strong>YOUR ORDER:</strong></p>
          <table width='439' border='0' cellspacing='0' cellpadding='0'>
            <tr>
              <td width='219'><strong>Item</strong></td>
              <td width='120'><strong>Quantity</strong></td>
              <td width='98'><strong>Price</strong></td>
            </tr>
          </table><br/>
          <table width='439' border='0' cellspacing='0' cellpadding='0'>
            <tr>
              <td width='219'>$product_name</td>
              <td width='120'>$quantity</td>
              <td width='98'>&pound;$product_price</td>
            </tr>
      </table>
          <p>&nbsp;</p></td>
      </tr>
      <tr>
        <td height='48'><p><strong>Sub Total:</strong> &pound;amount<br/>
        </p></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td height='374' valign='top'><strong>N.B Any sales items are non-returnable</strong></td>
  </tr>
</table>
";    

$subject = "ORDER CONFIRMATION - ";
mail($to, $subject, $body, implode("\r\n",$headers));



}

////////

}
}
}
}
else if (strcmp ($res, "INVALID") == 0) {
header('Location: payment-error.php');
}
}
fclose ($fp);
}
?>


Thank you all in advance

hi phpfreaks,

I have been using learning the pdo library. But I am really stuck on this one query. The above sql statement works if in phpadmin I get three results but for the life of me I can't get them with the code below. I have tried I am trying to return all columns in an array some thing like

array (0=>array(0=>business blah, etc

)

I have been playing with the fetch mode to try and achieve this but I can't get any results  not even an obj but I am not getting any errors. Is the code below wrong?
Code: [Select]
$query = "SELECT Business_Name,First_Name,Last_Name,Username,Email,Phone,Mobile,Social_Media,Web_Site,User_Language,Admin_Level FROM customer WHERE Admin_Level ='Admi'";
  try {
            //$this->dataObj->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
             $this->dataObj->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING );
            $sth = $this->dataObj->prepare($query);
            $stmt = $this->dataObj->query($query);
            $stmt->setFetchMode();
            $result = $stmt->fetchAll();
        } catch (PDOException $e) {

            $e->getMessage();
        }

        return $result;
   
}