Re: [PHP-DB] Secure database connectivity?

2001-04-19 Thread Victor Foitzik
Hello Stuart, on 19.04.2001 you wrote: > Hi people, > I'm setting up a database to collect email addresses on my web site, but I > want to avoid using the insecure connection method: > mysql_connect("host", "user", "pass") > as this obviously displays my username and password to anyone who wan

Re: [PHP-DB] Fatal error: undefined function mysql_connect()

2001-04-19 Thread Victor Foitzik
Hello franky, on 13.04.2001 you wrote: > I'm trying to connect to mySQL DB by Web page > and > when I use mysql_connect() > this append: > Fatal error: Call to unsupported or undefined function mysql_connect() > thanks! are you really sure your php has mysql support compiled in (yes, it is po

Re: [PHP-DB] Advice On Building Dynamic MySQL Queries

2001-04-19 Thread Victor Foitzik
Hello JD, on 19.04.2001 you wrote: > if (!empty($Price)) > { > if(empty($whereclause)) > { > $whereclause.="Price$Price"; > } > els

Re: [PHP-DB] Advice On Building Dynamic MySQL Queries

2001-04-19 Thread Victor Foitzik
Hello JD, on 19.04.2001 you wrote: > I am building a query from a search form. This is the code I have now: > if (!empty($whereclause)) > { > $whereclause=urldecode($whereclause); > $whereclause=stripslashes($whereclause); > } > extrac

Re[2]: [PHP-DB] OCI_DEFAULT

2001-04-19 Thread Victor Foitzik
Hello Johannes, on 19.04.2001 you wrote: > hi, > OCIExecute() executes a previously parsed statement. (see OCIParse(). The > optional mode allows you to specify the execution-mode (default is > OCI_COMMIT_ON_SUCCESS). If you don't want statements to be committed > automaticly specify OCI_DEFAULT

Re: [PHP-DB] Does anyone know, or is it even possible

2001-04-11 Thread Victor Foitzik
Hi Brian, this really depends on what kind of user authentication you are using by now. Apache is capable of doing authentication by many methods, not only static .htaccess files, but also via MySQL, PAM or other. You should speicify what kind of system you are using ... HTH Victor > Okay, > >

Re[2]: [PHP-DB] Display data begin with "A"

2001-04-08 Thread Victor Foitzik
Hi, if you're using MySQL, the simpliest method is using RLIKE SELECT stuff FROM table WHERE stuff RLIKE '^[0-9]+'; see http://www.mysql.com/doc/S/t/String_comparison_functions.html http://www.mysql.com/doc/R/e/Regexp.html for more info HTH Victor > Okay it's working now.. > How if I want to

Re: [PHP-DB] newbie question

2001-02-04 Thread Victor Foitzik
Hi Lisa, >Can search engines index any HTML pages that have .php as its extension (any >.php pages without a '?' or '&' in the URL) ? For example: >http://www.blablabla.com/blabla.php > >Thanks, >Lisa E yes they can, but my experience is, that most search engine robots do _not_ index pages endi

Re: AW: [PHP-DB] Oracle Persistant Connections

2001-02-04 Thread Victor Foitzik
Hi everybody, We recently had (and have) similar problems running PHP4/Apache with 10 FreeBSD Clients and a SunE450 with Oracle 8.1.6. The machine is quite powerful (4 procs, 4 Gigs RAM). Anyway, we had to limit the number of simultaneous dedicated connections after our server was blown up wit

Re: [PHP-DB] .htpasswd?

2001-02-04 Thread Victor Foitzik
James Smith wrote: >Is there a way that when a user signs up for a >user/pass on a site, to automatically update the >.htpasswd on the site? Right now I'm running a Win2k >Pro, with Apache installed and MySQL/PHP. > >Thanks, > >James The quite simpliest method is to put appropriate directives

Re: [PHP-DB] Problem with oci8

2001-01-12 Thread Victor Foitzik
Hi Mateus, this is not really true. As you mentioned libclntsh is linked with pthread and so must be apache. first, add the oracle lib path to ld.so.conf and run ldconfig. now try the following for apache: LDFLAGS=-lpthread ./configure \ --prefix=/usr/local/apache \ --enable-mod

Re: [PHP-DB] sql: LIKE

2001-01-10 Thread Victor Foitzik
if you mean something like "SELECT * FROM THETABLE WHERE subject LIKE '%foo%' ORDER BY hitcount ASC" yes it is ... ;-) >Hi there. Is there a way to sort results of a '.. WHERE subject LIKE %foo%' >query by HITS in order to use it for a search engine? -- PHP Database Mailing List (http://www.ph