Learn VBA & Macros in 1 Week!

PHP - Php Retrieving Images Corresponding To Mysql Table

Full Excel VBA Course - Beginner to Expert

Php Retrieving Images Corresponding To Mysql Table	View Content

Hello Guys,

I need help on this problem.

output:

display images for the values that exist in the table:

input:

the values in a table's column where they're in the format of "0,0" and the image corresponding to it is named 0,0.png

this is my attempt $q is retrieving "0,0" however in order for me to retrieve its image i need to add ".png" to it in order to find it in the directory that the image is located. It tried without ".png" and it also doesn't work.

$q = 'SELECT ID FROM table'; 
   $dirname = "directory/";
   $images = glob($dirname.$q.".png");
   foreach($images as $image) {
    echo '<img src="'.$image.'" /><br />';

Full Excel VBA Course - Beginner to Expert

Retrieving Images From Mysql

Similar Tutorials

View Content

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

Random And Unique Values From Mysql Table To Html Table?

Similar Tutorials

View Content

Hello,

I need some help. Say that I have a list in my MySQL database that contains elements "A", "S", "C", "D" etc... Now, I want to generate an html table where these elements should be distributed in a random and unique way while leaving some entries of the table empty, see the picture below. But, I have no clue how to do this... Any hints?

Thanks in advance,
Vero

Php To Mysql - Putting A Php Array Into A Mysql Table??

Similar Tutorials

View Content

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)