[PHP-DB] All this spam crap
Spam may be a problem, but the solution seems to be even more of a problem at the moment. Can anybody do something about all these spam warnings - even if it means killing valid users until they fix their copy of 'SPAMASSASIN' I think that some 'real' spam is trying to get onto the list as well, but that is actually less of a problem :) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: mySQL Binaries for Linux
You just untar it and copy it to a directory like /ur/local/mysql then copy php.ini to /etc you read the read me that is in the same directory shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s full-path-to-mysql-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db shell chown -R root . shell chown -R mysql data shell chgrp -R mysql . shell bin/safe_mysqld --user=mysql or shell bin/mysqld_safe --user=mysql if you are running MySQL 4.x John Ryan [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I downloaded what I thought was Linux mySQL binaries, and the INSTALL file said there should be a bin directory when I untar, but there isnt! Just a BUILD folder and loads of make files. Did I download the wrong one? I downloaded mysql-standard-4.0.14-pc-linux-i686.tar.gz -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Newbie help
configuring PHP with apache is not that difficult, here's how you should do it: You should get 2 files: php4apache.dll and php4ts.dll , normally you only get these files when you compile PHP manually but conecting to PHP is much safer when you use these files, so if you need to download both versions to use these 2 dll's in your automatic install I assume you have installed both apache and PHP and that Apache works fine. You should try to get Apache 1.3 and not Apache 2 just because Apache 2 support in PHP is still experimental and it is not (yet) recommended to use PHP with apache 2. you must copy the 2 files to the directory php/sapi it is possible that you will have to create the sapi directory. When you have done that open the httpd.conf file, you can find this file in your apache/conf directory and add these lines to the file LoadModule php4_module d:/php/sapi/php4apache.dll AddModule mod_php4.c AddType application/x-httpd-php .php in the first line you should change the path to the path on your pc. now restart your pc and start apache You should see the message Apache 1.3.xx running / PHP 4.x.x. your php scripts will work fine now Greetz DragonEye Nicola Hartland [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I need some help to install and configure php I have tried downloading it a dozen times to configure it on Apache on xp but I cannot seem to get it to talk to my sql could someone provide me with an idiots guide to installing it please? Thanks in advance Nicci -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: All this spam crap
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... Spam may be a problem, but the solution seems to be even more of a problem at the moment. Can anybody do something about all these spam warnings - even if it means killing valid users until they fix their copy of 'SPAMASSASIN' I think that some 'real' spam is trying to get onto the list as well, but that is actually less of a problem :) Perhaps a suitable filter would solve the problem? -- Quod subigo farinam A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? A: Top-posting. Q: What is the most annoying thing on usenet? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] 2 problems
Hi, I am facing 2 problems while using PHP along with form based HTML file. It takes inputs from the user and updates the DB. Problems, 1) Not able to grab and store the checkbox status. 2) Not able to check the correctness of entered interger value. I realized that form always submits (POST) the value as text. Thanks in advance! -- Regards, --Balaji -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] 2 problems
Not really sure of the second part of your question, but, if I remember correctly, check boxes only appear in the POST vars if they're checked. And I'm pretty sure their values are ON. So, if you have a color checkbox named red and tha user checks it, it should show up as $_POST['color'] = ON. If the checkbox is not checked, you won't see it in the POST vars at all. -Original Message- From: Balaji H. Kasal [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 8:24 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] 2 problems Hi, I am facing 2 problems while using PHP along with form based HTML file. It takes inputs from the user and updates the DB. Problems, 1) Not able to grab and store the checkbox status. 2) Not able to check the correctness of entered interger value. I realized that form always submits (POST) the value as text. Thanks in advance! -- Regards, --Balaji -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] 2 problems
the value will be what ever you set the value to be in your html tag. intput type=checkbox name=color value=red if checked $_POST['color'] will equal red. if unchecked, the index 'color' will not be in the $_POST array. hth Jeff Hutchins, Richard [EMAIL PROTECTED]To: [EMAIL PROTECTED] ngeusa.com cc: Subject: RE: [PHP-DB] 2 problems 09/08/2003 08:30 AM Not really sure of the second part of your question, but, if I remember correctly, check boxes only appear in the POST vars if they're checked. And I'm pretty sure their values are ON. So, if you have a color checkbox named red and tha user checks it, it should show up as $_POST['color'] = ON. If the checkbox is not checked, you won't see it in the POST vars at all. -Original Message- From: Balaji H. Kasal [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 8:24 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] 2 problems Hi, I am facing 2 problems while using PHP along with form based HTML file. It takes inputs from the user and updates the DB. Problems, 1) Not able to grab and store the checkbox status. 2) Not able to check the correctness of entered interger value. I realized that form always submits (POST) the value as text. Thanks in advance! -- Regards, --Balaji -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Selection problem
Try unset after the if statement if ($nameb == ){ $query = SELECT * FROM recipes WHERE points $pointsb; } else { $query = SELECT * FROM recipes WHERE name = '$nameb'; $new_nameb = $nameb; unset($nameb); } Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED] Sent: Sunday, September 07, 2003 5:43 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Selection problem Hi there everyone, I'm having a strange problem, I have a form with 2 fields, 1 is for points (Weightwatcher points) and one is for recipe names. If you select points (IE: 1-3, 3-6,6-9,9 and above) it works perfectly, displays the recipes and allows you to select a new points range from the dropdown. Next to it, on the same form, you can also select by recipe name and ignore the points instead selecting by the recipe name - this works fine, you can select 1, view it and then select another. The problem comes when you select a recipe from the dropdown and view it, then decide you want to select points instead - the points won't work once you have selected a recipe. Can anyone see anything below that is wrong? I am sure it's the if statement, i'm not sure how to handle it as you can select either option to get the result. Any help would really be appreciated, if I haven't confused you all to death :-) Regards Chris ? if ($nameb == ){ $query = SELECT * FROM recipes WHERE points $pointsb; } else { $query = SELECT * FROM recipes WHERE name = '$nameb'; }; $sql_result = mysql_query($query,$connection) or die(Couldn't execute query.); while ($row = mysql_fetch_array($sql_result)) { $id = $row[id]; $name = $row[name]; $points = $row[points]; $ingredients = $row[ingredients]; $instructions = $row[instructions]; }; ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: [SPAM?] [PHP-DB] Re: Approved - WARNING!!!!
This is the soBig virus! Do not open attachement! Do not open attachement! Some SMTP servers bounce entire messages, even with attachements! I hope the admin in here can remove this message from the server and NNTP server so other do not get catch opening this! Walter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: [SPAM?] [PHP-DB] Re: Approved
This is the soBig virus! Do not open attachement! Do not open attachement! Some SMTP servers bounce entire messages, even with attachements! I hope the admin in here can remove this message from the server and NNTP server so other do not get catch opening this! Walter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Where is libmysqlclient.so.10 file required for installing php-mysql rpm ?
Hi All, We are using a seperate machine as mysql database server. we have few other machines as application server which will use mysql database from database server using php. Environment Redhat 8.0, Php 4.2.2-8.0.8, apache 2.0 I do not have mysql server or mysql client installed on application server. Each application server is running same website in a load balancing. I am trying to install php-mysql package to get mysql support in php. I am getting following error that libmysqlclient.so.10 library not found. My question is do i need to install mysql to get this library ??. I really do not want to install mysql on application servers and i am already using database server. Any suggestions will greatly be appreciated. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Is it possible to open a .txt file into a recordset for validation?
Want to allow users to upload .txt file and then loop through it's contents to validate and reject/accept based on results. Is this possible? Got any links, code, etc? Thanks __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Is it possible to open a .txt file into a recordset for validation?
[EMAIL PROTECTED] wrote: Want to allow users to upload .txt file and then loop through it's contents to validate and reject/accept based on results. Is this possible? Got any links, code, etc? Yes. http://us2.php.net/manual/en/features.file-upload.php and then http://us2.php.net/manual/en/ref.filesystem.php specifically http://us2.php.net/manual/en/function.fopen.php -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Best method to search mySQL with PHP?
Looking for input on best way to search an mySQL table using PHP. Using LIKE can't be good at all so I was looking into FULLTEXT but then I started to hear horror stories about the length of time it takes to build an index and return results on very large databases. Does anyone have any experience with this? Jeff
[PHP-DB] Clueless abt Error with MySql
Good Evening! I have installed Mysql from RedHat 8.0 and am having difficulties starting mysql. I check the my.cnf file and it appears fine as all files it calls for are in the right directories. When I attempt to start mysql, I get a cannot connect through mysql.sock. What is causing this or put more simply, where did I screw up?? Any help would be appreciated. Robin 'Sparky' Kopetzky Black Mesa Computers/Internet Service Grants, NM 87020 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Clueless abt Error with MySql
On Mon, 2003-09-08 at 19:56, Robin Kopetzky wrote: Good Evening! I have installed Mysql from RedHat 8.0 and am having difficulties starting mysql. I check the my.cnf file and it appears fine as all files it calls for are in the right directories. When I attempt to start mysql, I get a cannot connect through mysql.sock. What is causing this or put more simply, where did I screw up?? Where is it looking for mysql.sock? I believe with rpm based install it should be in /var/lib/mysql. if it's looking in tmp just do a symlink to /tmp/mysql.sock and that should take care of that prob. John Coder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php