7 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi there,
I have a problem in my script,
I need to check whether file exists in remote server or not,
if the file exists, then stop copy
else copy the file to the server..
my code is something like this
while read $server
do
if ssh $server "cd $directory_name; if ; then echo "Error:... (2 Replies)
Discussion started by: beezy
2 Replies
2. Emergency UNIX and Linux Support
Hi,
I have two websites:
website1.com and website2.com
I didn't write either but have successfully moved all the files from website1.com to website2.com
I (thought) I installed all the correct php modules and website2 is mostly up and running. However, my boss found that when we go to a... (15 Replies)
Discussion started by: Astrocloud
15 Replies
3. Programming
Hello every one
i have question i want to build DATAbase using PHP as interface
i use shell to access to linux . i have in linux psql and SQLplus
i'll call all html files that has db tabels from shell directory.
what should to do before design php pages. can build the database sql design... (3 Replies)
Discussion started by: Scotch
3 Replies
4. AIX
Dear friends I am an AIX administrator but now I am taking DB2 trainings.. DB2 is interesteing but if I want to success well I have to givap administering AIX systems because to do both of them its really tiresome and needs lot of time.. So anybody please advice me if you were at my place what... (0 Replies)
Discussion started by: Vit0_Corleone
0 Replies
5. Solaris
Hello,
I need to install a Jboss AS 4.2 asap. But I dont want to use the GUI. I need to install a solaris 10 server with the minimal packages but I dont know how deep I should customize and select the packages.
You guys , how you decide to select a package installation level ? Each server's... (7 Replies)
Discussion started by: shadowfaxxxx
7 Replies
6. Shell Programming and Scripting
Dear friends,
:) I need your help again. This time I have written 2 scripts i.e. A.sh & B.sh and both of them takes “serial no” as input. Both the scripts are exactly same except one thing, both are pointing to different tables.
Now I want to write another script that will decide whether to... (4 Replies)
Discussion started by: anushree.a
4 Replies
7. UNIX for Dummies Questions & Answers
I've got an old laptop and i want to try unix on it, but i'm a unix newbie, so i don't know what i have to choose.
We're talking about a laptop with an intel 80C386SX-20 CPU in it, with 2 MB Ram and 40 MB harddisk. Not really powerfull specs.
Is it possible to install a unix version on it. Or... (8 Replies)
Discussion started by: rolfvandekrol
8 Replies
MYSQL_INSERT_ID(3) 1 MYSQL_INSERT_ID(3)
mysql_insert_id - Get the ID generated in the last query
SYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
omysqli_insert_id(3)
o PDO::lastInsertId
int mysql_insert_id ([resource $link_identifier = NULL])
DESCRIPTION
Retrieves the ID generated for an AUTO_INCREMENT column by the previous query (usually INSERT).
o $
link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is
assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
is found or established, an E_WARNING level error is generated.
The ID generated for an AUTO_INCREMENT column by the previous query on success, 0 if the previous query does not generate an AUTO_INCRE-
MENT value, or FALSE if no MySQL connection was established.
Example #1
mysql_insert_id(3) example
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db('mydb');
mysql_query("INSERT INTO mytable (product) values ('kossu')");
printf("Last inserted record has id %d
", mysql_insert_id());
?>
Caution
mysql_insert_id(3) will convert the return type of the native MySQL C API function mysql_insert_id() to a type of long (named int in
PHP). If your AUTO_INCREMENT column has a column type of BIGINT (64 bits) the conversion may result in an incorrect value. Instead,
use the internal MySQL SQL function LAST_INSERT_ID() in an SQL query. For more information about PHP's maximum integer values,
please see the integer documentation.
Note
Because mysql_insert_id(3) acts on the last performed query, be sure to call mysql_insert_id(3) immediately after the query that
generates the value.
Note
The value of the MySQL SQL function LAST_INSERT_ID() always contains the most recently generated AUTO_INCREMENT value, and is not
reset between queries.
mysql_query(3), mysql_info(3).
PHP Documentation Group MYSQL_INSERT_ID(3)