PHP - Php Errors Wont Load Webpage

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

Hi All,

I have a form which POSTs data through to PHP, it then places this on a HTML mail and then emails the company. I then have two attachment fields on the form, one for their CV and the other for some sort of ID.

The attachments appear on the HTML email but when you try and open them or download and open them they come up with an error as though they are corrupt. However the odd thing is if I open it on my iPhone the attachments work perfect. Its not just my PC at fault as it doesnt work on many computers/OS's.

The actual PHP attachment code is below:

Code: [Select]
<?php

$unid = md5(time());

for($i=0;$i<count($_FILES["fileAttach"]["name"]); $i++) {  

if($_FILES["fileAttach"]["name"][$i] != "") { 

$filename = $_FILES["fileAttach"]["name"][$i];  
$attachment = chunk_split(base64_encode(file_get_contents($_FILES["fileAttach"]["tmp_name"][$i])));  
$mailheader .= "--" . $unid . "\n";  
$mailheader .= "Content-Type: multipart/mixed; name=" . $filename . "\n";  
$mailheader .= "Content-Transfer-Encoding: base64"."\n";  
$mailheader .= "Content-Disposition: attachment; filename=" . $filename . "\n";  
$mailheader .= $attachment;

} }
?>

What am I doing wrong. More code can be provided if needed.

Cheers in advance!

I HAVE TRIED looking at it  but i am new to php so i can't figure out what i did wrong  help please !!!!!!!!!!!!




Fatal error: Call to undefined method modernCMS::update_form() in C:\wamp\www\test\inc\update-content.php on line 4

----
Page that's accessing code
-----
<?php

include '../test/inc/admin/nav.php';
echo $obj->update_form($_GET['id']);

?>

------
function
------

<?php

class modernCMS {

var $host;
var $username;
var $password;
var $db;

function connect() {
$con = mysql_connect($this->host, $this->username, $this->password) or die(mysql_error());
mysql_select_db($this->db, $con) or die(mysql_error());

} //end connect

function get_content($id = '') {

if($id != ""):
$id = mysql_real_escape_string($id);
$sql = "SELECT * FROM cms_content WHERE id = '$id'";

// $return = "<p><a href=../test/inc/admin/nav.php>Go Back To Content</a></p>";

else:
$sql = "SELECT * FROM cms_content ORDER BY id DESC";
endif;

$res = mysql_query($sql) or die(mysql_error());

if(mysql_num_rows($res) != 0):
while($row = mysql_fetch_assoc($res)) {
echo '<table bgcolor="#975627" width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td height="25" background="images/menu.gif"><center><strong>' . $row['title'] . '</strong></center></td>

</tr>
<tr bgcolor="975627"><td height="0"></td></tr>

<tr>
<td bgcolor="#181818">
';
echo '<br>
<div align="center">' . $row['body'] . ' <br><br>
</td>

</tr>

<tr>
<td height="25" background="images/menu.gif">
</td>

</tr>

</table><br><br>
';
}
else:
echo '<p>Uh Oh!!! </p>';
endif;

// echo $return;


} //end get_content

function add_content($p) {
$title = mysql_real_escape_string($p['title']);
$body = mysql_real_escape_string($p['body']);

if(!$title || !$body):

if(!$title):
echo "<p>The title is required!</p>";
endif;
if(!$body):
echo "<p>The body is required!</p>";
endif;

echo '<p><a href="add-content.php">Try Again!!!</a></p>';

else:
$sql = "INSERT INTO cms_content VALUES (null, '$title', '$body')";
$res = mysql_query($sql) or die(mysql_error());
echo "Added Successfully!";
endif;
} //end add_content

function manage_content() {
$sql = "SELECT * FROM cms_content ORDER BY id DESC";
$res = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_assoc($res)):

?>

<div>
<h2 class="title"><?php echo $row['title']; ?></h2>
<span class="actions"<a href="../test/update-content.php?id=<?php echo $row['id']?>">Edit</a> | <a href="?delete=

<?php

echo $row['id']

?>

">Delete</a></span>
</div>

<?php
endwhile;
echo '</div>'; //Class Manage Div

} //end manage_content

function delete_content($id) {
if(!$id) {
return false;
}else {
$id = mysql_real_escape_string($id);
$sql = "DELETE FROM cms_content WHERE id = '$id'";
$res = mysql_query($sql) or die(mysql_error());
echo "Content Deleted Successfully!";
}
}
} //end delete_content

function update_form($id) {
$id = mysql_real_escape_string($id);
$sql = "SELECT * FROM cms_content WHERE id = '$id'";
$res = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($res);

?>

<form method="post" action="./post-added.php">

<input type="hidden" name="update" value="true" />
<input type="hidden" name="id" value="<?php $row['id'] ?>" />

<div>
<label for="title">Title:</label>
<input type="text" name="title" id="title" value="<?php echo $row['title'] ?>" />
</div>

<div>
<label for="body">Body:</label>
<textarea name="body" id="body" rows="8" cols="40" /><?php echo $row['body'] ?></textarea>
</div>

<input type="submit" name="submit" value="Update Content" />

</form>
<?php

} //end update_content_form

function update_content($p) {
$title = mysql_real_escape_string($p['title']);
$body = mysql_real_escape_string($p['body']);
$id = mysql_real_escape_string($p['id']);

if(!$title || !$body):

if(!$title):
echo "<p>The title is required!</p>";
endif;
if(!$body):
echo "<p>The body is required!</p>";
endif;

echo '<p><a href="update-content.php?id=' . $id . '">Try Again!!!</a></p>';

else:
$sql = "UPDATE cms_content SET title = '$title', body = '$body' WHERE id = '$id'";
$res = mysql_query($sql) or die(mysql_error());
echo "Updated Successfully!";
endif;
} //end update_content($p)



?>

I'm writing a script that opens a webpage and pulls out the pictures for editing.

The problem I'm having is the pictures are protected from hotlinking with htaccess. The script is on a different domain.

I know it's possible to do this but after much searching and experimentation I can't work it out.

Any ideas?

try {
echo "<br>";
foreach($dbh->query("SELECT * FROM test_shot WHERE sold=1 ORDER BY year ASC") as $row) {
	
						if($row['picture'] != "" && $row['picture'] != null)
						{
						echo "<div class='image-holder'><img src ='".$row['picture']."' width=300px /><br>";  
            			}
						if($row['year'] != "" && $row['year'] != null)
						{
							echo $row['year'];
						}
						if($row['description'] != "" && $row['description'] != null)
						{
							echo $row['description'];
						}
						if($row['sold'] == 1) {
							echo "<img src='images/sold1.png'><br>";//Add your image code here
							}
							elseif ($row['sold'] == 0) {
							
							echo "</div><br>";
						}
					}

	}	

catch (PDOException $e) {
  print $e->getMessage();
}

?>