A really good starting-level textbook is Fabian Pascal's "Practical issues in database
management". My warm recommendation.
It will give you a decent theoretical understanding as well as helping you designing
your DB in order to avoid the most usual design mistakes. You will find there VERY
im
Chip:
Just use the names of the fields as the values too:
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 when reloading a form
I have my email checker wo
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 onl
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
Are you setting the variables in the form?
Something like this - note the value field in the username field:
Username:
Password:
This way, depending on how youare refreshing the login form, if the
$username variable passed your validation tests it
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.
O
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 fe
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
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: Tuesd
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
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 pos
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 --wi
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 hav
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 c
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 P
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
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 th
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 pas
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 just
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
> >>
> 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 LO
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 PRO
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=
>>"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 sub
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:
http://domaine/index.ht
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 wro
Hello all,
How do you people solve the problem of multi-table updates?
Consider the following scenario:
You got a php-program that has, say, ten fields.
You got your database that has it's data normalized (as the
good database designers we all are *grin*) and split up over,
say, four tables.
N
27 matches
Mail list logo
