PHP - Row Wont Display Image

Hey,

Im having a problem where it wont show the members name only TBA, i was wondering if anyone could spot whats wrong

Code - http://pastebin.com/8mEGcTqd
page - http://tw.tghq.org/rosters/hto_roster_blistig.php

I have a table that needs to display data and its formatting should allow a scroll bar after a bit of length. In this case, the below code seems to allow it to continue well past the footer of the page... Did I miss something obvious?

                    <div class="col-md-12">
                        <div class="card card-plain">
                            <div class="header">
                                <h4 class="title">Current Vendors</h4>
                                <p class="category">Vendors listed as active within VendorBase.</p>
                            </div>

							<?php
							$con=mysqli_connect("localhost","root","test","vendors");
							// Check connection
							if (mysqli_connect_errno())
							{
							echo "Failed to connect to MySQL: " . mysqli_connect_error();
							}

							$result = mysqli_query($con,"SELECT * FROM vendor_data");

							echo "                  <div class='content table-responsive table-full-width'>
															<table class='table table-hover'>
																<thead>
																	<th>Name</th>
																	<th>Type</th>
																	<th>Company</th>
																	<th>Email</th>
																	<th>SOC2 Report</th>
																	<th>Status</th>
																	


																</thead>
																<tbody>";
																
																while($row = mysqli_fetch_array($result))
																{
																echo "<tr>";
																echo "<td>" . $row['name'] . "</td>";
																echo "<td>" . $row['type'] . "</td>";
																echo "<td>" . $row['company'] . "</td>";
																echo "<td>" . $row['email'] . "</td>";
																echo "<td>" . $row['soc'] . "</td>";
																echo "<td>" . $row['status'] . "</td>";							
																echo "</tr>";
																}
															
														echo "</table>";
											    echo "</div>";
																mysqli_close($con);
							?>
                                </table>

                            </div>
                        </div>
                    </div>

 

Hi all,

I need some help with my code as I've a trouble with sending the emails with images attachments. I'm using Pear Mail library to send the emails so when I send the emails with attachments to gmail, I am unable to see the attached images in my gmail inbox as there is no images show on the bottom of the subject unless when I open on my email so I can see the images attachments. And I am unable to see the images on yahoo when i sent the emails, so I sent a test email on my webmail with the images as attachments and I can see the images on gmail and yahoo with no problem. I think there is a problem with my PHP script that need to be resolve. 

Here is where I am getting the problem with:
       

//attachments
        if (is_array($email_attachments)) {
            foreach ($email_attachments as $attachments) {
                $filename = str_replace('uploads/', '', $attachments);
                $attachment = '';
                $file_path = '';
                $type = '';

                if (strpos($filename, '.png') !== false) {
                    $type .= 'image/png';
                }
    
                // ADD attachment(s)
                $attachment1 .= "--$boundary1\r\n";
                $attachment1 .= "Content-Type: $type; name=\"$filename\"\r\n";
                $attachment1 .= "Content-Transfer-Encoding: base64\r\n";
                $attachment1 .= "Content-Disposition: attachment; filename=\"$filename\"\r\n";
                $attachment1 .= "\r\n\r\n";
                $attachment1 .= $attachment;
                $attachment1 .= "\r\n\r\n";

                $body .= $attachment1;
                $mime->addAttachment($file_path, $type);
            }
        }

 

 

Here is the full code:

<?php

require_once('Mail.php');
require_once('Mail/mime.php');
require_once('Mail/IMAPv2.php');

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

//Connect to the database
include('config.php');

// Connect to the server:
$username = 'myusername';
$password = 'mypassword';
$smtp_hostname = "smtp.mydomain.com";
$port = "587";
$attached_files = array();
$inline_images = array();
global $inline_images;

if (isset($_POST['send_to']))
{
    $from = "Mark <name@mydomain.com>";
    $to_email = $_POST['send_to'];
    $subject = $_POST['email_subject'];
    $message ='<div dir="ltr">' . $_POST['email_body'] . '</div>';
    $email_attachments = $_POST['email_attachment'];
    $total_emails = count($to_email);
    $email_number = $_POST['email_number'];
    $sent_message = $message;
    $attachment1 = '';
    $inline_id = 0.1;
    $success = '';
    $base64 = [];
    $src = [];

    //Check if the images is base64
    if (strpos($message, 'data:image/') !== false)
    {
        // read all image tags into an array
        preg_match_all('/<img.*?src="data:image\/.*;.*,(.*)".*?>/i', $message, $match, PREG_PATTERN_ORDER);
        $base64 = array_pop($match);

        if (is_array($src)) 
        {
            foreach($base64 as $images)
            {
                $type = end(explode('/', (explode(';', $images))[0]));
                $filename = md5(time().uniqid()). '.' . $type;
                $base64_string = str_replace('data:image/png;base64,', '', $images);
                $base64_string = str_replace(' ', '+', $base64_string);
                $decoded = base64_decode($base64_string);
                $fp = fopen("uploads/". $filename, "w+");
                fwrite($fp, $decoded);
                fclose($fp);
            }
        }
    }

    //check if the inline images is in the array
    if (strpos($message, '<img src=') !== false)
    {
        // read all image tags into an array
        preg_match_all('@src="([^"]+)"@' , $message, $match);
        $src = array_pop($match);

        if (is_array($src)) 
        {
            foreach ($src as $key => $value)
            {
                $parsed = parse_url($src[$key]);
                $filename = basename($parsed['path']);
                $content = file_get_contents($src[$key]);

                if (!file_exists($filename))
                {
                    $fp = fopen("uploads/". $filename, "w+");
                    fwrite($fp, $content);
                    fclose($fp);
                }
            }
        }
    }
    $boundary1 = '###'.md5(microtime()).'###';
    $boundary2 = '###'.md5(microtime().rand(99,999)).'###';


    foreach ($to_email as $to)
    {
        $name = '';
        $email = '';


        if (strpos($to, ' <') !== false) {
            $name_str = explode(' <', $to);
            $email_str = explode(' <', $to);
            $name = $name_str[0];
            $email = str_replace('>', '', $email_str);
            $email = $email[1];
        }
        $messageID = sprintf("<%s.%s@%s>",
            base_convert(microtime(), 10, 36),
            base_convert(bin2hex(openssl_random_pseudo_bytes(8)), 16, 36),
            'mydomain.com');
        $message_id = getMessageid(isset($message_id));
        $now = new DateTime();
        $email_id = $now->getTimestamp();
        $sent_date = date('Y-m-d H:i:s');
        $sent_mailbox1 = $link->prepare("SELECT * FROM sent WHERE message_id = ?");
        $sent_mailbox1->execute([$message_id]);
        $emailID = '';
        
        if (!$name == '' && !$email == '') {
            if ($name == $email) {
                $to = $email;
            }
        }


        if ($sent_mailbox1->rowCount() == 0)
        {
            $sent_mailbox1 = $link->prepare("INSERT INTO sent (from_email, to_email, message_id) VALUES (?,?,?)");
    
            if ($sent_mailbox1->execute([$from, $to, $message_id]))
            {
                $emailID = $link->lastInsertId();
            }
        }


        //check if the images is base64
        if (is_array($base64)) 
        {
            $sent_message .= 'http://mydomain.com/u/?id='.$email_id.'&attid='.$inline_id.'&msgid='.$message_id.'&view=attachment&display=view';
            $inline_id += 0.1;
        }
        else if (!$base64 == '') {
            $sent_message .= 'http://mydomain.com/u/?id='.$email_id.'&attid='.$inline_id.'&msgid='.$message_id.'&view=attachment&display=view';
            $inline_id += 0.1;
        }


        //check if the inline images is in the array
        if (is_array($src)) 
        {
            $sent_message .= 'http://mydomain.com/u/?id='.$email_id.'&attid='.$inline_id.'&msgid='.$message_id.'&view=attachment&display=view';
            $inline_id += 0.1; 
        }
        else if (!$src == '') {
            $sent_message .= 'http://mydomain.com/u/?id='.$email_id.'&attid='.$inline_id.'&msgid='.$message_id.'&view=attachment&display=view';
            $inline_id += 0.1;
        }
        $message .= '<img src="http://mydomain.com/track/Images/signature.gif?id='.$emailID.'&etc='.time(). '" ' . 'style="width:0;max-height:0;overflow:hidden" alt="">';


        $headers = array ('From' => $from, 
            'To' => $to, 
            'Subject' => $subject,
            'Reply-To' => $from,
            //'Content-Type'  => 'Content-Type: text/plain; charset="UTF-8"',
            'Content-Type'  => 'Content-Type: multipart/mixed; boundary="=_d909e7abc497193ad3b6636530382391"',
            'MIME-Version' => '1.0',
            'Received' => 'from mail.mydomain.com',
            'Date'  => date("r"),
            'Message-ID' => '<'.sha1(microtime(true)).'@mydomain.com>');


        $crlf = "\r\n";
        $mime = new Mail_mime(array('eol' => $crlf));
        //$mime = new Mail_mime("\r\n");
        $html = $message;
        $text = strip_tags($html);
        $body = $html;

        $mime->setTXTBody($text);
        $mime->setHTMLBody($html);

        //check if the img tags have url called display=view
        if (strpos($message, 'display=view') !== false) {
            $pattern = '@src="([^"]+)"@';
            $message = preg_replace_callback($pattern,"setImageLinks", $message);
    
            foreach ($inline_images as $inline_image) {
                $file_path =  $inline_image;
                $typeInt = imagetype($file_path);
    
                //code goes here to find the imagetype case
                switch ($typeInt) {
                    case IMG_GIF:
                        $imageType = 'image/gif';
                        break;
                    case IMG_JPG:
                        $imageType = 'image/jpg';
                        break;
                    case IMG_JPEG:
                        $imageType = 'image/jpeg';
                        break;
                    case IMG_PNG:
                        $imageType = 'image/png';
                        break;
                    case IMG_WBMP:
                        $imageType = 'image/wbmp';
                        break;
                    case IMG_XPM:
                        $imageType = 'image/xpm';
                        break;
                    default: 
                        $imageType = 'unknown';
                }
                $mime->addHTMLImage($file_path, $imageType);
            }
        }


        //attachments
        if (is_array($email_attachments)) {
            foreach ($email_attachments as $attachments) {
                $filename = str_replace('uploads/', '', $attachments);
                $attachment = '';
                $file_path = '';
                $type = '';

                if (strpos($filename, '.png') !== false) {
                    $type .= 'image/png';
                }
    
                // ADD attachment(s)
                $attachment1 .= "--$boundary1\r\n";
                $attachment1 .= "Content-Type: $type; name=\"$filename\"\r\n";
                $attachment1 .= "Content-Transfer-Encoding: base64\r\n";
                $attachment1 .= "Content-Disposition: attachment; filename=\"$filename\"\r\n";
                $attachment1 .= "\r\n\r\n";
                $attachment1 .= $attachment;
                $attachment1 .= "\r\n\r\n";

                $body .= $attachment1;
                $mime->addAttachment($file_path, $type);
            }
        }

        // always call these methods in this order
        $mime_params = array(
            'text_encoding' => '7bit',
            'text_charset'  => '"UTF-8"',
            'html_charset'  => '"UTF-8"',
            'head_charset'  => '"UTF-8"'
        );
        //$body = $mime->get(array('text_encoding' => '8bit','html_encoding' => '8bit'));
        $body = $mime->get($mime_params);
        $headers = $mime->headers($headers);

        $smtp_params = array ('host' => $smtp_hostname,
            'port' => $port,
            'auth' => true, // Note 1
            'username' => $username,
            'password' => $password);

        $smtp = Mail::factory('smtp', $smtp_params);
        $mail = $smtp->send($to, $headers, $body);
        

        if (PEAR::isError($mail)) 
        {
            echo("<p>" . $mail->getMessage() . "</p>");
        }
        else 
        {
            echo("<p>Email has been sent!</p>");
            $response = array("success"=>$success);
            echo json_encode($response);
        }
    }
}

 

Do you know why the images wont show up on yahoo and gmail when I send the images as attachment?

I have checked on the image path and i have put the correct image path so it should work fine.

If you can be able to test it for me to find out why the images wont display and if you fix the issue, please let me know what change I need to make so I will try it out.

 

Any advice would be much appreciated.

Thanks in advance.

Edited June 5, 2020 by mark107

This is the query which should likes salestrack productid with printers productid, but even though there are data no result is showing and I really dont know why. Please help


Code: [Select]
SELECT salestrack.orderid AS orderid, salestrack.salesman AS salesman, printers.rrp AS price, salestrack.name AS name, salestrack.phone AS phone, salestrack.email AS email, printers.name AS printername, salestrack.orderdate AS orderdate, salestrack.status AS
STATUS
FROM printers, salestrack
WHERE salestrack.productid = printers.productid
AND salestrack.status = 'OPEN'
ORDER BY salestrack.orderdate

Hey guys,

I have a problem with my quote thing, i have a few long quotes that i want to word wrap

My code:
<?php

/**
 * @author Jragon
 * @copyright 2010
 */

    Header ("Content-type: image/gif");
    $textfile = "quotes.txt";
    $quotes = array();
    if(file_exists($textfile)){
        $quotes = explode("\n",file_get_contents($textfile));
        srand ((float) microtime() * 10000000);
        $string = $quotes[array_rand($quotes)];
        $string= wordwrap($string, 50, "\n", true);
    } else {
        $string = "Sig file non-existant...";
    }
    $font = 3;
    $width = ImageFontWidth($font)* strlen($string);
    $height = ImageFontHeight($font);
    $im = ImageCreate($width,$height);
    $x=imagesx($im)-$width ;
    $y=imagesy($im)-$height;
    $background_color = imagecolorallocate ($im, 242, 242, 242); //white background
    $text_color = imagecolorallocate ($im, 0, 0,0);//black text
    $trans_color = $background_color;//transparent colour
    imagecolortransparent($im, $trans_color);
    imagestring ($im, $font, $x, $y, $string, $text_color);
    imagegif($im);
    ImageDestroy($im);
?>

The where the line breake should be there is a strange symbol, also there is a symbol at the end of eatch line.


Thanks

Jragon

Would like to be able to click on a radio button that represents an image. Once selected and submitted, have that image display on another page. I have an idea, but need some guidance.

BTW, is using php only doable? Is there a simpler or more elegant way to do this?

Thanks all!

Hello,
Five images will be displayed inside a division.
There will be a previous and next button/link.
If someone click the next button the next image will be added in that div and the first image will be gone from that div.
The previous button/link will do the same thing.

Is it possible with php?
I am confused if it's a javascript or ajax question.

Thanks.

i need help trying to get this delete feature to work its not deleting from the database (by the way i took out my database names and passwords at the top of the file)

is it possible someone could help me, ive been working on this for like a week and cant figure out the problem. thanks! you can email me at spr_spng@yahoo.com


picture 2.png is showing what it looks like




Code: [Select]
<?php
$host="localhost"; // Host name
$username="username"; // Mysql username
$password="password"; // Mysql password
$db_name="database_name"; // Database name
$tbl_name="table_name"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);


?>
<style>
/*table affects look of the whole table look */
table {
margin-left: auto;
margin-right: auto;
border: 1px solid #330000;
border-collapse:collapse;
width:70%;

border-width: 5px 5px 5px 5px;
border-spacing: 1px;
border-style: outset outset outset outset;
border-color: #330000 #330000 #330000 #330000;
border-collapse: separate;
background-color: #330000;


#800517

f535aa

#330000 school color
#9A0000 school color2
#991B1E school color3
#CCCC99 school color4
#9A0000

}
/*th is table header */
th {
text-align: left;
height: 2.5em;
background-color: #330000;
color: #FC0;
font-size:1.5em;
}
/*td is table data or the cells below the header*/
td {
text-align: left;
height:1.0em;
font-size:1.0em;
vertical-align:bottom;
padding:10px;

border-width: 5px 5px 5px 5px;
padding: 8px 8px 8px 8px;
border-style: outset outset outset outset;
border-color: #9A0000 #9A0000 #9A0000 #9A0000;
background-color: #CCCC99;
-moz-border-radius: 0px 0px 0px 0px;

}
</style>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF">&nbsp;</td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Pick Which Rows you want to delete, Then press delete.</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
<td align="center" bgcolor="#FFFFFF">delete</td></tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['name']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?
// Check if delete button active, start this // edited
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

I have a script that uploads my images to a folder and database which works fine. I am looking to display my images on the fly to resize them. How do I intergrate my image output string with the fly string.

Current output
Code: [Select]
echo '<img src="' . $dir . '/' . $image_id . '.jpg">';

Fly string
Code: [Select]
<img src="/scripts/thumb.php?src=/images/whatever.jpg&h=150&w=150&zc=1" alt="" />

Thanks for your help

Hey there I am having a problem where I am pulling the records for images from my database and then trying to display them. What happens is there are three images in the database and I want to display them. My code displays the images but it only shows two of the three.  I know there are three images in the database I put them in and checked just to make sure. It just seems to only want to display two images instead of three.

Here's the code:$getImages = "SELECT * FROM Images WHERE SKU = '".$sku."'";
$resultGetImages = mysql_query($getImages);
$records = mysql_fetch_assoc($resultGetImages);
?>
     while($records = mysql_fetch_assoc($resultGetImages)){
                
        echo "<a onclick=\"document.getElementById('placeholder').src='../../".$records['Path']."'\" target=\"_blank\"><img src=\"../../".$records['ThumbPath']."\" alt=\"".$records['Description']."\" height=\"".$records['ThumbWidth']."\" /></a>\n";
      }
?>

I have tried a for loop as well but it displayed more images than were in the database and just a single image over and over again. I know that was a flaw in my code and I'm not even sure a for loop would even be a reasonable way to go.

Don't know if it is php or html but the image won't display.

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" >
<head>
<meta name="google-site-verification" content="y_kspZkCZOQM-WGNB_lQ8BhJS8p7-B66hkHI_UhzKbs" />
<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-language" content="en" />
<link type="text/css" rel="stylesheet" href="css/reset.css"  />
<link type="text/css" rel="stylesheet" href="css/960.css"  />
<link type="text/css" rel="stylesheet" href="css/custom.css"  />
        <title>Bay Area Remote Control Society</title>
</head>
    <body>
        <div id="wrapper" class="container_12">
            <div id="header" class="grid_12">
                <div id="left-header" class="grid_5 alpha"><?php include('content/left-header.php'); ?></div>
                <div id="newsflash" class="grid_7 omega"><?php include('content/newsflash.php'); ?></div>
            </div>
            <div id="leftmenu" class="grid_3"><?php include('content/menu2.php'); ?></div>
            <div id="maincontent" class="grid_9"><?php include('content/maincontent.php'); ?></div>
            <div id ="footer" class="grid_12"><?php include('content/footer.php'); ?></div>
        </div><!-- end wrapper -->
    </body>
</html>
left-header.php
Code: [Select]
<?php

?>   
<img src="Pictures_Other/concorde.jpg" alt="concorde" border="0" width="250" height="188" />

Hi im wanting to create this system where it loads all your files in a specified directory, loads all the images, although i have done that what im trying to do is have it so it prints them into a 9x9 grid automatically, in which i need to find something to restrain the echo of the variable to a limit of 9..  i need to create the <tr><th>and <td>'s automatically and also id like it so if there is more than 9, it will allow me to select a button which will load up the next section of images. heres the code i have so far:

<?php
$dir = "images/";
$dh  = opendir($dir);
while (false !== ($filename = readdir($dh))) {
    $files[] = $filename;
}

sort($files);
print_r($files); 


I then used this to try and echo into a table :S
<?php
if ($handle = opendir('images/')) {


      while (false !== ($file = readdir($handle))) {
  echo "<table width='450px' height'450px' border='4px solid #000'>";
if ($file != "." && $file != ".."){
echo "<tr><td>$file<br></td>";
echo "<td><img src=images/".$file." height='20px' width='20px'></td></tr><br>";
    }
}
echo "</table>";
closedir($handle);
}

?>

They are seperate as i havent merged together as i wud like to get them working first.

I was trying to do the max and min on the array numbers but was stuck doing that.

Any help would be greatly apprecated
Many thanks
Lewis Stevens

Hey there, my problem is that I am trying to pull three images from a database and then displaying them with a large image above them. I want to then be able to click the smaller ones and then they become the larger one(kind of like on amazon). I am having 2 major problems with it at this point. the first is my while statement is only pulling 2 of the three images from the database, and secondly my image replacement javascript replaces with the smaller image. With the javascript it dosen't have to be done that way or in javascript so a link or suggestions on how to do that better would be great.

So here's my code:
<?php
include('../../php/includes/openDbConn.php');
$sku = 'c-111111';
$getImages = "SELECT * FROM Images WHERE SKU = '".$sku."'";
$resultGetImages = mysql_query($getImages);
$records = mysql_fetch_assoc($resultGetImages);
?>
   <img src="../../<?php echo $records['Path'] ?>" id="placeholder" alt="<?php echo $record['Description']; ?>" height="<?php echo $record['Width']; ?>" />
    <div id="thumbImages">
      <?php
while($records = mysql_fetch_assoc($resultGetImages)){
    echo "<a onclick=\"document.getElementById('placeholder').src='../../".$records['ThumbPath']."'\" target=\"_blank\"><img src=\"../../".$records['ThumbPath']."\" alt=\"".$records['Description']."\" height=\"".$records['ThumbWidth']."\" /></a>\n";
}
?>

and a bit on the table with the images. It stores the sku and the Path of a thumbnail, regular and large sized image. All help is much appreciated.