robertlob

I found a working solution: Removed this line from my code... $row = $result->fetch(PDO::FETCH_ASSOC); and it seems to solve the problem. The is a similar Q in the FAQ section, although it regards mySQL instead of SQLite. "The function returns the next row in the result set and advances the internal pointer. So before your loop runs, you're already pointing at the second row in the result set." Removing that line allows it to start at the first row." -Robert

The following snippit should retrieve 10 images stored in an SQLite database table. But for some reason that mystifies me, it only retrieves 9. (Or one less than the number of images that are actually stored on the table): ___________ # retrieve photos for this property $query = "SELECT * FROM binary_data where propID = $prop_id"; $result = $db->query($query); $row = $result->fetch(PDO::FETCH_ASSOC); # save each image data to file foreach($result as $row) { $filename = $row['filename']; $image = $row['bin_data']; file_put_contents($filename, $image); } ?> _____________ It saves the ones it gets to the temporary files as it should, and they appear on the webpage as they should. But one is always missing. Any suggestions/corrections appreciated. -Robert

Gentlemen- Thank you. Fastsol for reminding me I forgot the {}; and Psycho for straightening us both out. It's working fine now. I appreciate your help. -Robert

I am trying to convert and old website from mysql database to sqlite. One of the chores it must do is collect information from the database and put it in a list/menu select box on a page so the user can choose which item to pursue. In the following (incomplete) snippit, I am doing something incorrectly because the sql query does get the proper information (I can put it in a table on the page just fine). But I'm having trouble getting the information into the select options on a list/menu. It appears to be putting them all, one after the other in the first option spot. The last one seems to be the only one of 6 or 7 that shows up. It's been 10 or 12 years since I've messed with php, so I think I'm way behind... any help would be appreciated. --------------------------- <form action="sqlPropDisplay.php" method="post" id="Residential"> <select name="ResidentialListMenu" size="7" id="ResidentialListMenu"> <?php try { //open the database $db = new PDO('sqlite:bilgerdb'); $result = $db->query('SELECT PropID, PropLocation FROM property WHERE PropCategory = "Residential" ORDER BY PropListingDate'); } catch (PDOException $e) { print 'Exception: ' .$e->getMessage(); } foreach($result as $row) $rec = $row['PropID']; $loc = $row['PropLocation']; ?> <option value=<?php echo $rec ;?> selected><?php echo $loc ;?></option> </select> //submit button code omitted. I think I can handle that when I get to it ---------------------------- Thank you, Robert

mj- Thank you so much. Lots of reading and better ideas than I was coming up with. Appreciate the assistance. I already have one of them in the works.

Thanks, guys - The webpage is a listing of officers and directors of a small fraternal organization. Each listed person would have a link that when clicked would call an email form from the viewer's familiar email client in order to contact that person. Very simple, except for the potential of spam harvesters. Viewers could email membership inquires, etc., and the officers/directors would have a simple place to email each other back and forth using their regular email client. I'm sure they would still receive some crackpot messages, but I'm trying to limit their exposure to automated email address harvesters. Obfuscation like "robertlob at huges dot net" or "[email protected]" where they are supposed to modify the address on the mail form by removing the "spamtrap." just complicate things. Most of these folks are elderly and not computer gurus. Using a php form would work, but it doesn't use their familiar email client, nor leave a copy of the "sent" message. Captcha, I'm afraid, would mess up their mind. I was hoping to use a php script to do the lifting while keeping the actual email address invisible in the source code view. My attempt (below) loads when the page loads so the address does show in the source code view all the time, just like the regular "mailto:" link. Which defeats the purpose. <?php $mailRobert = 'mailto:[email protected]'; $href_anchor = "a href= " . $mailRobert . " /a"; $mailLine = "You can email me <" . $href_anchor . "> Here"; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Untitled Document</title> </head> <body> <?php echo $mailLine; ?> </body> </html> Could I incorporate some Javascript to call similar php code only "on click", and auto delete it once the client email form appeared on screen? Would that at least limit source code exposure to a few seconds while the email client form was called? Opinions, suggestions all appreciated. [attachment deleted by admin]

Is there a way of using php to keep spam-bots from harvesting email addresses from a web page by calling a php function that would do the same thing as a "mailto:" link in html? I'm thinking php doesn't show up in source file code on a browser, so maybe it would work. I just need a link on the webpage that says "Email Me" and calls a php function that would open a mail form from the resident email client on the user's computer. It would of course, show the "To" address to the user, (but hopefully not to any non-human bots) who would fill out the rest of the email and send it on its way just like a normal "mailto:" link does. Any suggestions on how to go about this, or am I all wet??