Jump to content
Forums are read-only ×
Larry Ullman's Book Forums

Randy

Members
 View Profile  See their activity

  • Posts

    4

  • Joined

  • Last visited

Randy's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Randy
    Okay, I found a solution on a different website. Move $auth->start() before the ?><!DOCTYPE as shown below. Any problems with this approach? $auth->start(); ?><!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" xml:lang="en" lang="en"> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> <title>Restricted Page</title> </head> <body> <?php
  2. Randy
    windows 7 x64 php v 5.3.1 MySQL client version: 5.1.41 XAMPP for Windows 1.7.3 Any one have any modifications suggestions to the login script (script 4.3 page 146) to avoid the headers already sent warning? I'm using the downloaded script and am having issues figuring this one out. Thanks
  3. Randy
    Larry, Thanks for the response. I've figured it out (after a bit more debugging and using phpmyadmin). This wan't a MYSQL DATA privilege (select, insert, update, delete, or file) it was a STRUCTURE issue in the privileges. The only thing I toggled on was the Execute without the Executue on it doesn't work. GRANT SELECT , INSERT , UPDATE , DELETE , FILE , EXECUTE ON * . * TO 'username'@'localhost' (or 'someuser' or whoever) Else you get this error ~Andy
  4. Randy
    windows 7 x64 php v 5.3.1 MySQL client version: 5.1.41 I was trying to get this: "SELECT name, CONCAT_WS('<br />', address1, address2), city, state, stores.zip_code, phone, store_image,ROUND(return_distance($lat, $long, latitude, longitude)) AS distance FROM stores LEFT JOIN zip_codes USING (zip_code) ORDER BY distance ASC LIMIT 3" to work in my distance.php script (store_image was an added field). It took me a while to debug this problem, but I eventually got it to work. My 'someuser' (and I'm guessing others who jumped from your PHP6 MYSQL5 book to this one) doesn't have the same privileges to mysqli functions as the 'root' user does, so I couldn't get this script to run outside the admin programs. I don't want to give 'someuser' ALL PRIVILEGES, so which additional privileges do I need to enable for 'someuser'(currently SELECT, INSERT, UPDATE, DELETE, FILE)? Thanks for the great books (and any help), ~Randy
×
×
  • Create New...