PHP - Need Help With An Account Update Snippet

The snippet repository section has been read only and nothing new for a long time. Most of the ones there are pretty old.   The tutorials sections last post was from 2010 The old pagination tutorial needs a good mysqli and pdo version there. http://www.phpfreaks...asic-pagination   I noticed how slow the sites been a while now, maybe need something to lure more in.  

Hi,

The code for displaying a results set in multiple columns (http://www.phpfreaks.com/forums/index.php?topic=95426.0) works really well and displays

1 2 3 4
5 6 7 8

Does anyone know how to change so it displays as

1 3 5 7
2 4 6 8

Any help would be greatly appreciated

thanks

a

I am trying to create a registration form where users put their name, email and password only.   but i want to write an auto generated account number into database table for each user e.g; XY1234567 where XY should not change 1234567 auto generated random number and no duplicates (in numbers only).   example...   XY1234567 XY2345678 XY2233455   i found code

$num_of_ids = 10000; //Number of "ids" to generate.
$i = 0; //Loop counter.
$n = 0; //"id" number piece.
$l = "AAA"; //"id" letter piece.

while ($i <= $num_of_ids) { 
    $id = $l . sprintf("%04d", $n); //Create "id". Sprintf pads the number to make it 4 digits.
    echo $id . "<br>"; //Print out the id.

    if ($n == 9999) { //Once the number reaches 9999, increase the letter by one and reset number to 0.
        $n = 0;
        $l++;
    }

    $i++; $n++; //Letters can be incremented the same as numbers. Adding 1 to "AAA" prints out "AAB".
}

but its not working as i want. Any help please?
Edited by 684425, 27 December 2014 - 12:58 PM.

The below script WILL list one account successfully, but how come this script doesn't list more than one  account when <b>listAccounts()</b> is called?

EXAMPLE OF accounts.txt FILE:
Code: [Select]
username:blah
user526:pass
justinlh:justin


                 function listAccounts()
                {
                    //load all the accounts
                    $accounts = loadAccounts();
                    
                    //display each account in the drop-down box
                    foreach($accounts as $account)
                    {
                       $account_split = explode(':', $account);
                        
                       echo '<option value="'. $account .'">'.$account_split[0].'</option>';
                    }
                }
                
                function loadAccounts()
                {
                    /*  EXAMPLE OF ACCOUNTS.TXT
                     *  http://pastebin.com/zAPH0a4J
                     */
                    
                    $handle = fopen('accounts.txt', 'r');
                    $accounts = fread($handle, filesize('accounts.txt'));
                    fclose($handle);
                    
                    return explode('\n', $accounts);
                }

Does anyone know of a json or php method of authenticating a youtube user without using zend?

Code: [Select]
<?php
$id = NULL;
$username = 'myYouTubeAccount'; 
$url = 'http://gdata.youtube.com/feeds/api/users/%s/uploads?orderby=updated&max-results=8';
$xml = simplexml_load_file(sprintf($url, $username));

foreach ($xml->entry as $entry) :

    $kids = $entry->children('http://search.yahoo.com/mrss/');
    $attributes = $kids->group->content[0]->attributes();
    $flv = $attributes['url'];
    $attributes = $kids->group->player->attributes();
    $link = $attributes['url']; 

    $querystring = parse_url($link,PHP_URL_QUERY);
    parse_str($querystring, $id_temp);
    $id = $id_temp['v'];
?>

<a href="<?=$link?>"> <img src="http://i4.ytimg.com/vi/<?=$id?>/default.jpg"  /> </a>

<?php endforeach; ?>

Hi!  Trying to have it send a link to a user's email upon registration, and set it so they can't login until they click the link from their email.  Here's the register script:
<?php
   
include('config.php');
include('dateindex.php');

if($loggedin == '1')
die("You can't register another account while you're logged in.");

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

$callname = mysql_real_escape_string($_POST['callname']);
$uname = mysql_real_escape_string($_POST['username']);  
$password = mysql_real_escape_string($_POST['password']);  
$email = mysql_real_escape_string($_POST['email']);  

if((!isset($_POST['username'])) || (!isset($_POST['callname'])) || (!isset($_POST['email'])) || (!isset($_POST['pass'])) || ($uname == '') || ($_POST['pass'] == ''))
die("Please fill out the form completely. <br><br>
<a href=register.php>Continue</a>");

$check = @mysql_query("SELECT id FROM users WHERE username = '$uname'");
$check = @mysql_num_rows($check);

if($check > 0)
die("Sorry, that username has already been taken. Please try again.
<br><br>
<a href=register.php>Continue</a>");

function validateEmailAddress($email) {
return filter_var($email, FILTER_VALIDATE_EMAIL) && preg_match('/@.+\./', $email);
}
if(validateEmailAddress($email) !=1) {
echo "That email address does not exist.<br /><br /><a href=register.php>Continue</a>";
exit();
}

$pass = md5($_POST['pass']);

$date = date("m/d/y");

$a =md5(uniqid(rand(), true));

$newPlayer = @mysql_query("INSERT INTO users (username, password, callname, email, registered, active) VALUES ('$uname', '$pass', '$callname', '$email', '$date', '$a')") or die("Error: ".mysql_error());

if (mysql_affected_rows() == 1) {
$body = "Thank you for registering.  To activate account click this link";

$body .= "http://localhost/testing/mbactivate.php?x=" . mysql_insert_id() . "$y=$a";

mail($_POST['email'], 'Registration Confirmed', $body, 'From:mirrorcat@airpost.net');


echo '<br />You have been registered! A confirmation email has been sent.';

exit();
}
}
else
{

echo '<form action=register.php method=post>
Callname: <input type=text name=callname><br>
Username: <input type=text name=username><br>
Email: <input type=text name=email><br>
Password: <input type=password name=pass><br>
<input type=submit name=submit value=Submit>
</form>';

}

?>



login/index:
<?php

include('config.php');

echo '<center><a href=index.php>Main</a> | <a href=myprofile.php>Profile</a> | <a href=inbox.php>Inbox</a> | <a href=page1.php>To-Do List</a> | <a href=logout.php>Logout</a></center>';

print date('g:i a - l, F jS');

echo '<br /><br />';

?>

<?php

if($loggedin == '0')
{
if(isset($_POST['submit']))
{

// Make sure all forms were filled out.

if((!isset($_POST['username'])) || 
(!isset($_POST['pass'])) 
|| ($_POST['username'] == '') || ($_POST['pass'] == ''))
die("Please fill out the form completely. <br><br>
<a href=index.php>Continue</a>");

// Get user's record from database
$player = @mysql_query("SELECT id, username, password, callname, email, registered, lastlogin FROM users WHERE username = '".$_POST['username']."'");
$player = @mysql_fetch_assoc($player);
mysql_real_escape_string($username);
mysql_real_escape_string($password);

if($player['id'] == false)
die("Sorry, that user is not in our database.<br><br>
<a href=index.php>Back</a>");
else if($player['password'] != md5($_POST['pass']))
die("Wrong password!<br><br>
<a href=index.php>Back</a>");

$_SESSION['id'] = $player['id'];
$_SESSION['username'] = $player['username'];
$_SESSION['password'] = $player['password'];
$_SESSION['callname'] = $player['callname'];
$_SESSION['email'] = $player['email'];

$date = date("m/d/y");

$update = @mysql_query("UPDATE users SET lastlogin = '$date' WHERE id = '".$_SESSION['id']."'");

echo 'You are now logged in!';

}
else
{
echo 'You are not logged in. <br><br>
<form action=index.php method=post>
Username: <input type=text name=username><br>
Password: <input type=password name=pass><br>
<input type=submit name=submit value=Submit>
</form>
Would you like to <a href=register.php>register?</a>';
}
}

else
{
echo 'You are logged in! 
Welcome, '.$_SESSION['callname'].'!';

}

?>

<br /><br />

<b>Activate Account</b><br />

<?php

 

// Validate $_GET['x'] and $_GET['y'].

 

if (isset($_GET['x'])) {

 

$x = (int) $_GET['x'];

 

} else {

 

$x = 0;

 

}

 

if (isset($_GET['y'])) {

 

$y = $_GET['y'];

 

} else {

 

$y = 0;

 

}

 

// If $x and $y aren't correct, redirect the user.

 

if ( ($x > 0) && (strlen($y) == 32)) {

 

$query = "UPDATE users SET active=NULL WHERE (id=$x AND active='" . $y . "') LIMIT 1";

 

$result = mysql_query ($query) or trigger_error("Query: $query\n<br />MySQL Error: " . mysql_error());

 

 

 

// Print a customized message.

 

if (mysql_affected_rows() == 1) {

 

echo "<br><br><h3>Your account is now active. You may now log in.</h3>";

 

} else {

 

echo '<br><br><p><font color="red" size="+1">Your account could not be activated. Please re-check the link or contact the system administrator.</font></p>';

 

}

 

// mysql_close();

 

} else { // Redirect.

 

// Start defining the URL.

 

$url = 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']);

 

// Check for a trailing slash.

 

if ((substr($url, -1) == '/') OR (substr($url, -1) == '\\') ) {

 

$url = substr ($url, 0, -1); // Chop off the slash.

}

 

// Add the page.

$url .= '/index.php';

 

ob_end_clean(); // Delete the buffer.

 

exit(); 
 

} // End of main IF-ELSE.

?>

My problem is it isn't sending the code to the email specified, even though the random letters that should be sent to the email are stored in the database.  And when I test the url anyway, (x=1&y=activationcode) it returns it as false, that the code doesn't exist even though I can clearly see it in my database!  Can anyone spot any errors?

This code logs the user in with the correct user_email, user_pwd, and active=1.
A '0' is inserted into the active column of the users table during registration.
I need help checking if active=0 then flash_warning('User account not activated').

login_user.php
Code: [Select]
<?php
 include(MODEL_PATH.'user.php');

 switch ($route['view']){

 case "login_user":
if(login($params['user']['user_email'], $params['user']['user_pwd']))
{
flash_notice('You are logged in!');
redirect_to('');
}
else
{
flash_warning('Username or password is invalid!');
$route['view'] = 'login';
}
 break;
}user.php
Code: [Select]
<?php
 session_start();

 function login($username, $password)
 {
db_connect_posts();

$query = sprintf("SELECT * FROM users
WHERE 
user_email = '%s' AND
user_pwd = '%s' AND 
active = '1'"
, mysql_real_escape_string($username),
md5($password)
);

$result = mysql_query($query);

$number_of_posts = mysql_num_rows($result);

if($number_of_posts == 0)
{
return false;
}

$row = mysql_fetch_array($result);

$_SESSION['user'] = $row;

return true;
 }
?>Login form
Code: [Select]
<form action="<?php echo '/'.APP_ROOT.'/'; ?>sessions/login_user" method="post">
 <fieldset>
  <legend>Login</legend>
  <div>
    <label>E-mail</label>
    <input name="user[user_email]" size="40" type="text" />
  </div>
 
  <div>
    <label>Password</label>
    <input name="user[user_pwd]" size="40" type="password" />
  </div>
  <input type="submit" value="Login" />
 </fieldset>
</form>

Hi guys,   It's been a while that I have actively contributed to phpfreaks. I had some time consuming matters unfortunately. If it would be possible I would like to have my old account restored or reactivated. The name probably sounds familiar The restore password form doesn't seem to work (as in I receive no mails). My emailaddress hasn't changed. Thanks in advanced!   Cssfreakie   <--- the old one
Edited by cssfreakie2, 13 January 2015 - 01:35 PM.

Hello, I am having a problem with this code. I know it's messy, but it works.

The Problem is that you can register a username more then once, It detects there is already a username of that in the database, but it still inserts it, and then there would be two of the same username.

My Code:
<?php
    if($_SERVER['REQUEST_METHOD'] == 'POST') {
  if($_POST['username'] == "" || $_POST['password1'] == "" || $_POST['password2'] == "" || $_POST['email'] == "" || $_POST['rights'] == "" ||  $_POST['ipaddress'] == "")
  {
    echo '<p class="info" id="warning"><span class="info_inner">You left one or more fields blank.</span></p>';
  }
  else
  {
    $rr = mysql_query('SELECT * FROM users WHERE username=\'' . realEscape($_POST['username']) . '\'') ;
    if(mysql_num_rows($rr) > 0)
    {
    echo '<p class="info" id="error"><span class="info_inner">ERROR: The username is already in use!</span></p>';
    }
    $rrr = mysql_query('SELECT * FROM users WHERE email=\'' . realEscape($_POST['email1']) . '\'') ;
    if(mysql_num_rows($rrr) > 0)
    {
    echo '<p class="info" id="error"><span class="info_inner">ERROR: The email is already in use!</span></p>';
    } else {
      if($_POST['password1'] == $_POST['password2'])
      {
        if(preg_match('/[A-Za-z0-9-\s]{3,13}/i', $_POST['username'], $matches) && strlen($matches[0]) === strlen($_POST['username']))
        {
          if(preg_match('/[a-z0-9]{3,13}/i', $_POST['password1'], $matches) && strlen($matches[0]) === strlen($_POST['password1']))
          {
            if(is_numeric($_POST['rights'])) {
              mysql_query("INSERT INTO users (username, password, rights, ipaddress, email, date) VALUES ('". realEscape($_POST['username']) ."', '". encrypt($_POST['password1']) ."', '". realEscape($_POST['rights']) ."', '". realEscape($_POST['ipaddress']) ."', '". realEscape($_POST['email']) ."', NOW())");
              echo '
              <p class="info" id="info"><span class="info_inner">The account has been created.</p>';
            } else {
              echo '<p class="info" id="error"><span class="info_inner">ERROR: Undefined</span>';
            }
          }
          else
          {
            echo '<p class="info" id="error"><span class="info_inner">ERROR: Invalid password. Your password can only contain Numbers and Letters, and be 3-12 characters in length.</span></p>';
          }
        }
        else
        {
          echo '<p class="info" id="error"><span class="info_inner">ERROR: Invalid username. Your password can only contain Numbers and Letters, and be 3-12 characters in length.</span></p>';
        }
      }
      else
      {
        echo '<p class="info" id="error"><span class="info_inner">ERROR: Passwords do not match.</span></p>';
      }
    }
  }
  }
?>

Hi friends,
  I am creating a  site where  users can add credit  to their account via Liberty Reserve, and after  that their account  will  automatically  be updated with  the amount they added so that they can use it to purchase products.. And  after any purchase,  the amount will be subtracted from their account.. I cant  really  find a  php code  to do that... i have done  a  search on here but still cant  find anything close to it.. Can someone kindly help? Thank you

Hello everyone, here is my problem.

I am working for someone that would like users to be able to create a Trial Account on their website. This trial account is to be used for 24 hours, once the 24 hours is completed they can no longer login/use that account.

Everything about the Trial Account is completed, other then the account timer.

I am at a loss on how to get this part done.

I was thinking that I would use the MySQL commands, GETDATE() and DATEADD(), to get the date and time that the account was created and using the DATEADD() command I would add 24 hours to the GETDATE() value. Then if the user logs into at a date past the DATEADD() value the Users Account type is switched to 3(This means that the account has been disabled) and then is directed to the Logout page, which then redirects him back to the homepage.

After this point, the user can no longer login due to the code preventing any user with an account type of 3 to login.

The problem is that I am unaware how to incorporate the GETDATE() and DATEADD() functions into my PHP code.

Would anyone be able to explain how I can get this done, or suggest a better method of inputting a starting time and ending time for the account?

Thank You for any/all help.

I've been doing a lot of studying of Linux lately. I enabled the root acount to do some work. When done, even if I logout, close the terminal, or reboot, I can still access the root account without supplying the root password. So what am I not understanding or what am I doing wrong? I don't really need to disable the root account, but this is just a learning experience, and I'm not understanding why I still have access. See below:     # I needed to enable root access for something skunkbad:~$ sudo passwd root   # I did what I needed to do skunkbad:~$ sudo -i root@ubuntu-Inspiron-3647:~#   # I logout from root root@ubuntu-Inspiron-3647:~# logout   # I disable the root access per instructions from many internet references skunkbad:~$ sudo passwd -dl root   # Root access is still available, even if I close and reopen the terminal skunkbad:~$ sudo -i   # I logout from root root@ubuntu-Inspiron-3647:~# logout   # Trying to access root via su prompts for password, and old password is wrong skunkbad:~$ su Password: su: Authentication failure

This topic has been moved to Miscellaneous.

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

I am using a standard form to mail script and have a few fields that I need to be required to be filled in.
This is working fine until someone enters a space character in a required field, which is being let thorugh.

How can I stop this? here the code for required fields -  I thought the trim function in the below would have taken care of this???

// This is because I originally had it require but too many people
// were used to Matt's Formmail.pl which used required instead.
if ($required)
   $require = $required;
// handle the required fields
if ($require) {
   // seperate at the commas
   $require = ereg_replace( " +", "", $require);
   $required = split(",",$require);
   for ($i=0;$i<count($required);$i++) {
      $string = trim($required[$i]);
      // check if they exsist
      if((!(${$string})) || (!(${$string}))) {
         // if the missing_fields_redirect option is on: redirect them
         if ($missing_fields_redirect) {
            header ("Location: $missing_fields_redirect");
            exit;
         }
         $require;
         $missing_field_list .= "<b><font color=\"#990000\">Missing: $required[$i]</font></b><br>\n";
      }
   }
   // send error to our mighty error function
   if ($missing_field_list)
      print_error($missing_field_list,"missing");
}

Hi guys,

I want something to be clarified.

The supervisor of my system is responsible for approving accounts. When he logged into the system he should be able to view the customer records based on customer ID. That is when he types the relevant customer ID and clicks on search button the relevant record is displayed in a form. That part is OK.

Thereafter he should approve the account by clicking on "Approve Account" button. I want to know how can he make sure relevant customer_id is approved or not.

customer table includes fields of,
  customer_id, nic, full_name, name_with_initials, address, contact_number, gender.

I want to whether i have add an extra field to my customer table saying "approves status" or whatever.
Can anyone give me a suggestion??

Thanks,
Heshan