On Friday 26 October 2001 05:29 am, Harpreet wrote:
> I do have root access and run the Grant command in Telnet.
>
> But what i want to do is have a web page called add_user.php. When
> the administartor adds a username and password i want that user to be
> granted all rights. I eman can i run th
// Question 1:
// How to process the confirmation email by clicking the url
// given in the email
// and by replying the email.
when you send them an email, include some sort of confirmation code
ie http://server/confirm.php?confirmCode=xxx
when they click, it passes this code, and you look it
I need some help about example scripts on:
Question 1:
How to process the confirmation email by clicking the url given in the email
and by replying the email.
Question 2:
I know if using mail(), the "From" field of the mail sent out is always the
web host server's mail sendout server,
not from my
if you have phpMyAdmin then just use that (if you don't then you *really*
should :)
otherwise, yeah just use mysql_query()
or use the command line
of course the second 2 options assume you can construct the SQL command to
do it, using phpMyAdmin you won't really need to know.
/beau
// -Or
hello,
can one of you clever people guys 30 seconds to help a lady...?
can someone just tell me the best way to create a new table in a mysql
database?
should i use the mysql_query() function?
thank you boys,
xxx
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [E
Hello,
After many weeks of development, and despite the lack of free time
mostly due to the birth of my son, it was released a new version of
Metabase - the PHP abstraction to develop database independent
applications.
The main new feature is the full support to the creation and access to
table
Hello,
M0sh3 wrote:
>
> Hi, i'm trying to import tables containing TEXT fields from MSSQL 2K, so far
> tried different ways, one of them DTS, but unsuccessfully.
>
> It gives error: "Query-based insertion or updating of BLOB values is not
> supported."
Try Metabase that fully supports BLOBs in
I do have root access and run the Grant command in Telnet.
But what i want to do is have a web page called add_user.php. When the
administartor adds a username and password i want that user to be granted
all rights. I eman can i run the Grant statement in my php page and not on
Telnet.
Regards,
go grab yourself a copy of
phpmyadmin
http://phpmyadmin.sourceforge.net/download.html
jim
- Original Message -
From: "Harpreet" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 25, 2001 2:02 PM
Subject: [PHP-DB] New users on mysql using php
> I connect to mysql data
Do you have root access to mysql? If so, then you can GRANT privileges to
create new users.
Otherwise, you have only the GRANT privileges delegated to you by the MySQL
admin.
-Original Message-
From: Harpreet [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 4:03 PM
To: [EMAIL
I connect to mysql database using the following:
$StrConnectionUser=mysql_connect(ipaddress,"$USER");
mysql_select_db(database name, $StrConnectionUser);
My question is how can I add new users to mysql using the web interface.
Like can i run the Grant and revoke (mysql commands) in my php page?
Show your code and table set-up. That would help.
-Original Message-
From: Dave Pollak [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 1:37 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] import error into mySQL
Howdy,
New to databases, mySQL, and PHP. In my first PHP/mySQL ap
Howdy,
New to databases, mySQL, and PHP. In my first PHP/mySQL application I'm
loading data from a flat file exported from a Paradox database. Dates in one
field import as -00-00 though they import properly in other fields. They
appear to be configured alike - dob DATE & date_reg DATE - and t
I would suggest perhaps a different way (slightly larger use of disk space, but only
one script and
only one query, although a moderately complex query):
1) Subscriber's emails are stored in table 'A' with their associated category as a
data field.
2) A unix_timestamp field is added to table 'A
> From: Chris Newbill [mailto:[EMAIL PROTECTED]]
> >snip... (been doing VBScript on ASP for several years, tho).
>
> I feel sorry for you. :)
;) Never fear. It works, does what it needs to do (so long as it's properly patched ;)
and
I make a fist-full of money for moon-lighting. Can't complain
-Original Message-
From: Tim Foster [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 8:19 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...
>snip... (been doing VBScript on ASP for several years,
>tho).
I feel sorry for you.
Look for extensions in the file php.ini. uncomment the line:
extension=php_dbase.so (for linux or)
extension=php_dbase.dll (for windows)
remember to set extension_dir to directory where you have the file.
Hope it helps.
Bruno Gimenes Pereti.
> I need to open a dbase file, so I use the "dbase
You only need to post your question once, and you really shouldn't
cross-post to multiple lists...please, I just got six copies of your
question.
Did you compile php with the --enable-dbase configure flag? You can
check with phpinfo() for what's enabled and also what configuration
flags were
I need to open a dbase file, so I use the "dbase_open" function and then I
compile it but it tells me
Fatal error: Call to undefined function: dbase_open()
it seems like this function does not exists!.Does anybody could help me?
Thanks
[EMAIL PROTECTED]
I need to open a dbase file, so I use the "dbase_open" function and then I
compile it but it tells me
Fatal error: Call to undefined function: dbase_open()
it seems like this function does not exists!.Does anybody could help me?
Thanks
[EMAIL PROTECTED]
I need to open a dbase file, so I use the "dbase_open" function and then I
compile it but it tells me
Fatal error: Call to undefined function: dbase_open()
it seems like this function does not exists!.Does anybody could help me?
Thanks
---
RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...Agreed.
Personally, I refuse to keep date values in fields that are not DATE fields
of some kind. Too much trouble.
TIM
-How do "Do Not Walk On Grass" signs get there?
-Original Message-
From: Robinson, Mike [mailto:[EMAIL PROTECTED]
Try to avoid system commands whenever you can and instead use PHP functions
when they're available. In this case, you can use the following function
mkdir:
http://www.php.net/manual/en/function.mkdir.php
What is the problem you're having with that system command? The most
frequent problems stem f
Title: RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...
http://mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_types
Mysql permits all manner of formats for date/time storage,
and a whole slew of functions for retrieving date/time
info in useful, meaningful way
Oop. I guess I missed the point of that question. Still, the MySQL
manual says a DATE takes 3 bytes, DATETIME 8 bytes, and TIMESTAMP 4
bytes. That seems fairly efficient. Using an INT for a date might
actually take up more space.
-Steve
On Thursday, October 25, 2001, at 09:34 AM, Steve Cayfo
Yep, MySQL has DATE, DATETIME, and TIMESTAMP field types. You can order
by them and everything.
-Steve
On Thursday, October 25, 2001, at 09:18 AM, Tim Foster wrote:
> I'm new to this list, to PHP and to MySQL (been doing VBScript on ASP
> for several years,
> tho).
>
> I'm curious...
>
> If
I'm new to this list, to PHP and to MySQL (been doing VBScript on ASP for several
years,
tho).
I'm curious...
If you're going to store it as an integer, why not store "10/24/2001" as MMDD
(20011024). This gives you the added benefit of being able to have the db sort your
fields. This even w
On Thursday 25 October 2001 15:08, Rick Emery wrote:
> First, I wouldn't use length(), I'd use REGEXP: SELECT * FROM
> foo_table WHERE fieldname REGEXP '..+'
> It's quicker.
regular expression is faster then a length() call? that's seems
strange considering how complex a regexp can be
with reg
Hi there folks, this problem is sincerely 'doing my head in'!
I want to know if there is a simpler method of achieving my aims set out below:
Script aim:
* To alert users subscribed to category's when new files are added to that category.
* A category has the same name as each directory in my pr
Try:
UPDATE mytable SET myfield=CONCAT(
LEFT(myfield,LENGTH(myfield)-1),'new_string') WHERE some_condition
If you know the field will ALWAYS be the same length (for instance 5, and
you wish to replace the 5th character):
UPDATE mytable SET myfield=CONCAT(LEFT(myfield,4),'new_char') WHERE
some_con
Hi all!
I must not be seeing something here.
I have a form where some of the fields are optional and some are required,
however when you click submit, the form will only continue to the next page
if ALL fields are completed, but the data is entered into the database just
fine in all instances.
I'd like to do it in mySQL, I think it will be done much quicker since
it a large database. The type of the field is allready varchar.
Niklas
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: 25. lokakuuta 2001 16:08
To: Php-DB
Subject: RE: [PHP-DB] mySQL Query and
First, I wouldn't use length(), I'd use REGEXP: SELECT * FROM foo_table
WHERE fieldname REGEXP '..+'
It's quicker.
As far as the second question, do you wish to do it in PHP or MySQL? Does
the value in MySQL require other computations (so, it must remain numeric)
or can it be a CHAR string?
-
>I have field with value '9876' and if I do "...field=field+'5'..." the
>value turns into '9881' not '98765' as I expected.
make your field type "var char"
- Original Message -
From: "Niklas Lampén" <[EMAIL PROTECTED]>
To: "Php-DB" <[EMAIL PROTECTED]>
Sent: Thursday, October 25, 2001 3:0
Thanks a lot! I quite didn't know what to look for in the manual.
I actually have another question:
If I want to update several fields, add a number to the end of the
fields value, how do I do that?
I have field with value '9876' and if I do "...field=field+'5'..." the
value turns into '9881' not
Change that to:
SELECT * FROM foo_table WHERE length(bar_field)>1;
-Original Message-
From: Tamas Arpad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 8:01 AM
To: Niklas Lampén; Php-DB
Subject: Re: [PHP-DB] mySQL Query and blank fields
On Thursday 25 October 2001 13:16, Nik
On Thursday 25 October 2001 13:16, Niklas Lampén wrote:
> How can I query for specified fields that has to contain atleast 2
> charters?
SELECT * FROM foo_table WHERE length(bar_field)>=1;
Arpi
>
> Example:
> Field AAA contains '' (NULL) => No match
> Field BBB contains ' ' (one charter)
Does your web-host permit you to execute system commands? For system
security, most will not.
-Original Message-
From: Ric Manalac [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 5:46 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] executing system commands
hi,
i'm a newbiew p
REGEXP '..+'
-Original Message-
From: Niklas Lampén [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 6:17 AM
To: Php-DB
Subject: [PHP-DB] mySQL Query and blank fields
How can I query for specified fields that has to contain atleast 2
charters?
Example:
Field AAA contains '
Hi,
Yesterday I posted a question about PHP and Paradox. I'd apreciate any
comment, sugestion, link... anything. I'm a linux user trying to hadle with
a W2k and ODBC. I found nothing related to this problem in the net. Here is
the error message:
Warning: SQL error: [Microsoft][Driver ODBC para P
Assuming you're using MySQL - 35 seconds is all it took to find:
http://www.mysql.com/doc/P/a/Pattern_matching.html
Good luck!
Russ.
On Thu, 25 Oct 2001 14:16:40 +0300 =?iso-8859-1?Q?Niklas_Lamp=E9n?=
<[EMAIL PROTECTED]>
wrote:
> How can I query for specified fields that has to contain atlea
How can I query for specified fields that has to contain atleast 2
charters?
Example:
Field AAA contains '' (NULL) => No match
Field BBB contains ' ' (one charter) => No match
Field CCC contains 'ab' => Match
Field DDD contains 'abcdefg' => Match
Niklas
Hi,
Is there a way of specifying via PHP's PostgreSQL functions whether the
output is in HTML or not?
I.e. the same as saying '\H' when using psql?
Obviously I could write this functionality using a PHP function but since
it's build into Postgres just wondered if anyone knew how to do it?
Than
hi,
i'm a newbiew php developer. i'm trying to
execute a system command in one of my
php scripts. what i would like to do is to
create a directory. my code goes like this:
// chunk of code starts here
$directory = generate_sessionid();
$command = "mkdir /home/httpd/html/miroku/downloads/$directo
44 matches
Mail list logo
