Hi All,
I'm after a tutorial, if you can point me to one I'd appreciate it.
I want to create a search script that will look through tables/fields
(that I specify) in a MySQL database.
I don't want to use the MySQL full text searching (as I'm using an ISP
database & the default min word length is
Shall I resign myself to using a search with "like %var%"?
Are there no other better methods?
Maybe REGEXP has something to offer?
-Original Message-----
From: Gavin Amm
Sent: Thursday, 27 November 2003 4:00 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Decent Search Engine (for M
Hi guys,
So that I don't drive members of the mailing list insane:
In Outlook XP (2002), I want to enable the "Out of office" feature; what
I don't want to do is have it reply to every message posted to the PHP
mailing list.
Does anyone know how to create a rule, to do this?
I really don't want
Hi.
I want to update mysql database with parent value of page.
I have several fields in my form.
I have a generated map of web site pages as hyperlinks at end of form.
(generated recursively)
I want to be able to click on hyperlink & have it pass the "parent"
value to the next PHP script.
The poi
by the php script is easy enough like this.
Cheers,
Gav
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 14 April 2004 12:48 PM
To: Gavin Amm
Cc: PHP-mailist
Subject: Re: [PHP-DB] Pass database id through href
Gavin Amm wrote:
> EXAMPLE:
> (I kn
Hi guys,
I'm trying to find a MySQL function(s) that will allow me to count the
number of words in a field.
For eg:
[table: pages]
id - title - keywords - body
1 - Home - home, page - This is my home page. Enjoy your stay.
2 - Feedback - feedback, form, contact - Please enter any feedback or
For what it's worth, if you store your form fields in an array, you can
loop through the array to search for isset & empty on each array element
and have the array add the fields that are relevant to your sql
statement.
Doing this will also ensure that you won't have to modify your script
(that ge
Have you tried - GROUP BY email - ?
> Nope...
> HHmmm, this is really getting to me...
> I can do distinct, I can count, but I can't combine the two?
> Can't be that hard ;-)
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database
I'd really like to find a Linux distro that is a LAMP system right out
of the box.
(Linux, Apache, MySQL, PHP)
Are there any out there?
Cheers,
Gav
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thank you all for your input.
I will try Suse 9.1.
If that doesn't work, I can try the http://www.apachefriends.org/en/
distro.
Regards,
Gavin
-Original Message-
From: Gavin Amm
Sent: Tuesday, 3 August 2004 10:40 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] LAMP
I'd really li
items and your problem should be
solved.
Gavin Amm wrote:
>Hi guys,
>
>I need to generate a menu based on the content structure of my
database.
>
>The data is structured using an 'id' & 'parent' relationship, for eg:
>
>id
>
>parent
>
>title
&g
Sorry, I always forget to reply all...
Original message bellow...
-Original Message-
From: Gavin Amm
Sent: Tuesday, 5 October 2004 3:55 PM
Subject: RE: [PHP-DB] Safe / Secure Login Script
1. Personal preference, but you may find sessions a better option (does
not store user data (like
Hi guys,
I need to generate a menu based on the content structure of my database.
The data is structured using an 'id' & 'parent' relationship, for eg:
id
parent
title
1
0
Home Page
6
1
My Page 2
9
6
My Page 3
15
9
My Page 4
21
6
My Page 5
22
9
My Page 6
23
22
My Page 7
2
Thanks for the link.
I've got a working JavaScript menu system; I wanted a PHP script that
runs once/day to generate the tree structure in the JavaScript config
file. That way each time I added a page to the database, it would be
automatically added to the menu system.
I'm still interested in the
Hi,
I'm trying to call a script with the "?=" after the php script name in the
URL, but can't seem to pick up the variable to use in my script...
any help would be greatly appreciated :)
I'm calling the script with this url:
http://localhost/Data/test/dbconnect2c.php?id=TestPage
The section of t
[mailto:holmes072000@;charter.net]
Sent: Thursday, 7 November 2002 1:20 PM
To: 'Gavin Amm'; 'Php-Db (E-mail)'
Subject: RE: [PHP-DB] Warning - newby question -- $_GET
> I'm trying to call a script with the "?=" after the php script name in
the
> URL, but can't se
Hi,
For some reason the page worked the 1st few times, now I get the error
message (after making no changes to the code from when it worked...):
(line 5 references the "$db = mysql_co..." line of code)
Warning: Unknown MySQL Server Host 'mysql.db.*.net.au' (2) in
/home/.../public_html/public/
Hi,
I'm having some trouble storing html into a MySQL table, it is typed into a
html 'textarea'.
actually, i can't even get basic text to be stored from the textarea.
the mysql_query() works fine with standard text input fields alone.
i try and insert the textarea data in the same way as i do the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
ookey,
(i think Richard Hutchins' idea is a good one, and secure enough that
most sites use this method... but if you want an alternative...)
now i am a newby to security and PHP, but here's my logic:
1. During the account setup (presuming this is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Check out this link:
http://www.pgpi.org/dev/
It is not exactly PHP material, but maybe if you wanted to contact
them & ask them about supporting PHP you might get a response (i'd be
interested if you get a responce, as i think having that
fu
Hi,
I'm wanting to retrieve data from my database using 2 conditions in the
WHERE clause.
How do i pick up 2 different variables from the URL?
i can get just 1 variable easily (eg:
http://localhost/myscript.php?var1=blah)
My question essentially is: what string do do i need to type into the URL t
Thanks Ryan, Ignatius.
-Original Message-
From: Ryan Gallagher [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 20 November 2002 5:37 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] $_get 2 variables
Quoting Gavin Amm <[EMAIL PROTECTED]>:
> Hi,
>
> I'm wanting to r
Hi,
I'd like to test to see if data exists in my table ("count"), and if not
insert some:
This is seudo code of what I'd like:
$sql = "SELECT num FROM count WHERE col1=$var1 AND col2=$var2";
IF $sql returns an EMPTY SET {
INSERT INTO count VALUES('$var1', '$var2', "0");
}
This is the code i
ok,
here's an idea:
Either use a script off the web, or write your own:
During the initial SSL session setup:
- send an e-mail to the client with a web page attached.
(include instructions in the e-mail)
Put javascript into the page to decrypt RC5 (apparently you can get a
patch for MySQL
Hi,
for some reason i'm getting an error when I try to run this query:
__
$sql="SELECT num FROM count where dept='$dept' AND deptsub='$deptsub'";
$page_count = mysql_query($sql,$db);
# If does not exist in the database, insert a new entry
if (!mysql_num_ro
Hi,
I'm trying to update a table ("count") & have been staring at it for a while
now & can't see why it won't update...
here's the code:
$page_count = $page_count + 1;
$sql = "UPDATE count SET num='$page_count' WHERE dept='$dept' AND
deptsub='$deptsub'";
$result = mysql_query($sql, $db);
when
I've realised my problem,
i was trying to read the number of rows & add 1 to that.
(instead of the data in the num field & add 1 to that...)
of course it will return 1 each time!
Gav
-Original Message-
From: Gavin Amm [mailto:[EMAIL PROTECTED]]
Sent: Monday, 25 November
Hi,
I'm trying to pick up data from my MySQL database, use a foreach loop to
extact the data from the result & put that data into a select list.
I have tried the following code with & without the $row = ... line, both
unsucessfully:
-select-
$value\n";}
?>
I get the following er
002 3:44 PM
To: Gavin Amm
Cc: Php-Db (E-mail)
Subject: Re: [PHP-DB] foreach loop from MySQL select query to HTML
select list
On Wed, 2002-11-27 at 23:33, Gavin Amm wrote:
> Hi,
>
> I'm trying to pick up data from my MySQL database, use a foreach loop to
> extact the data from th
ok,
i've looked around the web a bit more & it would appear you can't just use a
foreach function, apparently you need to use a while{foreach{}} structure. i
was hoping you could just use the foreach function?
so this is the code now:
-select-
$value\n";
}
}
?>
but now th
{$row['dept']}\n";
}
?>
cheers, Gav
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Friday, 29 November 2002 2:59 AM
To: 'Gavin Amm'; 'Php-Db (E-mail)'
Subject: RE: [PHP-DB] foreach loop from MySQL select query to HTML
select l
thanks John,
i was thinking along similar lines.
that should work well.
cheers,
Gav
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Friday, 29 November 2002 4:08 PM
To: 'Gavin Amm'; 'Php-Db (E-mail)'
Subject: RE: [PHP-DB] foreach loop from M
Hi,
I'm using some form fields on a page to pick up existing data from a MySQL
database, make any changes, and update the database when i hit "submit".
I've picked up the data ok, now i want to process the update...
How do i call a function(?) on the same page rather than use another page
through
Hi,
I'd like your opinion as to whether you think this code is reasonable, or if
there is a better way to do this...
I'd like to insert data in a particular order, so that i would take this eg:
num val
1x
2y
3z
and insert "a" as number 2 (from 2 text boxes), s
Hi guys,
Would someone mind pointing me to a function, or some code, or give me a
seudo-code start for the following:
I'm using the mail() function.
If someone submits the form with text in the multi-line textarea, any
carrige returns (ie, by pressing ENTER) are taken out & the body is sent
as a
-Original Message-
From: Manuel Lemos [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 8 January 2003 11:32 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Breaking up new lines for e-mail
Hello,
On 01/07/2003 10:11 PM, Gavin Amm wrote:
> Would someone mind pointing me to a function, or some c
Hi All,
I'm about to start development on a members area for a site.
The members area will have 2 levels - Paid & Free, with the Paid members
having access to more pages.
I have not created a members area before & am after any advice or links
I can get... I think a lot of reading is in order...
ages. All links will be visible, but
links for paid members will be clearly indicated. The purpose of this is
to show freeloaders what they are missing!
I hope this is clear. More experienced members of this list may well
find flaws with my method.
Good luck,
Jeffrey Baumgartner
eBusiness
Chris,
Just a thought.
You could set up a linux system on an old pentium box & just use it as
your mail server, thus no need to change your code if it is hard coded,
just point to the new server.
Gav
-Original Message-
From: Chris Payne [mailto:[EMAIL PROTECTED]
Sent: Friday, 14 March
mmm, could you use a foreach loop?
I think you will need to send separate mail items for each e-mail
address you have stored in the database if you want to address it to
them personally.
Eg in seudo code:
foreach($row_returned_from_database){
# variables & headers etc here
# eg, $contactemail
I'm inexperienced with db's, but here are my thoughts:
Maybe add a TIMESTAMP(14) field in your temp table, then run a script
periodically to delete any rows stored that are more than, say, 20 mins
old?
Gav
-Original Message-
From: Dewi Wahyuni [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 3
Hi All,
I just can't for the life of me get the variable to output a value from
the array:
(all preceding script in place to make this work..)
The "start" date retrieved from the database is, for example, 20050412
(mmdd).
The example output for each variable (w/o quotes) is:
$monthInt output
sed on my previous e-mail, so all's
well.
Cheers,
Gavin
-Original Message-
From: David Robley [mailto:[EMAIL PROTECTED]
Sent: Friday, 1 April 2005 12:06 AM
To: [email protected]
Subject: RE: [PHP-DB] Re: Just can't get it to work.. variables
Gavin Amm wrote:
> Yeah, I
lto:[EMAIL PROTECTED]
Sent: Thursday, March 31, 2005 12:43 AM
To: [email protected]
Subject: Re: [PHP-DB] Re: Just can't get it to work.. variables
David Robley wrote:
> Gavin Amm wrote:
[snip]
> That would indicate that you are actually saying:
> $monthVal = $monthName[0
How do I limit the characters a Select statement returns?
In Seudo code:
SELECT * FROM myTable LIMITCHARS 30;
I'm using MySQL.
Thanks.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
The 1st page is a sumary page of a
number of the rows, so what I'm wanting to do is limit the display on
initial sumary page to say 100 chars per field and then if they click on
the row for more info I can then display the full info.
-Original Message-
Sent: Monday, January
46 matches
Mail list logo
