PHP - Images In Php And Mysql?

I am currently looking to insert images into a database and then display them in php.

I am thinking of storing the images as a VARCHAR data type but what would be a more suitable type?

I am having trouble trying to save my image file names to mysql after reading a dir. I am trying to use the file below. Any help would be appreciated. I was originallly getting the files to list but they we not showing up in the database. Now the page shows up blank.

<?php
require("config_0.php");

// Connect to server and select database.
mysql_connect($dbhost, $dbuser, $dbpass)or die("cannot connect");
mysql_select_db("test")or die("cannot select DB");


$files = glob("images/*.jpg"); 
for ($i=1; $i<count($files); $i++) 
	{ 	
		$num = $files[$i];
		$sql="INSERT INTO images (url) VALUES ('$num')";

			if (!mysql_query($sql))
			  {
			  die('Error: ' . mysql_error());
			  }
		echo '<img src="'.$num.'" alt="random image">'."&nbsp;&nbsp;";
	}
?>

I receive files/images and loop through an array as follows:

$files=rearrfiles( $_FILES['image']);
    foreach($files as $key=>$item)
    {
	  if(is_array($item) && !empty($item['name']) && !empty($item['tmp_name'])){
		  //$_POST['imageFile']=$item['name'];
		 //echo $item['name'];
		  if($error!=true && !uploadImageB(array('image'=>'image'), DB_EXTENTION."mod_projects_images", $naming, $search = $editId,  $dir, 'photo'))
		  {			
		   $error=true;
		   $action='Edit';
		   $message.='<br>Images were unable to be uploaded.';
		  } 

	  }
	}

The function uploadImageB() is as follows:

function uploadImageB($info, $table, $naming, $search, $path, $add='uploaded', $maxw=1280, $maxh=1280, $dynamic=true, $id='Id', $thumbMaxWidth = 120)
{
 global $connection;
 if(!$_POST){ global $HTTP_POST_VARS; @$_POST=$HTTP_POST_VARS;}
 if(!$_FILES){ global $HTTP_POST_FILES; @$_FILES=$HTTP_POST_FILES;}
 if(is_array($info) && !empty($info) && $table!='' && !empty($path))
 {

	$error=false;
    $d=$naming;
	foreach($info as $key=>$val)
	{		

	 $names[$val]=$dynamic==true?$add.'_'.$result[$id].'_'.$d.'_.'.strtolower(mygetext($_FILES[$val]['name'])):$add.strtolower(mygetext($_FILES[$val]['name']));
	
		 if(is_array(@$_FILES[$val]) && !empty($_FILES[$val]['name']) && !empty($names[$val]))
		 {
				if(!singMove($path, $names[$val], $_FILES[$val], array(), array('gif', 'jpeg', 'jpg', 'png', 'bmp', 'svg')))
				{
					$error=true; break;
				}
			else{
					$valid[$val]=$names[$val];
					resizeImage($path.$names[$val], $maxw, $maxh);
					make_thumb($path.$names[$val],$names[$val], $path, $thumbMaxWidth);
				}
		 }

	}
	
	
	if($error==true) return false;
	elseif(!empty($valid))
	{
  
	 $connection->info=$info; $connection->input=$valid; $connection->id=array('field'=>$id, 'val'=>addslashes($result[$id]));
	 $connection->makenew($table); $connection->return_db($connection->query);
	}
 }
 return true;
}

I get the error: Images were unable to be uploaded. Any help?

Hi there,

I hope somebody can help me creating a loop for the following code:
What it currently does is, showing only 1 image, while in fact there are 3 of them.
I've combined a loginsystem with slideviewer. When i use the original php code (or a part of it) it only shows one listing. I need it to list all of them.

<div id="mygalone" class="svw">
<ul>
<li>
<?php

$result = mysql_query("SELECT reference FROM user_photos WHERE`profile_id`='".$row['id']."'");

while ($row2 = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "<a href=\"".$_GET['username']."/pics/".$row2['reference']."\">
<img src=\"".$_GET['username']."/pics/thumbs/".$row2['reference']."\"></a><br/><br/>";
}
}
?>
</li>
</div>

What can be stripped down to this:

<?php { $result = mysql_query("SELECT reference FROM user_photos WHERE`profile_id`='".$row['id']."'");
while ($row2 = mysql_fetch_array($result, MYSQL_ASSOC))
{ 
echo "<img src=\"".$_GET['username']."/pics/".$row2['reference']."\">"; 
} 
} ?>


You would asume that this is allready a loop, but it does not act like it.

Best regards,

Martijn (the netherlands)

I've looked around at a bunch of sample code and cannot seem to get this to work. I'm trying to create a table with the values provided in a form along with an uploaded image. Here is what I have.

Code: [Select]
<?php
//Set variables from form
$title = $_POST["title_textfield"];
$description = $_POST["description_textbox"];
$price = $_POST["price_textfield"];
$time = date("ymdHis");
$me = $myuserID

/Create Table
$con = mysql_connect("mydatabase.mysql.com","databaseAdmin","Adminpass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


//check if table exists 

// Create table
$time = date("ymdHis");
$tablename = "1_$me$time";
mysql_select_db("db_01", $con);
$sql = "CREATE TABLE $tablename
(
ID int NOT NULL AUTO_INCREMENT, 
imageData LONGBLOB NOT NULL ,
PRIMARY KEY(comicID),
Owner varchar(15),
Status varchar(15),
AgeRestriction varchar(25),
Title varchar(25),
Description varchar(100),
Price varchar(15)
)";

// Execute query
mysql_query($sql,$con);
//input info into table
mysql_query("INSERT INTO $tablename (Owner, Status, Title, Description, Price)
VALUES ('$myid', 'Pending', '$title', '$description', '$price')");

//Image control!!!!
$maxFileSize = "2000000"; // 2 MB file size
//Initializing the image types. 
$image_array = array("image/jpeg","image/jpg","image/gif","image/bmp","image/pjpeg","image/png"); // valid image type

//store the file type of the uploading file.
$fileType = $_FILES['userfile']['type'];
$nname= $_FILES['userfile']['name'];
echo "$nname";
//Initializing the  msg variable. Although , not necessary. 
$msg = ""; 
     

// if Submit button is clicked
if(@$_POST['Submit'])
{
// check for the image type , before uploading
if (in_array($fileType, $image_array)) 
{

// check whether the file is uploaded
 if(is_uploaded_file($_FILES['userfile']['tmp_name']))
 {
 
 // check whether the file size is below 2 mb
        if($_FILES['userfile']['size'] < $maxFileSize)
            {
 
 // reading the image data
                  $imageData =addslashes (file_get_contents($_FILES['userfile']['tmp_name']));
 
 // inserting into the database
        $sql = "INSERT INTO $tablename (imageData) VALUES ('$imageData')";
 
              
        mysql_query($sql) or die(mysql_error());
                $msg = " Data successfully uploaded";
         }
     else 
         {
     
             $msg = " Error :  File size exceeds the maximum limit ";
                 
             }
   }
}
else
{
$msg = "Error: Not a valid image ";
}

}
mysql_close($con);
?>
All the fields populate just fine except the imageData field which shows "[BLOB - 0 Bytes]" Any help would be GREATLY appreciated. Thank you for even taking the time to look.

Cordially,
TcS

Hi, here's my problem: I am trying to make a simple online buying website and I want to display a table with all the fields for each item. So I got that part down which is to just use mysql_fetch_assoc("SELECT * FROM myTable") and use the html table tags stuff, but now I want to display my images in the table, so here's my code to display my mysql database table in html's table tag along w/ php:


<html>
<head>
<title>My Online buying website project</title>
</head>

<body>
<?php 
  mysql_connect("localhost","root");
  mysql_select_db("myTable");
  $imagesArray=array("Apple_iPhone3GS.jpg","Apple_iPhone4.jpg","product3.jpg","product4.jpg","product5.jpg");
 
  $result=mysql_query("SELECT Name, Manufacturer, Price, Description, SimSupport FROM myTable");
 
   if(mysql_num_rows($result))//if there is at least one entry in bellProducts, make a table
   {
      print "<table border='border'>";
      print "<tr>
        <th>Name</th>
        <th>Manufacturer</th>
        <th>Price</th>
        <th>Description</th>
        <th>SimSupport</th>
           </tr>";
           
       //NB: now output each row of records
      while($row=mysql_fetch_assoc($result))
     {
        extract($row);
        print "<tr>
        <td>$Name</td>
        <td>$Manufacturer</td>
        <td>$Price</td>
        <td>$Description</td><td>$SimSupport</td>
         </tr>";
     
     }//END WHILE
             
   }//END IF
   
  ?>
</table>
</body>
</html>

*So how do I go about adding my images in this table?

Basically i have a folder with 100+ images they are NOT all the same extension, what im wanting to do is use PHP to find all the images and put them all in a database. how would i go about doing this?

thanks

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

create table mimi (mimiId int(11) not null, mimiBody varchar(255) );
<?php
//connecting to database
include_once ('conn.php');
$sql ="SELECT mimiId, mimiBody FROM mimi";

$result = mysqli_query($conn, $sql );

$mimi = mysqli_fetch_assoc($result);

$mimiId ='<span>No: '.$mimi['mimiId'].'</span>';

$mimiBody ='<p class="leading text-justify">'.$mimi['mimiBody'].'</p>';
?>
//what is next?

i want to download pdf or text document after clicking button or link how to do that

Hello everyone,

Sorry if this has been answered but if it has I can't find it anywhere. So, from the begining then.  Lets say I had a member table and in it I wanted to store what their top 3 interests are.  Their$ row has all the usual things to identify them userID and password etc.. and I had a further 3 columns which were labled top3_1 top3_2 & top3_3 to put each of their interests in from a post form.

If instead I wanted to store this data as a PHP Array instead (using 1 column instead of 3) is there a way to store it as readable data when you open the PHPmyadmin?

At the moment all it says is array and when I call it back to the browser (say on a page where they could review and update their interests) it displays 'a' as top3_01 'r' as top3_02 and 'r' as top3_03 (in each putting what would be 'array' as it appears in the table if there were 5 results. Does anyone know what I mean?

For example -

If we had a form which collected the top 3 interests to put in a table called users,

Code: [Select]
<form action="back_to_same_page_for_processing.php" method="post" enctype="multipart/form-data">
   
    <input name="top3_01" type="text" value="enter interest number 1 here" />
    <input name="top3_02" type="text" value="enter interest number 2 here" />
    <input name="top3_03" type="text" value="enter interest number 3 here" />
    <input type="submit" name="update_button" value=" Save and Update! " />

   
    </form> // If my quick code example for this form is not correct dont worry its not the point im getting at :)
And they put 'bowling' in top3_01, 'running' in top3_02 and 'diving' in top3_03 and we catch that on the same page with some PHP at the top -->

Code: [Select]
        if (isset($_POST)['update_button']) {
   
    $top3_01 = $_POST['top3_01']; // i.e, 'bowling' changing POST vars to local vars
    $top3_02 = $_POST['top3_02']; // i.e, 'running'
    $top3_03 = $_POST['top3_03']; // i.e, 'diving'

With me so far? If I had a table which had 3 columns (1 for each interest) I could put something like -

  Code: [Select]
   include('connect_msql.php');
   
    mysql_query("Select * FROM users WHERE id='$id' AND blah blah blah");
   
    mysql_query("UPDATE users SET top3_01='$top3_01', top3_02='$top3_02', top3_03='$top3_03' WHERE id='$id'");


And hopefully if ive got it right, it will put them each in their own little column. Easy enough huh? But heres the thing, I want to put all these into an array to be stored in the 1 column (say called 'top3') and whats more have them clearly readable in PHPmyadmin and editable from there yet still be able to be called back an rendered on page when requested.

Continuing the example then, assuming ive changed the table for the 'top3' column instead of individual colums,  I could put something like this -


Code: [Select]
            if (isset($_POST)['update_button']) {
       
        $top3_01 = $_POST['top3_01']; // i.e, 'bowling' changing POST vars to local vars
        $top3_02 = $_POST['top3_02']; // i.e, 'running'
        $top3_03 = $_POST['top3_03']; // i.e, 'diving'
   
    $top3_array = array($top3_01,$top3_02,$top3_03);
   
    include('connect_msql.php');
   
    mysql_query("UPDATE members SET top3='$top3_array' WHERE id='$id' AND blah blah blah");
But it will appear in the column as 'Array' and when its called for using a query it will render the literal string. a r r in each field instead.  Now I know you can use the 'serialize()' & 'unserialize()' funtcions but it makes the entry in the database practically unreadable. Is there a way to make it readable and editable without having to create a content management system?

If so please let me know and I'll be your friend forever, lol, ok maybe not but I'd really appreciate the help anyways.  The other thing is, If you can do this or something like it, how am I to add entries to that array to go back into the data base?

I hope ive explained myself enough here, but if not say so and I'll have another go.  Thanks very much people,  L-PLate (P.s if I sort this out on my own ill post it all here)

I have following piece of code below, and I would like to be able to express it pure SQL, something that could go into a .sql file :

$request_string='SELECT topic_forum_id FROM topic_table WHERE topic_id= 2014';
$query=database->prepare($request_string);
$query->execute();
$data=$query->fetch();
$query->closeCursor();
$forum=$data['topic_forum_id'];

$request_string='INSERT INTO post_table
(post_topic,post_forum) VALUES (2014,:forum)';
$query=database->prepare($request_string);
$query->bindValue(':forum',$forum,PDO::PARAM_INT);
$query->execute();
$data=$query->fetch();
$query->closeCursor();

  Is it possible ?

So i have this php as shown below. It should make a list of comments with comment replies below their comment respectively.

The problem is that it only goes through and shows 1 comment and all the comment replies for that one comment. It should be showing all comments i have in the db for that article.

If i remove the second while then it shows all the comments correctly but no comment replies then...

How do i get this script to loop through the db for every comment but also loop through every comment reply for that $row[id]?

If anyone has a better / more efficient way of what I am trying to do, please explain or show example (i am open to anything)...

Code: [Select]
// what article are we showing?
$article_to_show_id = $_GET['article_id'];


$active_is_set_text = "1"; // Active Column text that makes it okay to show

// Finding the article
$search_for_article = mysql_query("SELECT * FROM articles WHERE id = '$article_to_show_id' AND active = '$active_is_set_text'");

while($row = mysql_fetch_array($search_for_article))
{
// format the last updated date right
$update_date_edit = $row[update_date];

$update_date_edit = date('F j, Y \a\t h:ia', $update_date_edit);

$row[update_date] = $update_date_edit;



// format the submit updat date right
$submit_date_edit = $row[submit_date];

$submit_date_edit = date('F j, Y \a\t h:ia', $submit_date_edit);

$row[submit_date] = $submit_date_edit;


echo '
<div>
', $row[title] ,'
</div>


<div>
by: ', $row[author] ,' on ', $row[submit_date] ,'
</div>



<div>
', $row[content] ,'
</div>


<div>
Last Updated: ', $row[update_date] ,'
</div>

<form action="article_reply.php" method="post">
<input type="hidden" name="article_id" value="', $row[id] ,'" />
<button name="article_reply" type="submit" value="submit">Reply</button>
</form>

';

}

$comment_count = 0;
$comment_reply_count = 0;

// Finding all of the comments
$search_for_article = mysql_query("SELECT * FROM article_comments WHERE article_id = '$article_to_show_id' AND reply_id = '0'");

while($row_comment = mysql_fetch_array($search_for_article))
{
// format the submit updat date right
$comment_date_edit = $row_comment[comment_date];

$comment_date_edit = date('F j, Y \a\t h:ia', $comment_date_edit);

$row_comment[comment_date] = $comment_date_edit;

echo '
<br>
<br>
COMMENT:<br>

<div>
By: ', $row_comment[username] ,' on ', $row_comment[comment_date] ,'
</div>

<div>
', $row_comment[comment] ,'
</div>
';
$comment_count++;

// Finding all of the comment replies if any
$search_for_article = mysql_query("SELECT * FROM article_comments WHERE article_id = '$article_to_show_id' AND reply_id = '$row_comment[id]'");

while($row_two = mysql_fetch_array($search_for_article))
{
// format the submit updat date right
$comment_date_edit = $row_two[comment_date];

$comment_date_edit = date('F j, Y \a\t h:ia', $comment_date_edit);

$row_two[comment_date] = $comment_date_edit;

echo '
<br>
<br>
COMMENT REPLY:<br>

<div>
By: ', $row_two[username] ,' on ', $row_two[comment_date] ,'
</div>

<div>
', $row_two[comment] ,'
</div>
';
$comment_reply_count++;
}
}

Need some help I have 2 tables in a database and I need to search the first table and use the results from that search, to search another table, can this be done? and if it can how would you recommend that I go about it?

Thanks For Your Help Guys! 

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?