thelee Posted November 10, 2012 Share Posted 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 ? Quote Link to comment https://forums.phpfreaks.com/topic/270535-record-how-many-customer-register-in-a-day-or-month/ Share on other sites More sharing options...
Barand Posted November 10, 2012 Share Posted November 10, 2012 Do you hold the date they registered in your database eg registered DATE, Quote Link to comment https://forums.phpfreaks.com/topic/270535-record-how-many-customer-register-in-a-day-or-month/#findComment-1391492 Share on other sites More sharing options...
thelee Posted November 10, 2012 Author Share Posted November 10, 2012 so i must create a new table for date in my database ? then put that code in register.php ? Quote Link to comment https://forums.phpfreaks.com/topic/270535-record-how-many-customer-register-in-a-day-or-month/#findComment-1391494 Share on other sites More sharing options...
Barand Posted November 10, 2012 Share Posted November 10, 2012 You don't need a new table just for the date. What is your table structure currently for registrations? Quote Link to comment https://forums.phpfreaks.com/topic/270535-record-how-many-customer-register-in-a-day-or-month/#findComment-1391496 Share on other sites More sharing options...
AyKay47 Posted November 10, 2012 Share Posted 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? Quote Link to comment https://forums.phpfreaks.com/topic/270535-record-how-many-customer-register-in-a-day-or-month/#findComment-1391497 Share on other sites More sharing options...
thelee Posted November 10, 2012 Author Share Posted 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 Quote Link to comment https://forums.phpfreaks.com/topic/270535-record-how-many-customer-register-in-a-day-or-month/#findComment-1391498 Share on other sites More sharing options...
AyKay47 Posted November 10, 2012 Share Posted November 10, 2012 The above code does not show us the table structure for registrations. Quote Link to comment https://forums.phpfreaks.com/topic/270535-record-how-many-customer-register-in-a-day-or-month/#findComment-1391499 Share on other sites More sharing options...
thelee Posted November 10, 2012 Author Share Posted November 10, 2012 can u give me any example ? sorry.im really newbie. Quote Link to comment https://forums.phpfreaks.com/topic/270535-record-how-many-customer-register-in-a-day-or-month/#findComment-1391501 Share on other sites More sharing options...
Barand Posted November 10, 2012 Share Posted 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 Quote Link to comment https://forums.phpfreaks.com/topic/270535-record-how-many-customer-register-in-a-day-or-month/#findComment-1391502 Share on other sites More sharing options...
thelee Posted November 10, 2012 Author Share Posted 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 Quote Link to comment https://forums.phpfreaks.com/topic/270535-record-how-many-customer-register-in-a-day-or-month/#findComment-1391504 Share on other sites More sharing options...
Barand Posted November 10, 2012 Share Posted 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. Quote Link to comment https://forums.phpfreaks.com/topic/270535-record-how-many-customer-register-in-a-day-or-month/#findComment-1391506 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.