Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: leegold
  • Order by date
  1. leegold

    using htmlspecialchars in forms - help

    Hi, Could someone give me a snippet that I can put in the form please?
  2. leegold

    using htmlspecialchars in forms - help

    Problem is whenvever I enter Sally's New Car into a form and post to a new page the apostrophie is lost so I get: Sally s when I echo it on the page it's posted to. I think I need the PHP function: htmlspecialchars. I've seen the man page but still not sure how to implement - if anyone...
  3. leegold

    newbie ALTER syntax help

    >alter table keywords change key_id page_id int(10) unsigned NOT NULL PK auto_increment; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PK auto_increment' at line 1 I'm trying to change...
  4. leegold

    fatal error installing PEAR - trying to get help please!

    Below please see my attempt to install PEAR on my WIn2k. I have no idea how to proceed. I really would appreciate help. 1-7, 'all' or Enter to continue: The following PEAR packages are bundled with PHP: DB, Net_Socket, Net_SMTP, Mail, XML_Parser, PHPUnit. Would you like to install these as...
  5. leegold

    PEAR is not working

    It's supposed to install PEAR. I'm going over to the PEAR mail list to get help - the intro. docs. are a bit scant imho
  6. leegold

    PEAR is not working

    I just ran: c:\php\go-pear.bat It was already there in the PHP, I didn't download anything from PEAR. I defaulted thru what looked like a "good" install in the DOS box on my PC. Any help appreciated - Thanks,
  7. leegold

    PEAR is not working

    Using win32. There's no pear.bat file. There's an old-pear bat file but no pear.bat. Thought I installed PEAR according to the instructions. IMO PEAR should be innstalled automatically when PHP installs, but they don't do that for some reason. Can anyone help me get PEAR working? Thanks
  8. leegold

    help escaping characters in PHP/MYSQL

    Note: note sure if the MYSQL is a better forum - if so please tell me - I'm really not sure which to post to. Anyway please see ques. below, // This statement below works: // mysql_query("INSERT INTO page (page_url) VALUES (\"$url_field\")"); But I wanted to insert into two fields so I was...
  9. leegold

    DESCRIBE TABLE question

    In the default col. there's a NULL. Page_id field is my PK and I didn't create it with NULL as a default - what does the "NULL" mean. The table seems to work fine - but I'm sure I never mentioned NULL in association with the auto-increment PK field...? Thanks mysql> describe page...
  10. leegold

    read from a form's textarea into a file with PHP

    mysql> describe page; +----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+------------------+------+-----+---------+----------------+ | page_id | int(10) unsigned | | PRI | NULL |...
  11. leegold

    read from a form's textarea into a file with PHP

    Can I read from a form's textarea into a file in one "swoop", what's the cleanest way in PHP? Say that I've already created an empty file on my drive for this purpose and I'm using POST to get the textarea txt from the hmtl form to the processing .php file. Thanks, Lee G.
  12. leegold

    cannot connect to MYSQL from PHP

    I can connect in the php by using 'root' and the root pw. But when I tried adding a user ( sarah ) with GRANT I cannot connect from php. The php is simple, what am I overlooking? Again putting the root user name and pw it'll work in php but not for sarah: the php...
  13. leegold

    "Warning Do not use Apache 2.0 and PHP - please explain

    From: http://www.php.net/manual/en/install.apache2.php "Warning Do not use Apache 2.0 and PHP in a production environment neither on Unix nor on Windows" Could someone explain this in simple terms? It seems like it's saying don't use php(?!) Why would php.net say don't use php???
  14. leegold

    php form with get not working

    When I try the code below and click submit the the browser stays at the form page. I see a problem: in the address bar of the browser it's: http://localhost/formtest.php/search_test2.php?key_word=robin it should be: http://localhost/search_test2.php?key_word=robin it's putting in the form...
  15. leegold

    Help maintaining state across pages

    Probably a newbie question about "state": My problem is I have a search form, so user enters a keyword <enter>, then this form posts to another page were the result are displayed. But this display page uses pagination to break the results up into several subsequent pages. The 1st page is OK...
  16. leegold

    advanced nested SQL question

    C:\>mysqladmin -V mysqladmin Ver 8.40 Distrib 4.0.20a, for Win95/Win98 on i32 You're kidding me!!! I'll upgrade!!!
  17. leegold

    advanced nested SQL question

    Given: mysql> show tables; +-------------------+ | Tables_in_balloon | +-------------------+ | balloon_rec | | balloon_txt | +-------------------+ mysql> show columns from balloon_txt; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key...
  18. leegold

    Search one table, then display another table where keys match ?

    The only way I can think of to explain what I want to do is to give you my working newbie code that I'm learning PHP/MYSQL with, and at a certain point in the code state exactly as I can what I want to try to do. It's probably quite simple but I can't get it- Thanks: ... <pre> <?php $dblink =...
  19. leegold

    editing all columns in a table

    I have a situation were a table field item has a situation like: \r\ndata\r\n. So an item's got line breaks in there with it in the field, and it's screwing things up for me. How do I do a global clean-up of this and remove all \r and \n for all of that column in my table? If it was flat-file...
  20. leegold

    loading text into table fields -help

    Ok I got a question: Let's say a tab delimited file like this: name is varchar (60) bio is TEXT data type name<tab>bio Jack<tab>name: My name is Jack\ncar: I have a chevy car\npet: My pet's named Fido\n Jane<tab>name: My name's Jane\ncar: I have a VW car\npet: I don't have a pet\n .... How...

Part and Inventory Search

Back
Top