PHP - User Count Registered Today

Hi guys,

I need your help. I am trying to insert the rows in the mysql database as I input the values in the url bar which it would be like this:

Code: [Select]
www.mysite.com/testupdate.php?user=tester&pass=test&user1=tester&email=me@shitmail.com&ip=myisp

However i have got a error which i don't know how to fix it.


Error: Column count doesn't match value count at row 1


<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'mydbusername');
    define('DB_PASSWORD', 'mydbpassword');
    define('DB_DATABASE', 'mydbname');

$errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {

die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {

die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
  $username = clean($_GET['user']);
    $password = clean($_GET['pass']);
    $adduser = clean($_GET['user1']);
    $email = clean($_GET['email']);
    $IP = clean($_GET['ip']);
    if($username == '') {
  $errmsg_arr[] = 'username is missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PASSWORD is missing';
  $errflag = true;
    }
    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
   $sql = "INSERT INTO `members` (`username`,`email`,`IP`) VALUES ('$adduser','$email','$IP')";

if (!mysql_query($sql,$link))
  {
  die('Error: ' . mysql_error());
  }
echo "The information have been updated.";
  }
?>


Here's the name of the columns i have got in my database:

Code: [Select]
username
email
IP


I have input the correct columns names, so I can't correct the problem I am getting.

Please can you help?

Hi.  I have wrote a simple login script.  Works perfectly.  Now as my users can only register one email address at the minute if you register two the same you get the default sql error pop up.  I want my own error so at the beginning of my script i wrote the following code. however.  It does not seem to be running.  It does not create an error but still allows duplicate emails in the database.  can anyone see the error of my ways?
<?php session_start();
if(isset($_POST['create'])){    
 //script for checking if the email account already exists
$qCheckEmail = "SELECT * FROM members WHERE email='".$_POST['email']."'";
$rCheckEmail = mysql_query($qCheckEmail);
$Email = mysql_fetch_array($rCheckEmail);
 
 if($_POST['email'] == $Email['email']) 
 {$emailDup = "This email account has already been registered";}
 else
 { 
//Process data for validation    
$forename =  trim($_POST['forename']);    
$surname =  trim($_POST['surname']);    
$email      =  trim($_POST['email']);        
$password   =  trim($_POST['password']);     
$gender     =  trim($_POST['gender']);
$birthday =  $_POST['birthday'];
$creationdate = $_POST['creationdate'];
$validationID = $_POST['validationID'];
$accesslevel =  trim($_POST['accesslevel']);
$accountType =  trim($_POST['accountType']);
// then the rest of the login script here

This topic has been moved to MySQL Help.

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

Okay, I have a field called "created" in my `users` table, and I'd like to be able to view it in-game on an administrator panel. However, it's being captured in a long number format (i.e. 1335076320) which, I believe, has to deal with seconds and such.

How can I take that number and convert it to an actual date/time output?

Here's how I currently have it coded in my php form:


<tr><td width="20%">Registered On:</td><td>{{created}}</td></tr>



So, obviously it's not converting it to any format, rather just pulling that 1335076320 number out.

Thanks in advance!

I need a php code to send an activation link to the user,and when the user clicks the link the account gets activated.

less than 6 characters.  I think it's the way my code is ordered.  I've tried switching the commands around, no luck.

Help please.
Code: [Select]
<?php
//begin register script

$submit = $_POST['submit'];

//form data
$username= strip_tags ($_POST['username']);
$email= strip_tags($_POST['email']);
$pwd= strip_tags($_POST['pwd']);
$confirmpwd= strip_tags($_POST['confirmpwd']);
$date = date("Y-m-d");

if ($submit) {
   //check for required form data
   if($username&&$pwd&&$confirmpwd&&$email) {
      
      
      //check length of username
        if (strlen($username)>25||strlen($username)<6) {
            echo "<p class='warning'>username must be bewteen 6 and 25 characters</p>";
        } else {
      
        //check password length
        if (strlen($pwd)>25||strlen($pwd)<6) {
            echo "<p class='warning'>password must be between 6 and 25 characters</p>";
            } else {
               
       //register the user
      echo "<p class='success'>Thanks for signing up!</p>";
            }
       }
         
       
     //check if passwords match
      if ($pwd==$confirmpwd) {
    
      } else {
         echo "<p class='warning'>your passwords do not match</p>";
      } 
      //encrypt password
      $pwd = md5($pwd);
      $confirmpwd = md5($confirmpwd);
     
       //open database
     $connect = mysql_connect("xxxxxxxx", "xxxxxxxx", "xxxxxxxx");
     mysql_select_db("digital"); //select database
     
     //register the user
     $queryreg = mysql_query("
                       
     INSERT INTO users VALUES ('','$username', '$email', '$pwd')
   
     
     ");
     
    die("<p class='success'>Thank you for signing up you have been registered");
     

      } else {
      echo "<p class='warning'>please fill in all fields</p>";
     
   
   }
}
?>

Why am I getting this error when there are 3 Fields with 3 values?

Column count doesn't match value count at row 1

Code: [Select]
$sql5="INSERT INTO participants (participant_name, team_no, sport)
VALUES ('".implode("','$_POST[team]'),('",$_POST['participant_name'])."','$_POST[team]','$sport')";

This topic has been moved to PHP Applications.

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

I'm using this type of code below. how can my site may have access to my e-mail ? and how can I send e-mails containing passwords to users.?? please help.
//code is like this//
if($_POST['submit']=='Register')
{
   // If the Register form has been submitted
   
   $err = array();
   
   if(strlen($_POST['username'])<4 || strlen($_POST['username'])>32)
   {
      $err[]='Your username must be between 3 and 32 characters!';
   }
   
   if(preg_match('/[^a-z0-9\-\_\.]+/i',$_POST['username']))
   {
      $err[]='Your username contains invalid characters!';
   }
   
   if(!checkEmail($_POST['email']))
   {
      $err[]='Your email is not valid!';
   }
   
   if(!count($err))
   {
      // If there are no errors
      
      $pass = substr(md5($_SERVER['REMOTE_ADDR'].microtime().rand(1,100000)),0,6);
      // Generate a random password
      
      $_POST['email'] = mysql_real_escape_string($_POST['email']);
      $_POST['username'] = mysql_real_escape_string($_POST['username']);
      // Escape the input data
      
      
      mysql_query("   INSERT INTO tz_members(usr,pass,email,regIP,dt)
                  VALUES(
                  
                     '".$_POST['username']."',
                     '".md5($pass)."',
                     '".$_POST['email']."',
                     '".$_SERVER['REMOTE_ADDR']."',
                     NOW()
                     
                  )");
      
      if(mysql_affected_rows($link)==1)
      {
         send_mail(   'myemail@xx.net',
                  $_POST['email'],
                  'sitename - Your New Password',
                  'Your password is: '.$pass);

         $_SESSION['msg']['reg-success']='We sent you an email with your new password!';
      }
      else $err[]='This username is already taken!';
   }

   if(count($err))
   {
      $_SESSION['msg']['reg-err'] = implode('<br />',$err);
   }   
   
   header("Location: demo.php");
   exit;
}


//but while running it on local server it shows the message "failure" as I have mentioned in the index.php. please provite a template codeing to solve the problem//

Hello Everyone,

I recent made a simple membership website. Every page I created works exactly how I envisioned it...
All members data from my registration form goes into my database along with their md5 Encrypted passwords with a time-stamp.
Subsequent pages have a start_session included.

I am very please with it except ONE THING. Logging in is now a problem... username is recognized but NOT the password.

Now the strange thing is that when I go into the database and copy the encrypted password and paste
it into the password field in my login page, I miraculously get into my website with NO problem.

" How do I get the registered members Encrypted Passwords to be recognized by the database when
the  registered members decide to logging in with the password that they create? "

Is there a easy fix for this?

I appreciate ALL your help...


thanks
mrjap1

Hi I am trying to add a field to a database that is 4 days from the date the record is added, but it is not adding a value

Code: [Select]
$end_date=strtotime("+ 4 days");

$add_vehicle_sql=mysql_query("INSERT INTO `tbl_auction_lot`(`cust_id`,`reserve`,`make`,`model`,`spec`,`fuel`,`doors`,`mot_date`,`fns`,`fos`,`rns`,`ros`,`condition`,`reg_no`,`service_history`,`sale_type`,`status`,`keepers`,`gearbox`,`emissions`,`colour`,`date_first_reg`,`date_manufacture`,`bhp`,`engine_size`,`end_date`)
VALUES ('$seller_id','$reserve','$make','$model','$body_style','$fuel_type','$no_of_doors','$mot','$fns','$fos','$rns','$ros','$vehicle_condition','$vrm','$service_history','auction','$status','$prev_keepers','$gearbox','$emissions','$colour','$date_reg','$date_man','$bhp','$engine_size','$end_date')") or die(mysql_error());

What am I doing wrong and what is there a better way to achieve the desired result.

Hello,

In my Mysql database, it has a datetime field.

and I have created a $today = date('Y-m-d H:i:s');  <-  today's date and time

How do I write a query to run in PHP in order to get all today's items by comparing datetime field and $today?

Thanks!

This topic has been moved to PHP Freelancing.

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

I'm looking for a simple little code to display today's date, month, day, year and countdown to 365 days. Can anyone please help.