[PHP-DB] Storing Image Location in MySQL

2009-02-22 Thread Sashikanth Gurram
Dear All, I am trying to store the location of a image into MySQL database, so that I can call it back from PHP to display it in a browser. For this purpose, I have created a table with two columns (BuildingCode, Location), where building is the primary key and location is the location where

Re: [PHP-DB] Storing Image Location in MySQL

2009-02-22 Thread Phpster
On Feb 22, 2009, at 5:17, Joao Gomes Madeira jpcg@gmail.com wrote: Hey Sashi You want something similar to this: (you must have GD installed on Apache) you can have this working by doing something like this in HTML: img src=picture.php?qry=123 and having as picture.php: ?php ... get

Re: [PHP-DB] PHP5: Initial connection to the MySQL server is carried out using the apache webserver userid

2009-02-22 Thread Chris
Paul Will wrote: Hi, When I attempt to connect to a MySQL database I have noticed that the initial connection is made using the wwwrun userid (this is the userid that my Apache2 webserver is running under.) This is the output I see from the Firefox View Frame Info Function Notice: Undefined

Re: [PHP-DB] Issue 45979: PHP code attached

2009-02-22 Thread Chris
This is the page called ~~~ ?php #phpinfo(); # phpinfo displays the correct info. #exit; $sqldb= $_POST[sqldb]; $sqluser = $_POST[sqluser]; $sqlpass = $_POST[sqlpass]; $sqlhost = $_POST[sqlhost]; $link = mysql_connect($sqlhost, $sqluser, $sqlpass); What happens

Re: [PHP-DB] Storing Image Location in MySQL

2009-02-22 Thread Chris
Sashikanth Gurram wrote: Dear All, I am trying to store the location of a image into MySQL database, so that I can call it back from PHP to display it in a browser. For this purpose, I have created a table with two columns (BuildingCode, Location), where building is the primary key and

Re: [PHP-DB] Issue 45979: PHP code attached

2009-02-22 Thread Bastien Koert
On Sun, Feb 22, 2009 at 4:43 PM, Chris dmag...@gmail.com wrote: This is the page called ~~~ ?php #phpinfo(); # phpinfo displays the correct info. #exit; $sqldb= $_POST[sqldb]; $sqluser = $_POST[sqluser]; $sqlpass = $_POST[sqlpass]; $sqlhost =

Re: [PHP-DB] Issue 45979: PHP code attached

2009-02-22 Thread Chris
This is the page called ~~~ ?php #phpinfo(); # phpinfo displays the correct info. #exit; $sqldb= $_POST[sqldb]; $sqluser = $_POST[sqluser]; $sqlpass = $_POST[sqlpass]; $sqlhost =

Re: [PHP-DB] Storing Image Location in MySQL

2009-02-22 Thread Sashikanth Gurram
Thanks fir the suggestion Chris -Sashi Chris wrote: Sashikanth Gurram wrote: Dear All, I am trying to store the location of a image into MySQL database, so that I can call it back from PHP to display it in a browser. For this purpose, I have created a table with two columns (BuildingCode,

Re: [PHP-DB] Storing Image Location in MySQL

2009-02-22 Thread Sashikanth Gurram
Hi JP, Can you please let me know what is a GD? I have not installed Apache separately. I am using the WAMP server currently. Do I have to install any additional stuff before I can retrieve the image location from the db and display it in my browser? -Sashi Joao Gomes Madeira wrote: Hey

Re: [PHP-DB] Storing Image Location in MySQL

2009-02-22 Thread Sashikanth Gurram
Phpster wrote: On Feb 22, 2009, at 5:17, Joao Gomes Madeira jpcg@gmail.com wrote: Hey Sashi You want something similar to this: (you must have GD installed on Apache) you can have this working by doing something like this in HTML: img src=picture.php?qry=123 and having as picture.php: