Images storage and MySQL

patlap

What is the bes way to have images inside a MySQL DB ?

If inside the DB what type should I use ?

If outside the DB what is the fastest way to access them ?

AstroTeg

Outside of the DB is the best and fastest. Let the file system do what it does best - serving files (plus it does cache management to help serve files faster). Databases are good at digging out information (like, "find all people who's first name is 'Rob'"). Will you be querying your collection of images like this? No. You will probably associate an image to a record, and to do that, just store the image name (you might store the path too, but if the path changes, it would really suck to have to figure out how to change the path in all those rows of data).

patlap

Thank's Astro

You will probably associate an image to a record, and to do that, just store the image name (you might store the path too, but if the path changes, it would really suck to have to figure out how to change the path in all those rows of data).

That's right !

So I must put images in the same folder of my php file

And use someting like CHAR type to be create in my table !

patlap

I created my pict field with a VAR(32) Type in wich I put the name of the image that stant on the same folder of my php fileé

Now i'm trying to get that iamge to show but it doesn't.

Can somebody have a look at this code and tell me where did I go wrong.

Please !

...
mysql_select_db ( "fiche", $connexion );

                    $result = mysql_query ("SELECT * FROM FrCandidat", $connexion);

                    $row = mysql_fetch_array($result);

                    $prenom = $row['prenom'];
                    $nom = $row['nom'];
                    $email = $row['email'];
                    $genre = $row['genre'];
                    $phone = $row['phone'];
                    $pict = $row['pict'];
                    $acces = $row['acces'];
                    $poste = $row['poste'];
                    $fax = $row['fax'];
                    $pratique = $row['pratique'];
                    $admission = $row['admission'];
                    $formation = $row['formation'];
                    $association = nl2br($row['association']);

            ?>
                    <div id="hdr">
                    <img class="img" src="<?= $pict ?>" alt="" width="144" height="144" border="0"><br/>
                    <img src="imagesFiche/logoS.gif" alt="" width="144" height="34" border="0">
                            <p class="Prenom"><?php echo $prenom ?>&nbsp;<span class="Nom"><?php echo $nom ?></span></p>
                             <p><span class="Av"><?php echo $genre ?></span></p>
                            <div id="Tel">
                                    Téléphone<br>
                                    Accès direct<br>
                                    Télécopieur<br>
                                    Courriel</div>
                            <div id="Tel2">
                                    <?php echo $phone ?> <br>
                                    <?php echo $acces ?> poste <?php echo $poste ?><br>
                                    <?php echo $fax ?><br>
                                    <?php echo "<a href='mailto:$email'>$email</a>"; ?></div>
                            </div>
...

Roger_Ramjet

You need to echo the filename just like you echo all the other stuff: and use the end statement semi-colon after each echo statement as well.

PhiSYS

You can include a config.inc.php which defines paths either using defines or variables

define("DIR_BASE", "./");
define("DIR_IMGS", "docs/");

// BUILD THE FULL PATH TO FILE
$img_full_path = DIR_BASE . DIR_IMGS . $row['filename'];

patlap

I got it

Thank you

You can include a config.inc.php which defines paths either using defines or variables

PHP:

define("DIR_BASE", "./");
define("DIR_IMGS", "docs/");

// BUILD THE FULL PATH TO FILE
$img_full_path = DIR_BASE . DIR_IMGS . $row['filename'];

This look very Handy !!