The manual is at http://www.php.net/manual/en
The function you need is mysql_insert_id.
On Mon, 18 Feb 2002, michele wrote:
> I have a table with a ID field 'auto_increment',
> when i insert a record in the table,
> how can i know the value of the ID inserted by the mySQL?
> Thank's,
> Mich
Jennifer: Did you ever get your If else Question answered?
On Mon, 25 Mar 2002, Jennifer Downey wrote:
> Hi all,
>
> I have a table called pets, here is a partial dump:
> At this time this is all I am working with.
>
>
> uid int(10) NOT NULL default '0',
> num_pet tinyint(1) NOT NULL default
Does FoxPro have an ODBC module?
I'm in the midst of putting a web front-end on an Access database; we've
put MySQL as the back end to Access using the ODBC connection. Then PHP
can process queries on the MySQL db and the local operators see it as an
Access db.
We first tried PostgreSQL because
Well, it's (intended to be) difficult. Perhaps you can NULL it out and
have them put in a new password...
On Wed, 19 Dec 2001, Zach Curtis wrote:
> I have a form for a user to request their forgotten username and password by
> entering their email address. I then process this and use mail() to
No. Rather, it's "computationally infeasible".
On Wed, 19 Dec 2001, Zach Curtis wrote:
> Fortunately, this application is still in testing, therefore the users and
> passwords in the db are meaningless. However, I thought storing encrypted
> passwords in a db was a good idea, that is if can ret
Here's another approach: use MySQL's encipher/decipher function and have
a super-secret password to encrypt/decrypt.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrato
Yet another example of ted's out-to-lunchness...
Use the mcrypt functions on the password...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTE
Did you convert the dates to PHP's "Julian" format before subtracting?
On Wed, 2 Jan 2002, Faye Keesic wrote:
> I have a db site that always displays the most recent occurrence of news
> stories
>
> The last occurrence of stories was last year (2001-12-31) and up to the new
> year rolling ov
Ah... the "$datetoget = ($datetoget-1)" is the problem.
Convert the Gregorian Ymd date to Julian, subtract 1, then convert the
Julian date back to Gregorian (or Hebrew ;->). I've not had much success
with MySQL's date functions.
On Wed, 2 Jan 2002, Faye Keesic wrote:
> I had no problems with r
Sorry for the delay... include --enable-calendar in the php compilation.
On Wed, 2 Jan 2002, Faye Keesic wrote:
> Okay, when I try to change the gregorian date to julian, I get
> error: call to undefined function: gregoriantojd() in line...
>
> Here's the code I used to replace $datetoget=($date
egrep_split? But then, there's the learning curve for grep...
On Fri, 4 Jan 2002, Leotta, Natalie (NCI/IMS) wrote:
> There are a few ways to split up text based on a delimiter. I recommend you
> look at split and explode on the PHP.net site and see what seems to be best
> for your situation.
I just saw this which is new on Hotscripts
PhpMyLibrary
http://www.hotscripts.com/Detailed/13279.html
On Thursday 10 January 2002 15:26, Daniel Barton wrote:
> Hi all,
> I've noted that a least a couple of people on this list work with
> library catalog systems - I'm interested in finding ou
Yes. PostgreSQL.
On Sun, 13 Jan 2002, Boaz Yahav wrote:
> It's not just that...
> For example, when I want to backup the MySQL server (and we are talking
> of a few GB of data) the server is practically dead while making the
> dump. MSSQL Server 2000 (for example) does that in the background an
Is it the ole 30-second timeout thang? Changeable in php.ini?
On Mon, 14 Jan 2002, Faye Keesic wrote:
> Hi there...
>
> I have a problem mailing out approx. 180 emails (no attachments) using the
> mail() php function. I loop through the email table once, sending the email
> to everyone in the
Hi, Faye. There's a parm in the configuration file (php.ini) cleverly
called "max_execution_time". Its default setting is 30. There's also a
"set_time_limit()" function that allows massaging this variable.
Does this help?
On Mon, 14 Jan 2002, Faye Keesic wrote:
> Don't know anything about ol
Ahhh my favorite subject. Privacy.
There are two PHP functions that do _exactly_ what you're looking for.
Mcrypt_encrypt and mcrypt_decrypt. If you're looking for just enough
encryption to keep the curious out, use a single password for all
encryption. If you want military-grade encryption
Can I see line 13? Or better yet, the script? If you have the .phps source
code option enabled I can view it that way -- I think.
-Original Message-
From: Marc S. Bragg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 12:39
To: [EMAIL PROTECTED]
Subject: [PHP-DB] syntax trouble
Is DATE CCYY-MM-DD?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Mysql isn't up?
On Sun, 1 Apr 2001, Szeto wrote:
> Hello
>
> The code below i use in testing the connection (written in php4)
>if(!mysql_connect("localhost","khaimun","akyweb")) {
> print "could not connect to mysql!";
> }
> mysql_select_db("focalmail");
> ?>
>
> -
Excellent diagnosis, sir! However, it is woefully and pitifully short on
curative information.
On Sun, 1 Apr 2001, Felix Kronlage wrote:
> On Sun, Apr 01, 2001 at 06:50:24PM +0800, Szeto wrote:
>
> > I am new to Linux environment
>
> so what. You could still read the error-message:
>
You've gotten some good general instructions here! The design of the
database depends on its intended use -- with more information about the
application, we could give your more specific assistance on the db design.
What's it going to be used for?
How will it be accessed? By motherboard serial
MySQL is an excellent choice for that type of database.
On Sun, 22 Apr 2001, Nagasea wrote:
> Is MySQL good for database (excel format csv) more than 4 megabyte ?
> Is the query process become slower ?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED
check out http://www.php.net/manual/en/function.mktime.php
If you still need assistance, I'm here.
On Sun, 24 Jun 2001, Matthew Cothier wrote:
> I really need help here. What I am trying to do is the following.
>
> -
>
> $today = date("m.d.y");
> $time = date("g:i a");
>
> if($row[3]
You have to compile it in...
... AND bring up the MySQL server...
On Mon, 25 Jun 2001, Adam Lundrigan wrote:
> Is MySQL included in the 406kb version of PHP 4.0.6?
> When I try to connect to MySQL (after adding localhost & paswords to php.ini) using
>this version it says:
> Warning: Can't conne
> It's public info, so free, and
Hah! Try to get the 9-digit ZIP code stuff. Developed with tax dollars
and sold by (I believe) a private corporation.
Isn't it great that we're not getting all of the government we're paying
for?
--
PHP Database Mailing List (http://www.php.net/)
To unsubsc
I'm gathering data on open-source databases... is there a program that can
provide comparisons between databases, such as MySQL and PostgreSQL?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To cont
print_r? Am I about to learn something new? Be still, my beating heart!
On Tue, 21 Aug 2001, speedboy wrote:
> > $conn = pg_connect ("host=localhost user=username password=password
> > bname=dbname");
> >
> > $sql = "SELECT * FROM database where lower('$name%') order by last;";
> >
> $result =
Does anyone know of a program that can generate a good Content Management
System? For example, it would ask which fields to add to a database table,
the types of the fields, etc and create the database in MySQL and php's to
manage the data. I did find a few such programs already (AppGini,
PHPRunn
isplays without showing any MySQL config data.
Any help? I'm just stuck! My directive for MySQL inclusion for the PHP
./configure command was:
--with-mysql=shared,$BLIB/mysql
...where $BLIB was set to /opt/apache-php/libs
Thanks,
Ted
ike 'apples' and see if that
works. Increase the password complexity from there...
Ted
On 3/2/07, Roberto F Tavares Neto <[EMAIL PROTECTED]> wrote:
Hello,
I'm trying to do a very simple thing: create a database and a user to
use it.
So, initially, I use the web interface
x27;
identified by 'mypassword';
Ted
On 3/2/07, Roberto F Tavares Neto <[EMAIL PROTECTED]> wrote:
Ted,
I try the classic "abc" and had the same problem...
Roberto
Ted Fines escreveu:
> Hi,
>
> So it works from PHP w/o a password, but with a password does not?
>
31 matches
Mail list logo
