PHP - Auto Increment Values

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!

This topic has been moved to MySQL Help.

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

This topic has been moved to MySQL Help.

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

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?

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?

hi, i’m currently facing a new problem (i managed to use array_unique function successfully but i face this problem)with my php loop. i couldn’t seem to increment in my foreach loop to get the value of an array.
here is my code:

$update_id1=Array ( [0] => 398 [1] => 397 [2] => 393 [3] => 391 [8] => );

//$i=0;
foreach ($update_id1 as $i => $v) {

     $ex= explode(",", $v);
     $unique=array_unique($ex);

//f$ketch username from update table in db and inject it to the feed query.
   $imp_id= implode(',', $ids);
//$id1=$ids[$i];
  // $x=0;
 // for($x=0;$x<count(unique);$x++){ 
   echo 'ids:- '.$i; print_r($unique[$i]); echo '<br>';
   
//}
   

            
$totalUpdates=$project->totalUpdates($ids[$i],$_SESSION['uname'] ,$unique[$i],$load);   

 //$i++;
 }

i tried every method nothing seems to work can anyone help me in this regard please.

Edited December 25, 2019 by narutofan

Hello, I am a newbie PHP hobbyist. I mess with php strictly for my own amusement. Up until now I have been able to Google my way to a answer to my questions but I'm lost on this one. I'm not really sure what to even search for.

I have a few different mysql queries that returns the following arrays.

qid15=37,37,37,37,37,37,37,37,37,37,37,38,38,39,39,41
qid17=47,47,47,47,47,48,49,49,49,50,50,50,51,51
qid18=52,52,52,52,52,52,52,52,54,54,55,55,55,56,56,56
qid19=57,57,57,57,58,59,59,61,61

What I would like to do is replace or create a new array for each result with the lowest value as 1 the next lowest as 2 then 3 and 4.
My new array would look something like this
  oldqid15=37,37,37,37,37,37,38,38,39,39,41
newqid15=1,1,1,1,1,1,2,2,3,3,4

I sure would appreciate any ideas on this. I'm thinking there is probably a simple solution and before I waste anymore time I'll stop and ask for directions(as my wife would suggest).

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

So a project I have simply to learn how it is done is to make an auto updating sitemap with a auto submitter. I have been doing a little research on sitemaps but haven't found much in the way of a tutorial or white paper or similar, anyway I was wondering if I am on the right track or not.

What I was thinking for the auto-updating sitemap is since site maps are XML, when an article is published using my custom CMS/Blogging system, I make it rewrite the sitemap appending the new URL that will be generated.

Then for the auto-submit, I can either make it a cron job or just manual press, but it would go though a for list of URLs, replacing the end part with my site map url. I think that is how it would be done.

If you have a better idea, or can point out an article so I can understand a lot more with sitemaps, I will appreciate it, I am trying to learn as much as possible, I have gone to the offical website (sitemaps.org) but it doesn't have what I am looking for.

Thanks,

James

//php code
<?php
include_once('con.php');
if(!empty($_GET['search'])) {
$search = $connect->prepare('SELECT * FROM posts WHERE title LIKE :search');
$search->bindValue(':search', '%'.$_GET['search'].'%', PDO::PARAM_STR);
$search->execute();
?>
<?php
while($row = $search->fetch()) {?>
<li class="result" onClick="searchValue('<?php echo $row['title'];?>')"><?php echo $row['title'];?></li>    
<?php } ?>
<?php } ?>

//ajax

$('#inputsch').keyup(function(){
	$.ajax({
	type: 'GET',
	url: 'fetch.php',
	data:'search='+$(this).val(),
	success: function(data){
		$('#box').show();
		$('#box').html(data);
	}
	});
}); 
});
function searchValue(val) {
$('#inputsch').val(val);
$('#box').hide();
}


//search box

 <form action="search.php">
 <input id="inputsch" type="text" name="search" placeholder="search..." autocomplete="off" autofocus>
 <button type="submit" value="search" >search</button> 
 </form>
 <div id="box"></div>


//the problem here is when i click the result is only added to input, but i want it to autosubmit

 

I have a textfile called 'houses.txt':

HA11QS, 200, house1.jpg, 4
HA22BR, 280, house2.jpg, 10
HA33AB, 390, house3.jpg, 3
HA44CD, 320, house4.jpg, 8

I have a php file which puts all this into an array and using a form, when the user enters a value e.g. 300 it, displays all the houses equal to or less than that. This works fine

<?php

if (isset($_POST['price']))
{

$filename = "houses.txt";

$fileOpen = fopen($filename, "r");

$max = $_POST['price'];

$rowsArr  = file ($filename);

foreach ($rowsArr as $row)

{

$lineDetails = $row;

$item_array = explode (",", $row);

if (((int) $item_array[1]) <= $max)

{

echo("<form action='visit.php' method='post'>");

echo("Post Code - " . $item_array[0]. "<br>");

echo("Price - " . $item_array[1]. ",000 <br>");

echo("Picture - " . $item_array[2]. "<br>");

echo("Number of Visits - " . $item_array[3]. "<br>");

echo("<input type='checkbox' name='mybox'>");

echo("<input type='submit' value='Visit Property'>");

echo("</form>");

}

}

fclose($fileOpen);
}
?>

However what i need to do is using a form, (Form values which i have just recently added to the code supplied above)
Is that when a user clicks on property, it returns the house or houses selected with the checkboxes and the number of houses visits are incremented by 1 each time

All i have is:
<?php

if (isset($_POST['mybox']))
{

$filename = "houses.txt";

$fileOpen = fopen($filename, "r+");

$rowsArr  = file ($filename);

foreach ($rowsArr as $row)

{

$lineDetails = $row;

$item_array = explode (",", $row);

$house_visit = $item_array[3];

$house_visit++;

echo("Post Code - " . $item_array[0]. "<br>");

echo("Price - " . $item_array[1]. ",000 <br>");

echo("Picture - " . $item_array[2]. "<br>");

echo("Number of Visits - " . $item_array[3]. "<br>");

echo("<br>");

}

fclose($fileOpen);

}


?>

But it really doesnt work, if anyone can help me i would be grateful

Thanks

I have tables in my MySQL database called "games", "wins" and "losses". I'm attempting to write SQL queries that will increment or decrement a value depending on what link is clicked from the main page. My SQL queries are as follows:


<?php require_once('config.php');
if ( !isset($_SESSION['user']) ) { include('login.php'); exit; }
$sql = 'select * from `teams` WHERE `id` = \'' . mysql_real_escape_string($_GET['team']) . '\'';
$res = mysql_query($sql);
//if ( mysql_num_rows($res) == 0 ) { include('index.php'); exit; }
$row_team = mysql_fetch_array($res);
if ( isset($_GET['addgame']) ) { 
$sql = 'UPDATE `teams` SET `games` = `games` + 1 WHERE `id` = \'' . mysql_real_escape_string($_GET['team']) . '\'';
mysql_query($sql);
}
if ( isset($_GET['subtractgame']) ) { 
$sql = 'UPDATE `teams` SET `games` = `games` - 1 WHERE `id` = \'' . mysql_real_escape_string($_GET['team']) . '\'';
mysql_query($sql);
}
if ( isset($_GET['addwin']) ) { 
$sql = 'UPDATE `teams` SET `wins` = `wins` + 1 WHERE `id` = \'' . mysql_real_escape_string($_GET['team']) . '\'';
mysql_query($sql);
}
if ( isset($_GET['subtractwin']) ) { 
$sql = 'UPDATE `teams` SET `wins` = `wins` - 1 WHERE `id` = \'' . mysql_real_escape_string($_GET['team']) . '\'';
mysql_query($sql);
}
if ( isset($_GET['addloss']) ) { 
$sql = 'UPDATE `teams` SET `losses` = `losses` + 1 WHERE `id` = \'' . mysql_real_escape_string($_GET['team']) . '\'';
mysql_query($sql);
}
if ( isset($_GET['subtractloss']) ) { 
$sql = 'UPDATE `teams` SET `losses` = `losses` - 1 WHERE `id` = \'' . mysql_real_escape_string($_GET['team']) . '\'';
mysql_query($sql);
}
$sql = 'select * from `teams` WHERE `id` = \'' . mysql_real_escape_string($_GET['team']) . '\'';
$res = mysql_query($sql);
$row_team = mysql_fetch_array($res);
?>


For some reason, I can increment the amount of games, wins or losses as many times as I want.. it'll be updated in the database and the changes will be reflected on the page. However, when I go to subtract a game, win or loss, it seems to leave null values as if there are no games, wins or losses at all.

For example, say the site outputs the Yankees have 10 wins and 2 losses. When "[Add Win]" is clicked, the win total will increase to 11 and such changes will be displayed on the site. But, when "[Deduct Win]" is clicked, it seems to cancel out every value for the number of games, wins and losses and just outputs nothing..

Is there a reason for this? My addition is working fine, it's the subtraction that's messed up.. but it should work based on what I see.

Thanks.

I'm wanting to increment usernames in ONLY the lowercase a-z for example if a user enters "abc" it will automatically be given "abc1" and the next user if entering the same username will automatically be given "abc2", the next "abc3" and so on. The base login and register script I'm using can be found on http://evolt.org/node/60265/   The database.php and register.php pages are below, but excluding the amendments I am seeking.   I have created a MySQL database with 2 tables, 1 table named 'Users' with 3 columns named (1) 'userid' primary key, auto increment, (2) 'username' (3) 'password'.   The other table is named 'UserCount' with 2 columns named (1) 'username' (2) 'count'.

Can someone provide the PHP coding for the following process?   When a new user registers a new username firstly PHP to check the characters are in lowercase a-z only and no other characters, and reject if they do not match, then for PHP to check to see if that username exists in the 'UserCount' table.   If it doesn't exist, PHP to insert the new username into the 'username' column and also set the value of the 'count' column to 1.   If the username does exist, PHP to add that username to the 'username' column and increment the value of the 'count' column by 1. Then in the 'Users' table PHP to insert a record with 'Users.username = UserCount.username + count' and PHP to inform the new user of their complete username including the integer that has been added to their first entered username.

It would also help if I could be provided a link to a website on where I can better understand how to collate coding of this kind, coz I have tried to formulate this coding but as I'm playing around in the dark I have no idea if it is the right process in particular considering security factors.

database.php
Code: [Select]
<?php

/**
 * Connect to the mysql database.
 */
$conn = mysql_connect("localhost", "your_username", "your_password") or die(mysql_error());
mysql_select_db('your_database', $conn) or die(mysql_error());

?>
register.php

Code: [Select]
<?php
session_start(); 
include("database.php");

/**
* Returns true if the username has been taken
* by another user, false otherwise.
*/
function usernameTaken($username){
global $conn;
if(!get_magic_quotes_gpc()){
$username = addslashes($username);
}
$q = "select username from Users where username = '$username'";
$result = mysql_query($q,$conn);
return (mysql_numrows($result) > 0);
}

/**
* Inserts the given (username, password) pair
* into the database. Returns true on success,
* false otherwise.
*/
function addNewUser($username, $password){
global $conn;
$q = "INSERT INTO Users VALUES ('$username', '$password')";
return mysql_query($q,$conn);
}

/**
* Displays the appropriate message to the user
* after the registration attempt. It displays a 
* success or failure status depending on a
* session variable set during registration.
*/
function displayStatus(){
$uname = $_SESSION['reguname'];
if($_SESSION['regresult']){
?>

<h1>Registered!</h1>
<p>Thank you <b><?php echo $uname; ?></b>, your information has been added to the database, you may now <a href="main.php" title="Login">log in</a>.</p>

<?php
}
else{
?>

<h1>Registration Failed</h1>
<p>We're sorry, but an error has occurred and your registration for the username <b><?php echo $uname; ?></b>, could not be completed.<br>
Please try again at a later time.</p>

<?php
}
unset($_SESSION['reguname']);
unset($_SESSION['registered']);
unset($_SESSION['regresult']);
}

if(isset($_SESSION['registered'])){
/**
* This is the page that will be displayed after the
* registration has been attempted.
*/
?>

<html>
<title>Registration Page</title>
<body>

<?php displayStatus(); ?>

</body>
</html>

<?php
return;
}

/**
* Determines whether or not to show to sign-up form
* based on whether the form has been submitted, if it
* has, check the database for consistency and create
* the new account.
*/
if(isset($_POST['subjoin'])){
/* Make sure all fields were entered */
if(!$_POST['user'] || !$_POST['pass']){
die('You didn\'t fill in a required field.');
}

/* Spruce up username, check length */
$_POST['user'] = trim($_POST['user']);
if(strlen($_POST['user']) > 30){
die("Sorry, the username is longer than 30 characters, please shorten it.");
}

/* Check if username is already in use */
if(usernameTaken($_POST['user'])){
$use = $_POST['user'];
die("Sorry, the username: <strong>$use</strong> is already taken, please pick another one.");
}

/* Add the new account to the database */
$md5pass = md5($_POST['pass']);
$_SESSION['reguname'] = $_POST['user'];
$_SESSION['regresult'] = addNewUser($_POST['user'], $md5pass);
$_SESSION['registered'] = true;
echo "<meta http-equiv=\"Refresh\" content=\"0;url=$HTTP_SERVER_VARS[PHP_SELF]\">";
return;
}
else{
/**
* This is the page with the sign-up form, the names
* of the input fields are important and should not
* be changed.
*/
?>

<html>
<title>Registration Page</title>
<body>
<h1>Register</h1>
<form action="<?php echo $HTTP_SERVER_VARS['PHP_SELF']; ?>" method="post">
<table align="left" border="0" cellspacing="0" cellpadding="3">
<tr><td>Username:</td><td><input type="text" name="user" maxlength="30"></td></tr>
<tr><td>Password:</td><td><input type="password" name="pass" maxlength="30"></td></tr>
<tr><td colspan="2" align="right"><input type="submit" name="subjoin" value="Join!"></td></tr>
</table>
</form>
</body>
</html>


<?php
}
?>

must be v easy to answer for many here but i dont know how to do it

how can i use for loop to print values between any range but with increment of 0.5

0
0.5
1
1.5
2
2.5
3
........till n