PHP - Moved: Auto Increment Question

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.

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!

hey guys i have this invoice im working on but my clients  want's the invoice id start at a specific  number?   do it put that number in phpmyadmin direct on the line null?or can i do it another way?

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?

Why won't this increment the database field by 1?


$sql2="update 'users' set 'TimesLoggedOn' = 'TimesLoggedOn' + 1 where 'BarcodeID' = $barcode";

mysql_query($sql2);


Thanks!

This topic has been moved to JavaScript Help.

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

This topic has been moved to Ajax Help.

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

This topic has been moved to Ajax Help.

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

This topic has been moved to JavaScript Help.

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

I have read around and can't seem to find the right coding for what I need on this forum and some other other forums.

I have a contact form (as listed below) and I need 2 locations (Print Name and Title) fields to auto-populate on a separate form (can be a doc, pdf, etc. any form of document which is easiest) and this form can be totally back end and the individual using the form never is going to see the form.

It's going on a contract form, that we would like to auto-populate.

Also is there a simple attachment code so individuals can attach documents to the code?


<p style: align="center"><form action="mailtest.php" method="POST">
<?php
$ipi = getenv("REMOTE_ADDR");
$httprefi = getenv ("HTTP_REFERER");
$httpagenti = getenv ("HTTP_USER_AGENT");
?>

<input type="hidden" name="ip" value="<?php echo $ipi ?>" />
<input type="hidden" name="httpref" value="<?php echo $httprefi ?>" />
<input type="hidden" name="httpagent" value="<?php echo $httpagenti ?>" /> 
<div align="center">
<p class="style1">Name</p> 
<input type="text" name="name">
<p class="style1">Address</p> 
<input type="text" name="address">
<p class="style1">Email</p> 
<input type="text" name="email">
<p class="style1">Phone</p> 
<input type="text" name="phone">
<p class="style1">Debtor</p> 
<input type="text" name="debtor">
<p class="style1">Debtor Address</p> 
<input type="text" name="debtora">
<br />
<br />
<a href="authoforms.php" target="_blank" style="color:#ffcb00"  vlink="#ffcb00">Click here to view Assignment Agreement and Contract Agreement</a>

<p class="style1"><input type='checkbox' name='chk' value='I Have read and Agree to the terms.'> I have read and agree to the Assignment and Contract Agreement <br></p>
<p class="style1">Print Name</p> 
<input type="text" name="pname">
<p class="style1">Title</p> 
<input type="text" name="title">


<p class="style1">I hear by agree that the information I have provided is true, accurate and the information I am submitting is <br />
not fraudulent. Please click the agree button that you adhere to Commercial Recovery Authority Inc.'s terms:</p>
<select name="agree" size="1">
<option value="Agree">Agree</option>
<option value="Disagree">Disagree</option>
</select>
<br />
<br />
<p class="style1">Employee ID:</p> 
<input type="text" name="employee">

<br />

<input type="submit" value="Send"><input type="reset" value="Clear">
</div>
</form>
</p>


The mailtest php is this
?php
$ip = $_POST['ip'];
$httpref = $_POST['httpref'];
$httpagent = $_POST['httpagent'];
$name = $_POST['name'];
$address = $_POST['address'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$debtor = $_POST['debtor'];
$debtora = $_POST['debtora'];
$value = $_POST['chk'];
$pname = $_POST['pname'];
$title = $_POST['title'];
$agree = $_POST['agree'];
$employee = $_POST['employee'];
$formcontent=" From: $name \n Address: $address \n Email: $email \n Phone: $phone \n Debtor: $debtor \n Debtor's Address: $debtora \n 'Client' has read Assignment and Contract Agreement: $value \n Print Name: $pname \n Title: $title \n I hear by agree that the information I have provided is true, accurate and the information I am submitting is not fraudulent. Please click the agree button that you adhere to Commercial Recovery Authority Inc.'s terms: $agree \n \n  Employee ID: $employee \n IP: $ip";
$recipient = "mail@crapower.com";
$subject = "Online Authorization Form 33.3%";
$mailheader = "From: $email \r\n";
mail($recipient, $subject, $formcontent, $mailheader) or die("Error!");
echo "Thank You!" . " -" . "<a href='index.php' style='text-decoration:none;color:#ffcb00;'> Return Home</a>";
$ip = $_POST['visitoraddress']
?>

This topic has been moved to Miscellaneous.

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

This topic has been moved to JavaScript Help.

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

I believe it's called increment. Either way, I cannot figure out how to simply count up beginning at 1 (in red in the div below) ...

function wp_rss( $url, $num_items = -1 ) {
    if ( $rss = fetch_rss( $url ) ) {
        echo '<div id="charts">';

        if ( $num_items !== -1 ) {
            $rss->items = array_slice( $rss->items, 0, $num_items );
        }

        foreach ( (array) $rss->items as $item ) {
            printf(
                '<div id="chart_lt">1</div><div id="chart_rt">%3$s</div>',
                esc_url( $item['link'] ),
                esc_attr( strip_tags( $item['description'] ) ),
                htmlentities( $item['title'] )
            );
        }

        echo '</div>';
    } else {
        _e( 'An error has occurred, which probably means the feed is down. Try again later.' );
    }
}

Code: [Select]
$db->query('UPDATE users set actions=actions+1|'.time().' where id = '.$pun_user['id'].'');
im trying to do set actions=actions+1, then put a | atfter +1ing it, then add my time stamp to it so I can explode it later.

so it will look like this

2|unixtimestamphere


how would i achieve this? or do I need to make another seperate row? seems dumb