Can someone put me through on this,i am developing e-commerce website that need to display the items picture on the webpage.

This might help: http://www.phpro.org/tutorials/Storing-Images-in-MySQL-with-PHP.html

Why suffer thy self? Why not use a ready and secured eCommerce application? In anycase, please try w3schhools.com or run a Google search for same.

msal2016:
Can someone put me through on this,i am developing e-commerce website that need to display the items picture on the webpage.

msal2016:
Can someone put me through on this,i am developing e-commerce website that need to display the items picture on the webpage.

You want to build an ecommerce website from scratch?

must you store images in database, upload images to a folder in your web root, store the path in the database and your good to go.
but if ure keen in storing the image to database directly, use a blob field in your database, convert image to blob and save in database

Hi, its better to use an existing ecommerce open source tools, than developing from the scratch. You can try:
OpenCart, Magento or WooCommerce (If you are conversant with WordPress)

msal2016:
Can someone put me through on this,i am developing e-commerce website that need to display the items picture on the webpage.

Dont do that. Never save images in a database except the images are valuable and cant be kept on the filesystem. What you need to do is to upload the images to your filesystem, get the path of the file and save just that path information in the database. So if you uploaded the image to images/uploads/ in your application directory, then save the image/uploads/myimage.jpg in the database. Saving images as blob is very inefficient and like i said only do this if there is a very important reason that the file cant be kept on your filesystem.

^^^I agree with the poster above me, OP listen to him or you will end up wasting your time!

^^^ I agree on what the above poster agreed on...

adexsimply:
You want to build an ecommerce website from scratch?

Is it impossible?

hollyfat:

Is it impossible?

It is possible, but I will advise you to write your WILL before you embark on it.

its never that bad, jes buy holandia youghurt before you start building it, before you sip finish, you for don build the eCommerce app.
another tip op, make sure you buy gala too.

^^^And of course, he should also say his last prayers after chopping the gala (before embarking on the task)

try This.........
<?php

mysql_connect("localhost", "your username", "your password";
mysql_select_db("your_db_name";

//get post Request
$image = $_POST['image'];
$image_name = $_FILES['imagename']['name'];
$image_path = "http://www.yoursitename.com/root/images".$image_name.".png";

$query = "INSERT INTO images(image_url) VALUES($image_path)";
if( move_uploaded_file($image_name, $image_path))
{
$result = mysql_query($query);
if($result)
{
echo "Image Uploaded Sucessfully";
}else{
echo "Error Inserting Into database";
}
}else{
echo "Error Inserting Image Into File System";
exit;
}
?>

Oga use an e-commerce platform.. Prestashop, openCart.. Them plenty

dhtml18:

It is possible, but I will advise you to write your WILL before you embark on it.

There are quite good number of videos on YouTube that walk you through.


check phpacademy series you've your solution

See them nairaland programmers, just discouraging someone because they cannot offer help, instead of referring him to an e-commerce web app, while not teach him what those e-commerce apps uses..* this is why stackoverflow i better than nairaland programmers section always discouraging peoples ideas*

Bro,
MySQL supports a data type to store stuffs like images,videos,audios,pdf etc.

it is called BLOB(Binary Large Object)
if u use windows OS just right click on any image on your library and click on edit with notepad, you will see that a simple photo will turn into a very long text comprised with different syntax , letters and numbers*these are BLOBS*

u can create a table like these

CREATE TABLE IF NOT EXISTS images(
id INT UNSIGNED AUTO_INCREMENT,
image_name VARCHAR(any length u like) NOT NULL,
image BLOB NOT NULL,
PRIMARY KEY(id)
)

u can use BLOB, MEDIUMBLOB or LONGBLOB depending on the file size of the files u want to accept

then when u want to output the file to html use the following code
//do mysql conections before the following
$sql = 'SELECT image FROM images ';
$results = //query your mysql server fetch the results as an associative array

//then output to browser with
header('Content-Type://mime-type of ur image');
echo //the image u retrieved

i could not write the full stuff cause i post with a mobile phone mha hand dey pain

bt i advice u store the location of the images instead then on request u link to the location with html img element

this will be faster on a shared host except u are using a dedicated server or a cloud system

yusufabayomio:
Hi, its better to use an existing ecommerce open source tools, than developing from the scratch. You can try:
OpenCart, Magento or WooCommerce (If you are conversant with WordPress)

Sorry, I'm curious: Why do you think it is "better" not to build it himself if he can??

jacob05:
This might help: http://www.phpro.org/tutorials/Storing-Images-in-MySQL-with-PHP.html

This tutorial makes a lot of sense.I will apply the knowledge in my next app.

No matter how many people say it, i will never ever agree that blob is the way at all. The day you try to backup your database offline and you have like lets say 1 million images stored inside, you are in deep-shit man, especially with Nigerian internet connections.
Or if you have to do database migration and some other other stuffs. Even your incremental backups will finish up your space in no time.

Because of this, i have a database somewhere online that is several Gigabytes in size, i still dont know what to do with it.

What if you want to generate thumbnails - you will have to read that blob into a file, generate thumbnail, blob the thumbnail and erase the disk file. . . . .just imagine that

And the day the database crashes or get hacked - and imagine it is a social networking website - and the owner calls you, i wonder what you will say - if you were me, you will start with:: weeeeeeell. . . . . . .eeeeeeeeehm, i i i waassss ehm ehm trying to make some sort of incremental backup and the data must be somewhere on the webserver

You guys had better learn from those that have experimented with this method (like me) and have failed. It might look like a good idea at first, but with time, you will blame yourself.