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
[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 seem to pick up the variable to use in my script
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
-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
-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
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
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 retrieve data from my database
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 have
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
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:
?PHP
$db = mysql_connect(myhost, username, );
-
From: John Coder [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 28 November 2002 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
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 name=deptsub_select
option-select-/option
?PHP
while($row = mysql_fetch_array($result_dept)){
echo option value=\{$row['dept']}\{$row['dept']}/option\n;
}
?
/select
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
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 MySQL select query
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), so
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 code
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...
. More experienced members of this list may well
find flaws with my method.
Good luck,
Jeffrey Baumgartner
eBusiness Consultant - ITP Europe
http://www.itp-europe.com
[EMAIL PROTECTED]
+32 2 721 51 00
-Original Message-
From: Gavin Amm [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, January 23
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'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 MySQL)
Hi All
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 point
Amm
Cc: PHP-mailist
Subject: Re: [PHP-DB] Pass database id through href
Gavin Amm wrote:
EXAMPLE:
(I know you can't use value with the a tag, but bear with me for
illustration purposes in this pseudo-code)
form name=theForm
input type=text name=title
!-- etc with the fields
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. p Enjoy your stay.
2 - Feedback - feedback, form, contact - Please enter any feedback
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
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 like to find
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
1
0
Home Page
6
1
My Page 2
9
6
My Page 3
15
9
My Page 4
21
6
My Page 5
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
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 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 outputs
-mail, so all's
well.
Cheers,
Gavin
-Original Message-
From: David Robley [mailto:[EMAIL PROTECTED]
Sent: Friday, 1 April 2005 12:06 AM
To: php-db@lists.php.net
Subject: RE: [PHP-DB] Re: Just can't get it to work.. variables
Gavin Amm wrote:
Yeah, I ended up doing that (associative
PROTECTED]
Sent: Thursday, March 31, 2005 12:43 AM
To: php-db@lists.php.net
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[04];
where the 04 is actually
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
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 30, 2006 12:51 PM
To: Gavin Amm; php-db@lists.php.net
43 matches
Mail list logo