im using query SELECT * FROM table WHERE field LIKE '% $variable %'
with this, i want it should not be case sensitive, and should not
distinguish betn ram,Ram,RAM. but its not doing so. i don't want the case
sensitive result.
what can i do to overcome this ? pls suggest any other possible
Hiya folks:
I wish to be able to select items from MySQL if a variable passed via
the $_GET method to my PHP4 page is introduced thus:
$sql = SELECT TourName,TourID,$_GET[CatID] IN (TourCatID) FROM tour;
When I echo $sql to the page, the query looks fine but doesn't work, in
as far as the
I am trying to find out how I can secure the directory tree of my PHP
scripts from the HTTP server without preventing access to my PHP scripts
once in session. Right now, if I type the URL of a subdirectory of my site,
I get the index of all the files and directories.
Ex:
Bmw [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I am trying to find out how I can secure the directory tree of my PHP
scripts from the HTTP server without preventing access to my PHP scripts
once in session. Right now, if I type the URL of a subdirectory of
for ($i=0; $i = $brute_queries_max; $i++) {
HTH
-Joni-
Florin Andrei [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I'm using:
- apache-1.3.22
- mysql-3.23.49a
- php-4.0.6
- Linux Red Hat 7.2
I have a piece of code that does this:
for ($i=0; $i
Cheers for helping me out guys.
It proved to fiddly and kludge-like to do what I wanted in SQL (I'll
wait until MySQL 4 stable version is about)
So I did some stuff with PHP arrays which worked fine.
Thanks a lot anyway.
Russ
-Original Message-
From: Ignatius Reilly [mailto:[EMAIL
im using query SELECT * FROM table WHERE field LIKE '% $variable %'
with this, i want it should not be case sensitive, and should not
distinguish betn ram,Ram,RAM. but its not doing so. i don't want the case
sensitive result.
You can do it in this way:
SELECT * FROM table WHERE
On Tuesday 20 August 2002 16:30, bmw wrote:
Bmw [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I am trying to find out how I can secure the directory tree of my PHP
scripts from the HTTP server without preventing access to my PHP scripts
once in session.
If you are running Apache and have access to the httpd.conf file. Comment
out AddModule mod_autoindex.c and restart apache. if you like this for
some of your directories, then I'd follow Jason's advice. If you are using
IIS or another server, I'm sure the same option is available, but I'm
That's what I'm doing. Since we require IE 5.0 + on our workstations I can get away
with Integrated Authentication only. If you want to support Netscape you'll have to
allow Basic Authentication (which is not very secure but fine on an intranet). With
that enabled the Win2k workstation will
I am trying an email verification function, like this:
if (empty($useremail)) || !eregi(^[A-Za-z0-9\_-]+@[A-Za-z0-9\_-]
+.[A-Za-z0-9\_-]+.*, $email))
{
$errmsg .= The email address appears to be invalid\n;
}
But it will not work, on one server I get this
Just a note for others who went through what I did, and a note of thanks.
Regranting and flushing privileges, make everything run smooth for me. :)
Joni Järvinen wrote:
Hi.
Try re-GRANTing the rights for user 'crash' and after you've done that,
run 'flush PRIVILIGES'. Atleast on my winxp box
Well, one thing is you've got mismatched parentheses. You need another
another opening paren right after the if.
Also, don't you need to escape the last hyphen in your character sets?
As well as the . before the third character set?
-Steve
On Tuesday, August 20, 2002, at 11:11 AM, [EMAIL
Steve Cayford [EMAIL PROTECTED] wrote on 08/20/2002 10:28:46 AM:
Well, one thing is you've got mismatched parentheses. You need another
another opening paren right after the if.
Also, don't you need to escape the last hyphen in your character sets?
As well as the . before the third
I have my email checker working now, and all the other fields are checked
also, but when I do enter
some wrong data the form is reloaded with all blank fields. I'm sure there
is a way to keep the existing
data in the fields so the end-user will only have to change the incorrect
fields, and not
We have installed PHP 4.2.2 in a Solaris 2.6, with Netscape Enterprise
Server 3.5.1 and Sybase SQL Server/11.0.3.3.
We compiled PHP with following options, and it was successful completed with
no errors.
./configure --with-nsapi=/opt/netscape/suitespot --enable-track-vars
--enable-libgcc
I've installed freetds 0.53, php 4.2.2 and apache 1.3.26. I have some of
the mssql functions working (mssql_connect(), for example). I cannot get
mssql_init() to work - I get Fatal error: Call to undefined function:
mssql_init() in /var/www/html/stdFunctions.php on line 128
I saw a previous
If you use MySQL, instead of INSERT, do a REPLACE--they use the same
syntax. Read about it here: http://www.mysql.com/doc/en/REPLACE.html
On Tue, 2002-05-21 at 00:32, Markus Lervik wrote:
Hello all,
How do you people solve the problem of multi-table updates?
Consider the following
Look into the PHP_AUTH_USER variable. It is assigned through basic
authentication.
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
Pay It Forward
mailto:[EMAIL PROTECTED]
http://accessingram.com
-Original Message-
From: bmw [mailto:[EMAIL PROTECTED]]
Sent:
bmw wrote:
You could restrict autoindexing through apache's httpd.conf.
Look it up in apache's manual.
Milan
This is not my personal web server. It is a remote ISP which provides PHP
and MySQL support. I cannot control the HTTP or PHP server build
I was wondering if there were any good documents out there about good database
design...I know the basics of creating tables, setting data types and such, and now i
want to know how to use it to the best effect...generating logical, streamlined
tables, etc.
As a side-related note, i have a
Ok, the restart of the loop happens after 300 seconds no matter what.
Seems to be a timeout, but then why i don't get an error instead of the
loop starting all over again?
And i don't see anything in php.ini that could be related to that.
I upgraded to php-4.1.2 and the problem is still there.
Are you setting the variables in the form?
Something like this - note the value field in the username field:
form method=post action=index.php name=loginuser
table summary=layout table to hold login data width=300
align=center cellpadding=1 cellspacing=0 border=0 bgcolor=#ff
tr
td
Shiloh Madsen wrote:
I was wondering if there were any good documents out there about good database
design...I know the basics of creating tables, setting data types and such, and now i
want to know how to use it to the best effect...generating logical, streamlined
tables, etc.
have you got
On Wednesday 21 August 2002 09:15, leo g. divinagracia iii wrote:
you can use either TEXT, MEDIUMTEXT or LONGTEXT. 64K, 16 million and 4
billion bytes, respectively...
the downside is the space taken up when the actual data is less than the
field size.
The actual space taken up is only a
Chip:
Just use the names of the fields as the values too:
input type='text' name='Email' value='$Email' /
HTH :-)
Russ
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 21, 2002 1:58 AM
To: PHP_DB
Subject: [PHP-DB] keeping form field data
26 matches
Mail list logo
