Record How Many Customer Register In A Day Or Month

thelee · November 10, 2012

im really noob in php.i have a final year project and my lecturer ask me to build a nice system.so i have create a page for admin and i want to put a page where admin can see how much people register for that day or month.i dont mind whether it is day or month as long as it can show the record. and it will be nice if i can show the record in graph.can someone help me ?

Barand · November 10, 2012

Do you hold the date they registered in your database eg

registered DATE,

thelee · November 10, 2012

so i must create a new table for date in my database ? then put that code in register.php ?

Barand · November 10, 2012

You don't need a new table just for the date.

What is your table structure currently for registrations?

AyKay47 · November 10, 2012

so i must create a new table for date in my database ? then put that code in register.php ?

No, what does your table structure look like?

thelee · November 10, 2012

<?php




$user = $fullname = $address = $day = $month =$years =$number  = $gender = $email = $password = $repeatpassword ="";


if(isset($_POST['fullname']))  //check for existance <- ni check isset utk 1 form je dah ckp. isset tu yg biasa guna utk cek variable kosong ke x 
{



 //form data
 $fullname= strip_tags($_POST['fullname']);
 $address= strip_tags($_POST['address']);
 $day=strip_tags($_POST['day']);
 $month=strip_tags($_POST['month']);
 $years=strip_tags($_POST['years']);
 $number=strip_tags($_POST['number']);
 $gender=strip_tags($_POST['gender']);
 $email= strip_tags($_POST['email']);
 $password= strip_tags($_POST['password']);
 $repeatpassword= strip_tags($_POST['repeatpassword']);


// echo $fullname;


 //encrypt password

 //$repeatpassword=md5($repeatpassword); ni tak perlu sebab yg kau nak simpan dalam database password je so aku dah 'comment' kan. (boleh padam bila2)

 if($password==$repeatpassword)
 {

   //check char length of username and fullname
  if (strlen($email)>25||strlen($fullname)>25){
       echo "email or fullname is too long!";
    } else {
       //check password length
       if (strlen($password)>25||strlen($password)<6){
           echo "your password must be between 6 to 25 characters";
       } else {
           //register the user!

  //encrypt password
  $password=md5($password);

  //Open database
  $connect = mysql_connect("localhost","root","");
  mysql_select_db("phplogin"); //select database

  $queryreg = mysql_query("

  INSERT INTO users VALUES ('','$fullname','$address','$day','$month','$years','$number','$gender','$email','$password')

  ");

  echo("You have been registered! <a href='index.php'>Return to login page</a>");
       }
    }
  } else {
      echo "Your password do not match!";
  }

}

?>


<html>
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
body,td,th {
font-family: Gisha;
font-size: 24px;
color: #FFFFFF;
}
body {
background-image: url();
}
.style2 {
color: #FFFFFF;
font-size: 24px;
font-weight: bold;
}
-->
</style>
</span>
<p align="center" class="style2 style9 style10">Registration Form</p>
<div align="center"></div>
<table width="486" height="495" border="1" align="center" bordercolor="#000000" bgcolor="#000000">
 <tr>
   <td class="style11"> </td>
 </tr>
 <tr>
   <td width="476" class="style11"><form action ='registertest.php' method ='POST'>
       <p>

       <table width="498" border="1">
         <tr>
           <td width="75">Name</td>
           <td width="407"><input name="fullname" type="text" id="fullname" value="<?php echo $fullname?>"></td>
         </tr>
         <tr>
           <td>Address</td>
           <td><textarea name="address" id="address"></textarea></td>
         </tr>
         <tr>
           <td>Date Of Birth</td>
           <td>Day
             <select name="day" size="1" id="day">
               <option value="1">1</option>
               <option value="2">2</option>
               <option value="3">3</option>
               <option value="4">4</option>
               <option value="5">5</option>
               <option value="6">6</option>
               <option value="7">7</option>
               <option value="8">8</option>
               <option value="9">9</option>
               <option value="10">10</option>
               <option value="11">11</option>
               <option value="12">12</option>
               <option value="13">13</option>
               <option value="14">14</option>
               <option value="15">15</option>
               <option value="16">16</option>
               <option value="17">17</option>
               <option value="18">18</option>
               <option value="19">19</option>
               <option value="20">20</option>
               <option value="21">21</option>
               <option value="22">22</option>
               <option value="23">23</option>
               <option value="24">24</option>
               <option value="25">25</option>
               <option value="26">26</option>
               <option value="27">27</option>
               <option value="28">28</option>
               <option value="29">29</option>
               <option value="30">30</option>
               <option value="31">31</option>
    </select>
    Month
             <select name="month" size="1" id="month">
               <option value="January">January</option>
               <option value="February">February</option>
               <option value="Mac">Mac</option>
               <option value="April">April</option>
               <option value="May">May</option>
               <option value="Jun">Jun</option>
               <option value="Julai">Julai</option>
               <option value="August">August</option>
               <option value="September">September</option>
               <option value="October">October</option>
               <option value="November">November</option>
               <option value="Disember">Disember</option>
             </select>
             <span class="style15">Year</span>
             <select name="years" id="years">
               <option value="2012">2012</option>
               <option value="2011">2011</option>
               <option value="2010">2010</option>
             </select> </td>


         </tr>
         <tr>
           <td>Contact Number </td>
           <td><input name="number" type="text" id="number"></td>
         </tr>
         <tr>
           <td>Gender</td>
           <td><p>
             <label>
             <input type="radio" name="gender" value="Male">
 Male</label>
             <br>
             <label>
             <input type="radio" name="gender" value="Female">
 Female</label>
             <br>
           </p></td>
         </tr>
         <tr>
           <td>Email </td>
           <td><input name="email" type="text" id="email" value="<?php echo $email?>">            </td>
         </tr>
         <tr>
           <td>Choose Password </td>
           <td><input name="password" type="password" id="password"></td>
         </tr>
         <tr>
           <td>Confirm Password </td>
           <td><input name="repeatpassword" type="password" id="repeatpassword">
           </td>
         </tr>
       </table>
       <p>
       <input type="submit" name="submit" value="Register">         
       <p>        </form>
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         <p> 
  </p>
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         <p> </p></td>
 </tr>
</table>
<p> </p>
<p align="center" class="style16 style23 style2 style11">

//the day month and years is for the user date of birth.i dont know how to joined them together.so i just cr8 3 table.but its ok

AyKay47 · November 10, 2012

The above code does not show us the table structure for registrations.

thelee · November 10, 2012

can u give me any example ? sorry.im really newbie.

Barand · November 10, 2012

Store dates as DATE type fields (format is YYYY-MM-DD) . There is a whole raft of SQL functions for handling dates.

Run this query and post the output

SHOW CREATE TABLE users

thelee · November 10, 2012

this one ?

CREATE TABLE `users` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(50) NOT NULL DEFAULT '',

`address` varchar(100) NOT NULL DEFAULT '',

`day` int(10) NOT NULL,

`month` varchar(15) NOT NULL,

`years` int(10) NOT NULL,

`number` varchar(15) NOT NULL,

`gender` varchar(100) NOT NULL,

`email` varchar(100) NOT NULL,

`password` varchar(100) NOT NULL DEFAULT '',

PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=97 DEFAULT CHARSET=latin1

Barand · November 10, 2012

the day month and years is for the user date of birth.

.

Then you need another date for registration if you want any hope of reporting on when they registered.

Add

registered DATE

and put the value CURDATE() into it when you add a new record. Of course you'll need to retro-update existing records manually.

Sign In

Record How Many Customer Register In A Day Or Month

Recommended Posts

thelee

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

thelee

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

AyKay47

Link to comment

Share on other sites

thelee

Link to comment

Share on other sites

AyKay47

Link to comment

Share on other sites

thelee

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

thelee

Link to comment

Share on other sites

Barand

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information