heshanm

Hi, I want to display current date and time in my system..Therefore i have created following coding. <?php $today= date("F j, Y, g:i a"); echo $today; ?> This generates time based on GMT..But i want to convert the time to our country's local time which is more than 05:30 hrs.How …

Hi All, I want to generate time table reports. A form includes labels to enter grade, class and stream. After selecting data user should click on "Generate" button and relevant time table details. The data is submitted for the following page and there was an empty set of data shown …

Hi All, I have a samll problem related to a specific query. It creates following error. **Unknown column 'attendance_state.state' in 'field list'** $query="SELECT attendance_state.state,attendance_state.state_id from attendance_state inner join attendance on attendance_state.state_id=attendance.state_id where attendance.admission_no='".$admission_id[$i]."' and attendance.date='$date'"; $result=mysql_query($query) or die (mysql_error()); The table related to the query looks like this. "state_id" is …

Hi All, I have a small problem. I want to add time tables for each grade in a school. Therefore in my addTimeTable.php page i have created a form to enter student grade, class and stream. (required only for grade 12 and 13) When a user clicks on "Add" button …

Hi All, I want to add data for the time tables. I have created 3 fields namely grade, class and stream which is only relevant for advanced level classes. otherwise the "stream" field should be disabled. In my database the class table and grade tables were already populated with data. …

Hi guys, In the below form when a user enters an admission number and click on the relevant type report the report was generated. ..Then I want something like this.When a user enters an admission number which is already existing, a validation should come as "The number already existed". How …

Hi all, My requirement is to add student marks into the system. In my form i have entered admission number of the student, term and year and click on "Add" button to enter marks. Thereafter the page should be redirected to the following page where it should be displayed marks. …

Hi all, This is my chage password script. This works ONLY if all the data fields entered correctly. Otherwise it gives several error messages. (Ex:incorrect username, incorrect pw etc) users (user_id, first_name,last_name, email, phone_number, user_type, username, password) [CODE] <?php session_start(); $connection=mysql_connect("localhost","root",""); $db=mysql_select_db("bank",$connection); $username = $_POST['username']; $password = $_POST['password']; $newpassword = …

I want to retrieve records in my database in order to manage details. The below error message displayed when i trying to do that. Can anyone help me out? ( ! ) Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\Student registration\manage student details\manageStudentDetailsForm.php on line 250 …

I want to submit data of my student registration form to the database. If an admission number already exists, a message should be displayed like this. "**Admission number2012/1..This student has been already entered to the system**." I have created the below coding which fulfill the above task. But i want …

Hi all, I have small problem regarding my student registration form. When i enter data and submit always below message is displayed irrespective of whether the admission_id is exist or not. "Admission numberThis student has been already entered to the system" **newStudentRegistrationForm.php** <form name="form1" method="post" action="newStudentRegistrationFormvalidation.php"> <?PHP $con=mysql_connect("localhost","root",""); mysql_select_db("student_management",$con); ?> …

I have following errors in below coding. Undefined variables: fname,focu,foad,ftp,fmf,mname,mocu,moad,mtp,mmf,gname,gocu,goadd,gtp,gmf in C:\wamp\www\Student registration\manage studnt parent details\manageStudentRegistrationParentDetailsForm.php Code <?php $query="SELECT state,name,occupation,office_address,office_telephone,mobile_number FROM parent_info where admission_no='$admission_no'"; $result=mysql_query($query); while($row=mysql_fetch_array($result)){ $first=$row['state']; if($first=='father'){ $fname=$row['name']; $focu=$row['occupation']; $foadd=$row['office_address']; $ftp=$row['office_telephone']; $fmf=$row['mobile_number']; } if($first=='mother'){ $mname=$row['name']; $mocu=$row['occupation']; $moadd=$row['office_address']; $mtp=$row['office_telephone']; $mmf=$row['mobile_number']; } if($first=='guardians'){ $gname=$row['name']; $gocu=$row['occupation']; $goadd=$row['office_address']; $gtp=$row['office_telephone']; $gmf=$row['mobile_number']; } } ?> …

I have a login form and i want to enter username & password to log into the system. When loading the page (index.php) there was an error displayed like this. >Notice: Undefined index: msg in C:\wamp\www\Home page\new student registration\index.php on line 13 index.php <form id="form1" name="form1" method="post" action="adminloginvalidate.php"> <?php $message=$_POST["msg"]; …

I have created these 2 pages to generate reports. [B][U]teller_reports.php[/U][/B] [CODE] <form id="form1" name="form1" method="post" action="daily_transactions_report.php"> <label>DailyTransaction Reports<br /> <br /> DATE </label> <input type="text" id="demo3" name="date" maxlength="25" size="25"/> <img src="../images/cal.gif" onclick="javascript:NewCssCal('demo3','yyyyMMdd')" style="cursor:pointer"/> <p> <label></label> <label> <a href="tcpdf/examples/daily_transactions_report.php"> <input type="submit" name="button" id="button" value="Generate" /> </a> </label> </p> </form> [/CODE] [B][U]daily_transactions.php[/U][/B] …

In the below query,the "Account has been successfully approved" message dispayed. But in the database still approved_status remains '0'. [CODE] <?php $connect=mysql_connect('localhost','root',''); mysql_select_db('bank',$connect); if(isset($_POST['account_number'])) $account_number=$_POST['account_number']; else $account_number=''; $query = "UPDATE account_details SET approved_status='1' WHERE account_number='$account_number'"; $result= mysql_query($query) or die(mysql_error()); if ($result) { echo "Account has been successfully approved"; } ?> …

This is my 2 tables. [B]account_details[/B] (account_number, nic, full_name, phone_number, address, gender, date_of_birth,__) [B]account[/B] (account_number, name_with_initials,account_type, fd_period,__) I want to select records in both the tables. This is my SQL line. [CODE] $query ="SELECT account_details. nic,full_name,phone_number,address,gender,date_of_birth,account.name_with_initials,account_type,fd_period". "FROM account_details,account". "WHERE account_details.account_number=account.account_number"; [/CODE] The following error occurs. You have an error in …

Hi, I want to validate phone number in my project. I include some validations. Furthermore i want to check whether it exactly contains ONLY 10 digits.nothing more and nothing less.How should i include that? [CODE] if (document.form1.phone_number.value == '') { alert('Please fill in phone number!'); return false; } if(!document.form1.phone_number.value.match(/^[0-9]+$/)){ alert('Please …

Hi all, I have tried this for a very long time. But i could not found out the error. This should suppose to retrieve data when a user enters particular Account Number. But always an empty form displays...:-( [CODE] <?php $connect=mysql_connect('localhost','root',''); mysql_select_db('bank',$connect); if( isset($_POST['account_number']) && !empty($_POST['account_number']) ){ exit(); } ?> …

Hi, In my system,when i submit my form there is a message comes as "A new account number 1 is created successfully. Thereafter when i try to click on the "refresh" button another new account number is automatically created. Can anyone give some piece of code to avoid that problem? …

Hi all, I want to add an amend functionality to my system. Therefore i need retrieve data from 2 different tables and display it in a single form. [B]account_details [/B]( [B][U]account_number[/U][/B], full_name,____) [B]account[/B] ( [B][U]account_number[/U][/B], name_with_initials,____) When i try to retrieve data from these 2 tables,output comes as an empty …

Hi, I want to delete erroneous transactions and at the same time update my account table to be in line with the transaction table. account (account_number, name_with_initials, accoount_type,account_balance, account_interest) transaction (tran_id,account_number,transaction_type,transaction_amount,transaction_date) First i create a page to retrieve data from the tables and then need to delete the erroneous transaction. …

Hi all, t to upload files to my server. Here i have created a coding. This only allows me to upload pictures. How can i amend my coding to upload word and excel files also... [CODE] <?php $db=mysql_connect('localhost','root',''); mysql_select_db('bank'); if ((($_FILES["file"]["type"] == "image/gif") || ($_FILES["file"]["type"] == "image/jpeg") || ($_FILES["file"]["type"] == …

Hi, I am creating reports in my project using [B]TCPDF[/B]. I want to get the reports on a daily basis. For an example if there are 10 transactions occurred in a day, i want to display them in a report format. These are the 2 pages that i have created. …

The below line generates this error. Can anyone gives me a solution Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\wamp\www\MySite\php files\approve_page.php on line 25 [CODE] $query = "UPDATE transaction SET approved_status='1' WHERE account_number='$account_number' AND tran_id='$_POST['tran_id']'"; [/CODE]

Hi all, I want to approve records in my page. For that i have created a search where data retrieves based on account_number. Now i want to approve records. For that i have created a page called [B]approve_page.php[/B]. But it seems to be applied for all the data. I just …

Hi all, I want to perform cash transactions such as cash deposits and cash withdrawals in my project.Here i have created a page called [B]transaction.php[/B] to fulfill those requirements.But there were few error which i need your help to sought it out.. [B]account[/B] (account_number, account_type, fd_period, account_balance, account_interest ) [B]transacion …

Hi all, The 2 tables are as follows. [B] account_details[/B] (account_number, nic, full_name, name_with_initials, phone_number, address, gender, date_of_birth) [B]account[/B] (account_number, account_type, fd_period, account_balance, account_interest) In my accounts opening form there are 9 fields. NIC, Full name, Name with initials, Phone number, Address, Gender, DOB, Account Type, FD period I want …

Hi all, I just know whether it will allow in php to store data in a sigle form into 2 tables, because i want to use these data in some other tasks. In my form there are 7 fields. They are [B]nic, full name, name with initials, phone number, address, …

Hi all, According to my project, if a customer opens an account he should be able to deposit or withdraw cash. This is my table structure. [B]account_details[/B] (account_number, nic, full_name, name_with_initials, phone_number, address, gender, date_of_birth) [B]account[/B] (account_number, account_type, fd_period, account_balance, account_interest) [B]transaction[/B] (tran_id, transaction_type, from_account, to_account, transaction_amount, transaction_date) I want …

HI all, I have a small problem regarding my php project. There is a page called [B]open_account.php[/B]. It contains all customer data such as NIC, full_name, date of birth, gender etc. When a user fills all the fields in that form it redirects to another page called [B]new_account.php[/B]. There are …