No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
50 Posted Topics
 | 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 … |
| | Hi all, I have created a registration form and a login form. But it is not working. The data would not go into the database. Can anyone show me the error. I have posted my pages and database structure. [B][U]registration_form.php[/U][/B] [CODE] <hr /> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" … |
| | Hi all, I am developing a MIS for a bank.There i want to create various types of accounts and i want something like this to be done. Ex: Account type Account Number A 1001, 1002, 1003, etc B 2001, 2002, 2003, etc C 3001, 3002, 3003, etc Likewise i want … |
| | Hi all, I want to validate username and password in the [B]same page where login form exists[/B]. I have this coding and if username and password not matches it redirects to "try_again.php" page. Instead of that i want to show the validation ( "Invalid username or password") in the same … |
| | Hi, I want to [B]add interest based on daily basis[/B] to my account tables. This is my account tables. shakthi(ID, account_type,full_name, balance, interest). There are another 3 tables which includes same fields. The amount is credited and the balance is updated very well. But interest should be added daily. I … |
| | Hi guys, I have a problem. When i want to logged out from the system or close an account etc i want to display this message.[B] " Are you sure you want to logged or something like" and "Yes and " No" buttons[/B] are there. How this can be achieved?? … |
| | Hi all, I have a form contains customer details. The text fields are filled with data values, which retrieve from the database ([B]customer table[/B]). There is a [B]button [/B]below the form called "[B]Modify[/B]". If user clicks on this button the user should be able to modify the details if he … |
| | Hi guys, I want to search customer details based on National ID. The customer table is related to this.The structure of the table looks like this. customer(customer_id, nic, full_name, name_with_initials, address, contact_number, gender) customer_id is the primary key of the table. When the user types the National Id (nic) of … |
| | Hi, My transaction table looks like this.It includes following fields. [B]tran_ID,account_type,account_number,transaction_type,amount,Date[/B] The records regarding each transaction is stored in this table. I want to know how i [B]retrieve the data[/B] from this table into another form or table.The coding is what i want... My actual purpose would be to allow … |
| | Hi guys, In my projects i handle cash transactions. Whenever user enters transaction details it stored in the transaction_table. This is my 5 tables relevant to this. transaction_table(tran_ID,account_number,account_type,transaction_type,amount) savings_investment(ID,account_type,full_name,balance,interest,customer_id) shakthi(ID,account_type,full_name,balance,interest,customer_id) surathal(ID,account_type,full_name,balance,interest,customer_id) abhimani_plus(ID,account_type,full_name,balance,interest,customer_id) If the user enters wrong amount, the supervisor of my system wants to correct it immediately. so far … |
| | Hi, I have a problem. i want to show the [B]current date and time[/B] in my tables of the database. I want to show it because i want to show it on my report generated in php. By the way i [B]do not[/B] have a "date" field in my form. … |
| | Hi, I have 4 account type tables. savings_investment(ID,account_type,full_name,balance,interest,customer_id) shakthi(ID,account_type,full_name,balance,interest,customer_id) surathal(ID,account_type,full_name,balance,interest,customer_id) abhimani_plus(ID,account_type,full_name,balance,interest,customer_id) The ID is different from one table to another. That is why i created 4 tables rather than one table. I want to write the coding to [B]check account balances[/B]. That is if user types the ID and clicks … |
| | Hi, The supervisor of my system wants to modify customer details. I created this modify_form.php page. But when i modifies one record of a particular customer it [B]affected to all the records[/B]. Therefore all the records contain same thing..... Can anyone give me the correct coding which modifies only that … |
| | Hi guys, This is very important. The supervisor of my system wants to close accounts which contain zero balances for long time periods. There is a separate page contains [B]ID and Account Number[/B].This is included in a form and a "close account" button is there. When he clicks on that … |
| | Hi guys, this is very urgent. Can anyone help me out..... I want to generate reports using php and MySQL. I have one table which includes customer_id, full_name, name_with_initials, address, contact_number and gender fields. I want to print the details of all the records of the table. It should be …  |
| | Hi all, I have created several validations to my forms in the web site.If a particular field is empty then a message box displayed [B]"Please enter name/address/contact number etc[/B].At the same time if I added data successfully to the database there is a message box displaying and saying [B]" Data … |
| | Hi guys, I have a small problem here... There is a [B]customer id[/B] field and a [B]search button[/B] in one page. In my database there is a [B]table[/B] called "[B]customer[/B]" which contains fields of [B]customer_id, full_name, name_with_initials, address, contact_number and gender[/B]. The table is filled with record of each customer … |
| | Hi all, Here i have a serious problem. I want to sought it out using [B]PHP and MySQL only[/B]. I have a form includes fields of customer id and Account type( [B]stored in a jump menu and includes 6 different types of accounts[/B]) [CODE] <style type="text/css"> <!-- body,td,th { font-size: … |
| | Hi all, This is regarding part of my project. There is a junior staff member who adds data to the database by way of a form.(customer details) Thereafter a supervisor should logged into the system and if he needs he should be able to modify the details entered by junior …  |
| | Hi, I want to retrieve data from my database and display it in a particular form. The data should be displayed in text boxes. This is the coding that i have used. But it is not working. Can someone help me out...... [CODE] <?php $connect=mysql_connect("localhost","root",""); mysql_select_db("bank",$connect) or die ("could not … |
| | Hi, I want to retrieve data from my database and display it in my form. How can i do that? i mean the php coding of the process. Thanks, Heshan. |
The End.