Re: excel or word and PHP/mysql

From: Roger Smith (roger_at_ns_jadebox.com)
Date: 10/28/03

  • Next message: DM: "Re: Select unique data from a field" 
    Date: Tue, 28 Oct 2003 14:23:13 GMT

    > > is it possible for EXCEL or WORD document to be automatically
    > > inserted into MYSQL database? somehow?
    >
    > Yes. Define the respective field as BLOB and be sure to addslashes()
    > before inserting and stripslashes() some time between retrieval and
    > output to client.

    You shouldn't do a stripslashes() on data retrieved from MySQL. You add
    slashes so that the syntax of the INSERT or UPDATE query is correct. The
    added slashes are not actually stored with the data.

    -- Roger
    http://www.jadebox.com/

  • Next message: DM: "Re: Select unique data from a field"

    Relevant Pages

    • Re: excel or word and PHP/mysql
      ... >> before inserting and stripslashessome time between retrieval and ... >> output to client. ... >You shouldn't do a stripslashes() on data retrieved from MySQL. ... >slashes so that the syntax of the INSERT or UPDATE query is correct. ...
      (alt.php)
    • Re: Simple security question
      ... The information is uploaded to a mysql database ... Do NOT apply htmlspecialchars before inserting into DB. ... applying htmlspecialchars before DB insertion, ...
      (comp.lang.php)
    • Re: IncludePicture Problem on Merge to New Document
      ... or is it inserted using a field (e.g. a MAILMERGE field)? ... You can also try P:/Portage (and yes, with forward slashes it would be a single slash). ... I tried inserting this registry setting and it made no difference AFAICS) but it may be worth making sure: ... I have a Word document that includes an IncludePicture Field. ...
      (microsoft.public.word.mailmerge.fields)
    • Re: IncludePicture Problem on Merge to New Document
      ... I've tried changing the slashes in the ... source data to both \\ and / with no luck. ... inserting this registry setting and it made no difference AFAICS) but it ...
      (microsoft.public.word.mailmerge.fields)
    • Re: New lines from php to mysql
      ... > but I am unsure how to prepare data before inserting ... mysql_escape_stringbefore you add text to your MySQL database. ... quotes or double quotes. ...
      (comp.lang.php)