PHP - Moved: Using Images With Php And Sql

This topic has been moved to CSS Help.

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

This topic has been moved to Third Party PHP Scripts.

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

This topic has been moved to CSS Help.

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

This topic has been moved to Other Libraries and Frameworks.

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

I have this script from http://lampload.com/...,view.download/ (I am not using a database) I can upload images fine, I can view files, but I want to delete them. When I press the delete button, nothing happens   http://www.jayg.co.u...oad_gallery.php   <form> <?php $dir = dirname(__FILENAME__)."/images/gallery" ; $files1 = scandir($dir); foreach($files1 as $file){ if(strlen($file) >=3){ $foil = strstr($file, 'jpg'); // As of PHP 5.3.0 $foil = $file; $pos = strpos($file, 'css'); if ($foil==true){ echo '<input type="checkbox" name="filenames[]" value="'.$foil.'" />'; echo "<img width='130' height='38' src='images/gallery/$file' /><br/>"; // for live host //echo "<img width='130' height='38' src='/ABOOK/SORTING/gallery-dynamic/images/gallery/ $file' /><br/>"; } } }?> <input type="submit" name="mysubmit2" value="Delete"> </form>   any ideas please?   thanks

Hi guys

I just want to know something. With php you can handle excel files by saving them as .csv files. Then the php script reads it line by line, and commas separating the fields. But is it possible that I can insert an image (small jpg or png) file in one of these fields...and then handle the image in the php script?

Just for intrest I inserted an image in excel worksheet and it did not insert it into a cell, it float. Is there maybe another to insert it in the cell and then control it with php??

Thanx in advance

Ok, I have a GD image that is then rewrote as a png. My question is, is it possible to find out what site is requesting the image and then use it on the php image. Example, if I didn't want a domain to use my images, could I somehow me able to restirict that site?

Hey every i'm just trying to change my 'Read More' text after a blog post on my site into am image. Got some code that lets me change the actual text to something else, just can't find how to change the text into an image.

Code: [Select]
add_filter( 'the_content_more_link', 'child_content_more_link', 10, 2 );
function child_content_more_link( $more_link, $more_link_text ) {

    return str_replace( $more_link_text, 'my new read more text', $more_link );

} 

Thanks,
Matty44m

I have an interesting question here. Below is my html of my navigation menu however I'm setting up something in my database which has some good stuff in it and I"m trying to figure out how to implement it all so that the images, links, and everything will still work properly. This will probably take some thinking and I can't come up with a way to do this while still being able to have the images appear right.

Code: [Select]
<div id="navigation">
               
                    <img id="navigation" src="images/navigation.jpg" alt="Navigation" />
           
            <a href="applications.php"><img class="links" src="images/applications1.jpg" alt="Applications" onmouseover="this.src = 'images/applications2.jpg'" onmouseout="this.src = 'images/applications1.jpg'" /></a>
           
            <a href="#"><img class="links" src="images/rules1.jpg" alt="Rules" onmouseover="this.src = 'images/rules2.jpg'" onmouseout="this.src = 'images/rules1.jpg'" /></a>
           
            <a href="#"><img class="links" src="images/history1.jpg" alt="History" onmouseover="this.src = 'images/history2.jpg'" onmouseout="this.src = 'images/history1.jpg'" /></a>
           
            <a href="#"><img class="links" src="images/frontoffice1.jpg" alt="Front Office" onmouseover="this.src = 'images/frontoffice2.jpg'" onmouseout="this.src = 'images/frontoffice1.jpg'" /></a>
           
            <a href="#"><img class="links" src="images/forums1.jpg" alt="Forums" onmouseover="this.src = 'images/forums2.jpg'" onmouseout="this.src = 'images/forums1.jpg'" /></a>
           
            <a href="#"><img class="links" src="images/roster1.jpg" alt="Roster" onmouseover="this.src = 'images/roster2.jpg'" onmouseout="this.src = 'images/roster1.jpg'" /></a>
           
            <a href="#"><img class="links" src="images/halloffame1.jpg" alt="Hall of Fame" onmouseover="this.src = 'images/halloffame2.jpg'" onmouseout="this.src = 'images/halloffame1.jpg'" /></a>
           
            <a href="#"><img class="links" src="images/backstage1.jpg" alt="Backstage" onmouseover="this.src = 'images/backstage2.jpg'" onmouseout="this.src = 'images/backstage1.jpg'" /></a>
       
                </div> <!-- End of navigation div -->
Database Table - Menus
fields- id, menuname

Database Table - Menu Items
fields - id, menu_id, contentpage_id, itemname, itemurl, itemorder

I'm trying to Embed the images from Apple into my PHP file.

Code: [Select]
$phpobj = unserialize($response);
if (is_array($phpobj))
{
foreach ($phpobj['value']['items'] AS $key => $val)
{
printf("<div><p><a href=%s>%s</a></p><p>%s</p>\n", $val['link'], $val['title'], $val['description']);
}
}
But the problem is that the image attribute is inside a Table and using something lile $val['img'] is not working. So anybody can help me with this.

Here is the RSS feed format from which I'm importing


  Code: [Select]
<item>

   <title>Dead Awake - Trailer</title>

   <link>http://trailers.apple.com/trailers/independent/deadawake/</link>

   <description>DEAD AWAKE is a seductive supernatural thriller starring Rose McGowan, Amy Smart and Nick Stahl set against the backdrop of a mysterious tragedy that shattered their lives a decade ago and which sets them on a path to uncover the truth that lies between the living and the dead.</description>

   <pubDate>Wed, 01 Dec 2010 00:00:00 PST</pubDate>

<content:encoded><![CDATA[

<table>

<tr valign="top">

<td width="67"><a href="http://trailers.apple.com/trailers/independent/deadawake/"><img src="http://trailers.apple.com/trailers/independent/deadawake/images/poster.jpg" width="65" height="97" border="0"></a></td>

<td> &nbsp; </td>

<td><a href="http://trailers.apple.com/trailers/independent/deadawake/"><span style="font-size: 16px; font-weight: 900; text-decoration: underline;">Dead Awake - Trailer</span></a><br />

<span style="font-size: 12px;">DEAD AWAKE is a seductive supernatural thriller starring Rose McGowan, Amy Smart and Nick Stahl set against the backdrop of a mysterious tragedy that shattered their lives a decade ago and which sets them on a path to uncover the truth that lies between the living and the dead.<br /><b>Directed by:</b> Omar Naim<br /><b>Starring:</b> Nick Stahl, Rose McGowan, Amy Smart, Ben Marten, Kim Grimaldi, Brian Lynner, Justin Marxen, James Serpento, Jack Mishler, Shane Simmons, Rachel Storey, Justin Urich, Andrea Leon, Livia Milano, Phyllis Mumford</span></td>

</tr>

</table>

]]></content:encoded>

   </item>

I read everywhere where it says not to stoe images in MYSQL but I have a code where I'm trying to display the images. They are all jpegs that are stored in the table. Here is the code Code: [Select]
<?php
include "dbaptsConfig.php";
include "searchaptsstyle.css";
// test id, you need to replace this with whatever id you want the result from
$id = "1";

// what you want to ask the db
$query = "SELECT * FROM `apartments` WHERE `id` = ".$id;

// actually asking the db
$res = mysql_query($query, $ms);

// recieving the answer from the db (you can only use this line if there is always only one result, otherwise will give error)
$result = mysql_fetch_assoc($res);

// if you uncomment the next line it prints out the whole result as an array (prints out the image as weird characters)
// print_r($result);

// print out specific information (not the whole array)
   echo "<br/>";
echo "<div id='title'>".$result['title']."<br/></div>";
echo "<br/>";
   echo "<div id='description'>".$result['description']."<br /></div>"; 
echo "<br/>";
echo "<div id='table'><tr>"; 
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Provider's Phone Number: ".$result['phone']."<br /></td>";
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Provider: ".$result['service']."<br /></td>";
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Borough: ".$result['county']."<br /></td>";
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Town: ".$result['town']."<br /></td>";
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Bedrooms: ".$result['rooms']."</td>";
echo "<td>&nbsp;&nbsp;&nbsp;</td>";
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Bathrooms: ".$result['bath']."<br /></td>";
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Square Footage: ".$result['square']."<br /></td>";
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Rent: ".$result['rent']."<br /></td>";
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Listed On: ".$result['time']."<br /></td>";
echo "</tr></div>";
header("Content-type: image/jpeg");
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Listed On: ".$result['image1']."<br /></td>";
?>
Thanks

I had this page working fine where it retrieves a set of images from the database depending on what thumbnail was click on the previous page. Now I am trying to add an edit and delete button to each of the pictures and it will not display any of it now!

This is the code I am using:
Code: [Select]
<?php
$id = $_GET[id];
?>


<?php
$max_items = 16; /* max number of news items to show */

require_once('config.php');
$db = mysql_connect (DB_HOST,DB_USER,DB_PASSWORD);
if(!$db) {
die('Failed to connect to server: ' . mysql_error());
}
mysql_select_db (DB_DATABASE,$db);

function displayNews($all = 0) {
    global $db, $max_items;
    
    if ($all2 == 0) {
        /* query for news up to $max_items */
        $query13 = "SELECT image,id,description,projectcode,thumbnail " . 
                 
                 "FROM project WHERE projectcode='$id' ORDER BY id DESC LIMIT $max_items";
    } else {
        /* query for all news */
        $query13 = "SELECT image,id,description,projectcode,thumbnail " . 
                 
                 "FROM project WHERE projectcode='$id' ORDER BY id DESC";
    }
    $result13 = mysql_query($query13) or print("<p>Error fetching entries from the database, error: " . "Statement: " . $query13 . "</p>" . mysql_error());


    while ($row13 = mysql_fetch_array($result13)) {
        
        $title = htmlentities ($row13['description']);
        $news = nl2br (strip_tags ($row13['projectcode'], '<a><b><i><u>'));
$image = $row13['image'];
$thumbnail = $row13['thumbnail'];
$id = $row13['id'];
        
        /* display the data */

        echo "<div class='portfolioproject'>";?>

        <div class='boxgrid captionfull'>
<a id="<?php echo $id ?>" class="example_group" href="images/gallery/<?php echo $image ?>" title="<?php echo $title ?>" rel="gallery"><img alt="" src="images/gallery/<?php echo $thumbnail ?>" width="122px" height="122px"</a>
               
          </a>}
               
        <?php

//Check whether the session variable SESS_MEMBER_ID is present or not

if(isset($_SESSION['SESS_MEMBER_ID']) || (!trim($_SESSION['SESS_MEMBER_ID']) == '')) {
echo "<form class='editbtn' action='editportfolio.php' method='POST'>";
echo "<input type='hidden' name='idf' value='$id' />";
echo "<input src='images/editbtn.png' type='image' value='Edit' />";
echo "</form>";
echo "<form class='editbtn' action='deleteportfolio.php' method='POST'>";
echo "<input type='hidden' name='ide' value='$id' />";
echo "<input src='images/delbtn.png' type='image' value='Delete' />";
echo "</form>";
} else {
echo "";
}


echo "</div>";

    }
    
    /* if not displaying all news, give a link to do so */
    if ($all == 0) {
        echo "<div class='show_all'><a class='show' href=\"{$_SERVER['PHP_SELF']}" .
             "?action=all\">Show all</a></div>\n";
    }
}

/* this is where the script decides what do do */

echo "\n";
switch($_GET['action']) {

    case 'all':
        displayNews(1);
        break;
    default:
        displayNews();
}
echo "\n";
?>

<?php
//Check whether the session variable SESS_MEMBER_ID is present or not
if(isset($_SESSION['SESS_MEMBER_ID']) || (!trim($_SESSION['SESS_MEMBER_ID']) == '')) {
echo "<span class='show_all'>";
echo "<a class='show' href='admincp.php'>&nbsp;&nbsp;Admin</a>";
echo "</span>";
echo "<span class='show_all'>";
echo "<a class='show' href='logout.php'>&nbsp;Logout</a>";
echo "</span>";
} else {
echo "";
}
?>

No error messages are displayed, only the 'show all' button, and the 'admin' and 'logout' buttons if signed in!

Any help on this would be much appreciated!

Thank you

Martin

I am looking to display image paths in a row separated by commas. There are 6 images that goes to each user and I would like only the 6 images at be in each " " Like this:

"images/listings/listing_516013019A-only.jpg,images/listings/listing_848813453A-1.jpg,images/listings/listing_664613453A-2.jpg,images/listings/listing_520313453A-3.jpg,images/listings/listing_690513453A-4.jpg,images/listings/listing_125113453A-5.jpg,images/listings/listing_641013453A-6.jpg,"
"images/listings/listing_736913186A-1.jpg,images/listings/listing_822713186A-2.jpg,images/listings/listing_136513186A-3.jpg,images/listings/listing_700313186A-4.jpg,images/listings/listing_716013186A-5.jpg,images/listings/listing_213113186A-6.jpg,"
"images/listings/listing_292113254A..-1.jpg,images/listings/listing_854413254A..-2.jpg,images/listings/listing_446013254A..-3.jpg,images/listings/listing_676313254A..-4.jpg,images/listings/listing_563413254A..-5.jpg,images/listings/listing_341513254A..-6.jpg,"

Right now it is displaying them like this

"images/listings/listing_516013019A-only.jpg,"
"images/listings/listing_848813453A-1.jpg,"
"images/listings/listing_664613453A-2.jpg,"
"images/listings/listing_520313453A-3.jpg,"
"images/listings/listing_690513453A-4.jpg,"
"images/listings/listing_125113453A-5.jpg,"
"images/listings/listing_641013453A-6.jpg,"
"images/listings/listing_736913186A-1.jpg,"
"images/listings/listing_822713186A-2.jpg,"
"images/listings/listing_136513186A-3.jpg,"
"images/listings/listing_700313186A-4.jpg,"
"images/listings/listing_716013186A-5.jpg,"
"images/listings/listing_213113186A-6.jpg,"
"images/listings/listing_292113254A..-1.jpg,"
"images/listings/listing_854413254A..-2.jpg,"
"images/listings/listing_446013254A..-3.jpg,"
"images/listings/listing_676313254A..-4.jpg,"
"images/listings/listing_563413254A..-5.jpg,"
"images/listings/listing_341513254A..-6.jpg,"

Here is the code I have:

Code: [Select]
<?php

// Make a MySQL Connection
mysql_connect("localhost", "xxxxxxxx", "xxxxxxxx") or die(mysql_error());
mysql_select_db("xxxxxxxx") or die(mysql_error());

$result = mysql_query("SELECT * FROM listimages ORDER BY listimages.listingid DESC ")
or die(mysql_error());

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

echo "\"";
        echo "$row[imagepath],";
echo "\"";
echo "<br>";

}

?>
My tables for the images is   "listimages" and the columns a
id (which are the auto_increments)
imagepath (which shows the path/image1.jpg)
mainimage (which just shows 0 or 1 depending on the picture that is the default for that listing, 1 being default)
listingid (shows numbers 1 2 3 etc corresponding to the Id in the listings table to show what images go with what listing) There are up to 6 images for each listing.

Any idea how to fix this?

Hi,
I have this upload script that uploads a file and writes path to DB:

Code: [Select]
<?php

$uploadDir = '../uploads/';

if(isset($_POST['upload']))
{
foreach ($_FILES as $file)
{
$fileName = $file['name'];
$tmpName = $file['tmp_name'];
$fileSize = $file['size'];
$fileType = $file['type'];

if($fileName==""){

$filePath = '../img/none.jpg';
}
else{

$filePath = $uploadDir . $fileName;
}

if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
$filePath = addslashes($filePath);
}
$fileinsert[]=$filePath;
}
?>

this works fine for a single image, but I eed to upload 2 images with a single submission....any ideas how to do this?
Thanks

Hi, I have a pretty simple application that allows my users to upload images and i'm able to succesfull upload images to a new dir to be outputted.  But as to save on download time and server space is there a simple piece of code I can add to the below code that will resize every image on uploded to 460(w) x 300 (h) from my users

Code: [Select]
<?php
if ((($_FILES["article_image"]["type"] == "image/gif")
|| ($_FILES["article_image"]["type"] == "image/jpeg")
|| ($_FILES["article_image"]["type"] == "image/pjpeg"))
&& ($_FILES["article_image"]["size"] < 5000000))
  {

      move_uploaded_file($_FILES["article_image"]["tmp_name"],
      "images/" . $_FILES["article_image"]["name"]);
      }

?>

Thanks in advance for any help and suggestions