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

2009-03-07 Thread Sashikanth Gurram
This is the location where I have saved my images. /C:\Users\Sashikanth\Desktop\Bldgs_lots\Burruss.jpg /I have loaded the above location exactly into my database. But when I call it using /echo img src='$location' border='1' height='150' width='200' alt='$build' ;/ It is simply giving me

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

2009-03-07 Thread mrfroasty
Hello, Does something like this work on your php script? $location=..\..\Bldgs_lots\Burruss.jpg OR $location=..\Bldgs_lots\Burruss.jpg GR Muhsin Sashikanth Gurram wrote: This is the location where I have saved my images. /C:\Users\Sashikanth\Desktop\Bldgs_lots\Burruss.jpg /I have

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

2009-03-07 Thread Sashikanth Gurram
Hi, Yes. But I assign the location of the image ( C:\Users\Sashikanth\Desktop\Bldgs_lots\Burruss.jpg) to the $location variable by using the mysqli_fetch_array($data) command. I send a query to the db and the result is obtained and the image location is stored into $location. So it is pretty

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

2009-03-07 Thread Joao Gomes Madeira
Hello again Sashi The answer provided by Mushin won't work because images are not acessible from the outside. You can't have img src=C:\Users\Sashikanth\Desktop\Bldgs_lots\Burruss.jpg ... because that's not a valid URL... You can have something like img src=Bldgs_lots/Burruss.jpg ... which

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

2009-03-07 Thread Sashikanth Gurram
Hi JP, Thanks for chipping in again. I have been using the following code (after retrieving the local location of my image to the variable $location. I am not really looking to host the pictures onto a site as of now), which u have earlier provided me with / $err=1; if ($img =

[PHP-DB] I Had Bad Information Taken Off My Report

2009-03-07 Thread Kezia Holdeman
Hi! Today, I have erased two, outstanding bad debts totalling almost 10 thousand dollars, from my report. They were not mine, but I did not know how to proceed. This, alone, will save me THOUSANDS in interest, and more importantly, will make me a good person again, in their eyes. How I did

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

2009-03-07 Thread Phpster
Bet the image is not readable from the web server. Bastien Sent from my iPod On Mar 7, 2009, at 5:04, Sashikanth Gurram sashi...@vt.edu wrote: Hi, Yes. But I assign the location of the image ( C:\Users\Sashikanth \Desktop\Bldgs_lots\Burruss.jpg) to the $location variable by using the

[PHP-DB] Problem with PDO exceptions

2009-03-07 Thread Daniel Carrera
Hello, I have MySQL 5.1 and PHP 5.2. For some reason PDO is not throwing exceptions when I give it a broken SQL query. For example: try { $stmt = $db-prepare(SELECT * FROM foobar WHERE 1); } catch(PDOException $e) { error($e-getMessage()); } In this example there is no table

Re: [PHP-DB] Problem with PDO exceptions

2009-03-07 Thread Kesavan Rengarajan
I think it is a bug. I have seen this happening at work (PDO not throwing exception when executing a query on a non existing table) News on iPhone: http://trk7.com/mob On 08/03/2009, at 6:44 AM, Daniel Carrera daniel.carr...@theingots.org wrote: Hello, I have MySQL 5.1 and PHP 5.2. For

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

2009-03-07 Thread Sashikanth Gurram
Hi, I have tried it in 3 browsers (Chrome, firefox and internet explorer) and none of them has given me any image. -Sashi Phpster wrote: Bet the image is not readable from the web server. Bastien Sent from my iPod On Mar 7, 2009, at 5:04, Sashikanth Gurram sashi...@vt.edu wrote: Hi,

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

2009-03-07 Thread kesavan trichy rengarajan
drop the images into a folder within your WAMP servers htdocs directory and then update your database tables with the new location.. for security reasons you will not be able access files outside your web directory through PHP On Sun, Mar 8, 2009 at 11:34 AM, Sashikanth Gurram sashi...@vt.edu

Re: [PHP-DB] Problem with PDO exceptions

2009-03-07 Thread Zoltan Ormandi
Hi, Did you set the value of the |PDO::ATTR_ERRMODE| attribute to |PDO::ERRMODE_EXCEPTION|? Btw, I don't think ||prepare would throw an exception even for a malformed query, but ||execute definitely should. Regards, Z

Re: [PHP-DB] Problem with PDO exceptions

2009-03-07 Thread kesavan trichy rengarajan
yup, I have set the |PDO::ATTR_ERRMODE| attribute to |PDO::ERRMODE_EXCEPTION| and I am still not getting an exception! My Code is something like this: $query = $db-prepare($sql); $query-execute($bind); $row = $query-fetch(PDO::FETCH_ASSOC); wher $db is the PDO obj and

Re: [PHP-DB] Problem with PDO exceptions

2009-03-07 Thread kesavan trichy rengarajan
I am sorry, setting |PDO::ATTR_ERRMODE| attribute to |PDO::ERRMODE_EXCEPTION| *does* throw an Exception when the table cannot be found. Stupid me; I was trying to catch Exception rather than a PDOException. On Sun, Mar 8, 2009 at 6:03 PM, kesavan trichy rengarajan k...@trk7.comwrote: yup, I