PHP - Auto Increment Start From A Specific Number?

Is there a way to copy an auto-increment value (`id`) into another field in the same table (`org_id`)?

So, when someone creates a new organization, it will copy the new auto-increment value into the org_id field. Is this possible?

Thanks!

is there a way to save a field in a session or variable while its being inserted into the data base?
with out having to select it using another query

$mail2 = "INSERT INTO pm SET pm_id = '', (turn pm_id into a $variable or session) WHERE blah blah blah

the problem im having is Im creating two rows right after each other where each row is in differant tables and I need them to match ids and I have nothing to compare it to.

only option i can think of is making a fast toggle switch or telling my select to grab in order which would work.

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=321437.0

Hi everyone,   I have an application that makes use of a transaction, inserting and updating values in different tables. One of the first tables it inserts into has an auto increment ID field. This ID values is used / updated in some other tables. Everything works fine. If however the transaction fails then the auto_increment values are upset - meaning that the sequence is jumped.   For ex. if I had auto_increment values from 1 to 6 in this table and then the insert query fails for an auto_increment value of ID=7, then this value of ID = 7 is lost because the next time the query is run the auto_increment ID value will be equal to 8 and accordingly updated in the tables. ID value = 7 is lost. Is there any way to prevent this ? Please know that this is a multi - user application.   Thanks.          

I've been trying to grab the unique auto incrementing table id and put into a session variable.


$name_id = mysql_insert_id();

$query = sprintf("INSERT INTO profile (
 name_id, bio, ex)
VALUES (LAST_INSERT_ID(),'%s','%s')",
mysql_real_escape_string($_SESSION['pro']['bio']),
mysql_real_escape_string($_SESSION['pro']['ex']));

$result = mysql_query($query, $db) or die(mysql_error($db));
$name_id = mysql_insert_id();

$_SESSION['name_id'] = $name_id; //this is the key line
                $_SESSION['logged'] = 1;
header('Refresh: 5; URL=main.php');


I've echoed out the result of $_SESSION['name_id'] and it says '0'.

I've tried changing the key line to

$_SESSION['name_id'] = LAST_INSERT_ID();


but I get this error message: Fatal error: Call to undefined function LAST_INSERT_ID() in C:\x\xa

Is my goal acheivavle or should I just set up a select query after the insert query and extract the id key?

i need to start up the herirtrix tools by type bash heritrix.sh in open terminal. how to execute this command without opening the open terminal. i want to make a button in webpage that can execute this function. so that everytime i want to start up heritrix, i just click the run button and no need to open the terminal.. thank you..

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=334480.0

Hey...

I'm trying to echo the title of the news in the right column but I just want to display maximum of 25 characters how can I do it?

thanks

Hello, i retrieve an array from the database that looks something like this:

$var=a:1:{s:2:"cc";a:1:{i:22;s:11:"TESTING";}};

I need to retrieve the number corresponding to the character i: and print it(11 in the first case). 
For example ,
If,
$var=a:1:{s:2:"cc";a:1:{i:15;s:11:"TESTING";}};
I would need to print 15.
$var=a:1:{s:2:"cc";a:1:{i:3;s:11:"TESTING";}};
I would need to print 3.

Thanks in advance.

I'm pretty sure this is really simple to do using the count function, but I am having a hard time finding examples on how to count the number of times a "SPECIFIC" word occurs in a file. For example, I just want to display how many times "this-word" occurs in "http://www.mysite.com/logfile.log". Any help would be appreciated.

Hi there,

I'm writing an application that pulls from two separate web based APIs, collates the data into a single array of data.  Once done, it then enters a loop that cycles through the array and executes a cURL call for each cycle.  This worked perfectly for a controlled set of 10 artificial records and so I've started testing with live data.

On running the code, I eventually the following :
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

I'm not sure how to debug this and so I'm hoping I can find some help here.
I'm running WAMP, and the php.ini contains the following:
max_execution_time = 0   ; Maximum execution time of each script, in seconds
max_input_time = 0   ; Maximum amount of time each script may spend parsing request data

Through testing, I have discovered the following :
The script can do exactly 35 iterations through the loop in under 2 minutes.
Any number greater than this causes the error.
If I skip the first 20 curl submits, I can then do 21 to 55 iterations before failure, so I do not believe it is the 36th value.
If I put a sleep(5) command into the loop, I can still do 35 and no more iterations than that.
If I put a sleep(10) command into the loop, it fails on 35 and needs less.

Code: [Select]
$action = "post";
$url = "http://url.url.url/api/v1.0/udo_Position/create"; // I've replaced the actual URL out of necessity

// set user agent {
print("Setting CURL options, using URL ".$url."<br>");
$cd = curl_init();
curl_setopt($cd, CURLOPT_HEADER, 1);
curl_setopt($cd, CURLOPT_URL, $url);
curl_setopt($cd, CURLOPT_USERPWD, 'username:password');
curl_setopt($cd, CURLOPT_RETURNTRANSFER, 1); // Don't send return value to screen
curl_setopt($cd, CURLOPT_USERAGENT, "Firefox/2.0.0.1"); // spoofing FireFox 2.0
curl_setopt($cd, CURLOPT_VERBOSE, true);
// }

if ($action == 'get') {
;
} elseif ($action == 'post') {
print("POST set;<br>");
print("<pre style='font-family:verdana;font-size:13'>");
print_r($pointval);
print("</pre>");
$pointval["save"] = "Save"; // The AddNew step form requires this.

curl_setopt($cd, CURLOPT_POSTFIELDS, $pointval);
} else {
print("Invalid usage. Please see example<br>");
return;
}

$reply = curl_exec($cd);

$http_status = curl_getinfo($cd, CURLINFO_HTTP_CODE);
print("<pre style='font-family:verdana;font-size:13'>");
print_r($http_status);
print("</pre>");

print("Here is the reply from the AddNew function: <br>");
print("<pre style='font-family:verdana;font-size:13'>");
print_r($reply);
print("</pre>");

if (curl_error($cd)) {
print("Error: ".(curl_error($cd))."<br>");
}

curl_close($cd);
print("Insert Successful.<br>");

I am uncertain whether it is a PHP, Apache or cURL issue at this point.  I have another script that pushes a great deal more cURL calls to the same system but pulls from only one external resource, instead of two.  Any help or suggestions would be appreciated.

<ul> <!-- List the rest of the articles found in the category -->
<?php else : ?> 
<li class="otherrecentmain"><span class="title"><a href="<?php the_permalink() ?>" title="<?php the_title(); ?>"><?php the_title(); ?></a></span> <span class="meta"></span>
</li>
<?php endif; ?>
<?php endwhile; ?> <!-- END -->
</ul>


For some reason, its stuck on displaying 9 articles but I want to be able to control how many I want. I may want to choose 17 or whatever etc, not sure how to add it into the php.

Hi..

I started designing stock form.

and I need to display automatically the stock number, the format is:yymmddxxx for example : 120323001

I need to display that stock number in my textbox when I first visit in my form...

Thank you so much...

I have a row in a MySQL table called id, which auto-increments.

I was wondering if anyone knows a PHP solution to find out what the highest number in the row is?

I am thinking perhaps execute a MySQL query that will list the highest number, and then echo the result, like $row[id] in PHP?