473,473 Members | 2,092 Online

Sign in
Join

Home Posts Topics Members FAQ

I am trying to display images side by side from mysql database using php, i want 4

5 New Member

----- this is my image.php file---- for getting id----

Expand|Select|Wrap|Line Numbers

 <?php 

 include('connect.php');

     if (isset($_GET['id'])) 

     {

    $gotten =mysql_query("select  *from reg  where id=".$_GET['id']);

    while ($row = mysql_fetch_array($gotten))

    {

    echo $row['id']; 

     }

    mysql_free_result($gotten);

    }

    ?>

-----imagefetcher.php------

Expand|Select|Wrap|Line Numbers

  <html> <head> <title>home page</title> </head> <?php 

include("connect.php");

 $strSQL = "select * from reg";

$rsPix = mysql_query($strSQL);

$numRows = mysql_num_rows($rsPix);

$i = 0;

?> <table border="1"> <tr> <?php

      while($i<$numRows)

     {

     ?> <td> <img src="http://bytes.com/image.php?id=<?php echo mysql_result($rsPix,$i,"id"); ?>"/></a> </td> <?php

      $i++;

          if ($i%3==0)

          {

       ?> </tr> <tr> <?php

         }

        ?> <?php

         }

        ?> <?php

        if ($numRows%3>0)

        {

        ?> <td "colspan="<?php echo $numRows%3; ?>">*</td> <?php

        }

        ?> </tr> </table> </body> </html>

Mar 11 '14 #1

Subscribe Reply

7

2077

8,658

Recognized Expert Moderator Expert

and what’s the problem?

Mar 12 '14 #2

5

New Member

where can i use

Expand|Select|Wrap|Line Numbers

and

tages please tell me as i am new for php me it will be helpfull if you guide me

Mar 12 '14 #3

5

New Member

problem is images are not display its just giving table with image icon but images are not displays

Mar 12 '14 #4

8,658

Recognized Expert Moderator Expert

if you only see the image icon it means that either the image URL is invalid or that the URL didn’t return an image.

in this case the latter because:
- the URL returns an HTML page (without the tags, though)
- effectively you return what you pass in (though in a very complicated way)

Mar 12 '14 #5

5

New Member

i use varchar datatype to store images in database is that possible this may be error ?and the mysql_result is use for blob datatype

Mar 14 '14 #6

8,658

Recognized Expert Moderator Expert

i use varchar datatype to store images in database is that possible this may be error ?

no. the error is that image.php doesn’t return an image.

Mar 14 '14 #7

5

New Member

thanks for your reply let me play with image.php

Mar 14 '14 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

How can I display images from a mySQL Database in a web page?

by: Dan Anderson | last post by:

I have created a BLOB field to store images. Is there any way to embed them within HTML with something like: <image start: jpeg> </image> Thanks in advance, Dan

not able to access records from mysql database using jsp

by: menmysql | last post by:

i am not bale to solve this problem since two weeks i am trying to access records from mysql database using jsp. inside this jsp program i wrote all my JDBC code. it is working very nicely and...

Connect to MySQL Database using PHP

by: christopher_board | last post by:

Hi all. I am trying to connect to a MySQL Database using PHP on a local machine using locahost. I am using the following code <?php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass =...

Having similar records only display once with a mysql database using PHP

by: WiseG1rly | last post by:

Hey everyone! I am completley new and I will start off by saying that I am not a programmer - figuring out this search took so long! I am debugging now and would appreciate any help :) ...

Is there anyway to access MySQL database using ODBC without opening port 3306?

by: Suresh P | last post by:

Hi All, I tried to access the mysql database in ODBC using ip address and username/password. It returns, "cannot connect to MySQL server on IP ADDRESS(10060)". This could be related to Firewall...

How to import/export an existing MySQL database using neatbeans?

by: nadeenahmed | last post by:

I have Connected to a MySQL Database using a neatbeans editor. Now, I want to use that same database I created earlier on another pc. Can anyone help and tell me how that is done, please? Thank...

How to add multiple pinpoints on Google maps from mysql database using PHP?

by: mfaisalwarraich | last post by:

Hi everyone, I am trying to add multiple pinpoint to google map using Lon/Lat. All addresses will be fetched from mysql database using PHP. I have looked at google and searched for it on...

How to import the Excel data in mysql database using php script?

by: santhanalakshmi | last post by:

Hi, I wrote some coding, to import excel data in mysql database using PHP Script? But my script, its not all inserting the excel data in mysql database. I don't know, what mistake did i made?...

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap

Advertise on Bytes
How to Post and Respond on Bytes
How to Promote and Link on Bytes
How to increase your Ranking on Bytes
Become a Recognized Expert on Bytes
Feedback Welcomed! Contact Us