Get Images Out Of The Database And Display Them In A Grid?
Dec 13, 2010
I have a PHP script that will get images out of the database and display them in a grid. I have two verisons. I save a thumbnail which I display and then a larger image in a different folder. These images are placed in a scroll bar but what I would like to happen is that when I click on a thumbnail it basically displays the bigger image until I click on that image and it goes away. I would love for the middle of the image to be displayed in the middle of the users screen but beggers probably can't be choosers in this case.
An example of a similar desired result is a link here:http://qrayg.com/experiment/hig/Instead of the hover, I'd like to utilize the onclick to display and remove the image. If it's easy to put the center in the center of the screen that that would be absolutely incredible as well.
What I am looking for is to have a database hold a list of images ( or numbers that correspond to images)... that should be easy enough. The part I am having trouble with is having these images aligned in a grid which is inside a window /frame/ box on the web page. The user can click and drag and it will move around this collection of images.....
Like so (numbers represent images): 5 4 3 6 1 2 7 8 9 So if the user clicked and dragged to the right the images would then look like: 4 3 12 1 2 11 8 9 10 The new images are taken from the database and the user can drag in any direction.
Everybody knows how a dropdown menu works where a person clicks on the drop down menu and it displays a drop down list where the user can select an option from the list. What I want to know is that is there a way in html where except displaying a dropdown list can I display a grid instead with the options in the grid?
This link will show you how I want it to be dislayed like but I do not know how this is done.
I have a question for flexigrid jquery grid control users.
I am able to display json data returned from my WCF service in my Flexigrid in my application.
The paging toolbar displays correctly and it's clear that the paging toolbar understands how I've configured it.
However, the grid is not actually implementing the paging filter on the data in the grid. For example, the paging toolbar says "Displaying 1 to 10 of 12 items". However, all 12 items are displayed in the grid.
I guess I'm missing a config setting or callback. Any idea what the problem might be?
I found this javascript to randomize an image on a page...
Code:
<script language="JavaScript" type="text/javascript"> <!-- function random_img(){ var ranimage = new Array(); ranimage[1] = "photo1.jpg"; ranimage[2] = "photo2.jpg"; ranimage[3] = "photo3.jpg";
var ry = Math.floor(Math.random()*ranimage.length) if (ry==0) ry=1 document.write('<img src="'+ranimage[ry]+'" border=1>'); } random_img(); // --> </script>
I have some images that are dynamically generated and i want these images to randomize every few seconds (at the moment the images change when the user goes to a different page on the site)...can anyone give me any ideas as to whether this is possible??
The PHP code i'm using is below...
<?php
// read image dir $dir="../../admin/uploads/"; // Open directory, and proceed to read its contents if (is_dir($dir)) { if ($dh = opendir($dir)) { while (($file = readdir($dh)) !== false) { if (filetype($dir . $file)== "file"){
// load each image into array echo rand(5, 15); // get count of total no. of images $lastNo=sizeof($urlStack)-1; $imageToUse=rand(0,$lastNo); #print "using image $imageToUse of $lastNo"; $imageName=$nameStack[$imageToUse]; $imageUrl=$urlStack[$imageToUse];
#print "got $imageUrl and $imageName ";
//
?>
<a href="<?php echo $imageUrl; ?>"><img src="http://mywebsite.com/admin/uploads/<?php echo $imageName; ?>" alt="click here for our special offers" border=0 /></a>
I have a slideshow that gathers images from a database. I've been trying to set it up to where it extracts the IMG SRC accordingly so when I click on the image, the lightbox shows the corresponding image. But no luck thus far.
Here's what I mean:
How can I extract the current "s.src" parameter and use it on the "img src" tag to display the image accordingly?
I want to grab images from the database and then display them in a row going downwards. I be using position absolute in css. I want to put them in a row going downwards but having the exact space inbetween each image. Currently I made a row of images going downwards but the space inbetween keeps on increasing when more and more images are needed to be displayed.
[Code]...
Yet the space inbetween images increases the space when there is more and more images displayed.
The first 3 are always have the right space inbetween them. The 4th and so on adds 10px of space more for each image that is displayed but it's gradually. For instance image 4 would be you would take 70 which is image 3 top value and instead of adding 30 the code would add 40 to it. it increases the spaces by 10 for every image past the 3rd image. Yet the firebug will show the top values as if each image has a difference of 30 for the top value.
I was thinking can't I use position X and Y like with jquery or javascript can't I get the current x and y values of image one or 2 and then decrease the X and Y in a way that the spaceing inbetween each image is exactly the same. In our example I want to have like a 30px space inbetween the images and never increase the space as more images are displayed.
I know that there are some really nice jQuery UI. However, I'm really new to jQuery and I need to save the order into a SQL Server database so that next time if the same user comes back to the site, the picture will be in the same order that he/she reordered it previously.
I've been advised that the only way to accomplish this is via some hand-coded javascript, at which I'm a complete noob, so hopefully someone here might be able to steer me in the right direction.I have a listings page which displays results using images and text which are stored in a MySQL database, all is working fine. The images are pulled into the page from the database and each listing can have up to a maximum of 10 images. Some will have all 10, some probably one or two, so the page is coded such that if there's an image in the field, it displays a thumbnail, if there isn't then it shoves a " " in instead.The results page has one main photo (image 1) and then a series of thumbnails (images 2-10) below it and I need to be able to set this up so that when someone clicks on image 2 it shows the full-size version of that image in the div where image1 sits, and the same for however many remaining images there are.
So my question is, how easy it is to do this with javascript and does anyone have any idea how to code it?The main photo sits in a div whose id is "mainphoto" the remainder all sit in a div whose id is "thumbpix".
I have a MySQL database with a table where I store images (the file name, the mimetype of every file and the binary data in a BLOB plus a unique ID). Now what I'd like to achieve is to load an image from the database using AJAX and the POST method. Viewing a specific image using the GET method is quite simple, I just set the SRC attribute of an <img /> HTML tag to link to the PHP file and set the correct GET variables, there's no AJAX needed for that.I click a button or something, and 'behind the scenes' PHP is retrieving an image from the MySQL database, depending on the unique ID that was provided by AJAX through the POST method. AJAX uses the returned data to fill an element somewhere in the document, and that would be the freshly-loaded image.
Alright here's some code:
//PHP retrieving an image: $returnImageQuery = "SELECT imageName, mimetype, imageBinaryData FROM imageTable WHERE ID = $_POST['someID']"; $return = mysql_query($returnImageQuery );
select sum(amount)as Total from studenttbli have wriiten above query ,now i need that amount sum in vbscript variable. i m not able to write tht i have written folowing but it is showing errortotal=sum.filed("Total")
With input box if you type something and refresh the page, the previous words that you typed in will be filtered and be display in a scroll down form in which you can click it.My question is, when I click the input type is it possible to scroll down, and display values that comes from a database? It should also filter the scroll down results. If it's possible I don't know how to do it.
I have a listings page which displays results using images and text which are stored in a MySQL database, all is working fine. The images are pulled into the page from the database and each listing can have up to a maximum of 10 images. Some will have all 10, some probably one or two, so the page is coded such that if there's an image in the field, it displays a thumbnail, if there isn't then it shoves a " " in instead.
The results page has one main photo (image 1) and then a series of thumbnails (images 2-10) below it and I need to be able to set this up so that when someone clicks on image 2 it shows the full-size version of that image in the div where image1 sits, and the same for however many remaining images there are.
So my question is, how easy it is to do this with javascript and does anyone have any idea how to code it?
The main photo sits in a div whose id is "mainphoto" the remainder all sit in a div whose id is "thumbpix".
I need a JavaScript (or something else) that will fade out the web site, on load, and display a series of images, then display a "Continue" button to go back to the web site. I have an idea for a cute (and funny) way to get people interested in my site that has a weird name. I searched high and low (Google!, amongst others) for anything that would be close to what I need, to no avail.
I have succesfully applied the datepicker to a blank textbox. However, when I apply the datepicker to a textbox with the initial value dynamically set to display a value from a database, the date picker genertes an error when anything on it is selected. The datepicker will display when the trigger icon is selected but you cannot select anything from the date picker without generating the following errors: When selecting:
a day: 'undefined' is null or not an object (ui.datepicker.js line 767) a month or year: 'input' is null or not an object (ui.datepicker.js line 755) a back or forward arrow: 'settings' is null or not an object (u.i datepicker.js line 1137) I have looked at these lines in the file, but I have no idea where to begin.
I'm very new to jQuery, only picked it up yesterday, so there is very little I understand at the moment. I have a website on which I would like to display a real time, time-series chart displaying results from a database that is constantly updated. how to pull live data from my database and display it in an alert box on my sight. One of the replies said I should use jquery to achieve this.
I seem to keep chaging my mind about the best way to do this. I am trying to make a gallery that will display images on a page (without a database!) from a folder when a link is cliked. I have used PHP to read the file paths into an array - and this seems to work perfectly. Its output is similar to this:
my site is [URL] and on the homepage i have a jcarouselLite that came with the wordpress template that im using. I cannot get it to display more then 3 images, even if i put another <li> item in there.
I've copied and pasted the last image 2-3 times over and it won't display. I've also tried changing it to a new image and putting it at the end and it still won't display.
I don't post on the javascript forum much, because I don't program in javascript. I do most my programming in PHP and I recently designed a script to grab an image everytime it is updated. The images are checked, to see if they exist in the directory, and if not, are added. So in the end, I will have a series of images.
I want to know use a simple (javascript?) script to go through the directory (or an array of the filenames) and display them at X images per second.
As a test, I'm trying to display a sequence of images on an html page. The first image is displayed initially, but when I click on the button (although I can tell that the sequencing is happening, and the image files are on the server where they're supposed to be) the rest of the images do not display.
I'm trying to get a select box to display text from a database in a div tag from the select box populated by a while loop that also pulls from the database. The only way I can do this is from a javascript written by sending it over to a second page and I need it on just one page. Here is my code below:
$(this).html(); I want to dig out all the images in an rss feed and display them using an image plugin. so I have something like this. $('div#rss_feed p a img').each(function (){ #('#imageviewer').append(this); });
Now that worked but I need each image to be in an li element $('div#rss_feed p a img').each(function (){ var h = '<li class="image"><a href="">'+$(this).html()+'</a></li>'; #('#imageviewer').append(h); });
I know I cant use $(this) like the above but I want to do something of the same effect. Is there a way to get the html code of whatever this is pointing to?
New to Javascripting, new to forum. I searched the forum, and tried to adapt, to no avail. I am building a store and want users to be able to see how two items look together. I have it working, but it uses a drop down. I would like to display many items and have the user click on one "image", from the display of "top" images, to display it on top, and from another section of "bottom" images, click another image to display it on bottom. For instance to see what one plant would look like in different vases. [URL] If I could be picky, is there a way to make it all happen in the BODY of the page? I use DW and a template.
