Sophia_1

Hi, tried to save the textbox color T11 based on rating value but unable to save. For example, if the rating=Good, the textbox color T11 =green. But when i click save, T11 color goes back to black and select option goes back to "Please select an option". T11 textbox color …

Hi everyone, am trying to import excel file to 2 tables using php but unable to do so. The 1st table is Kra (kraid,kra) and 2nd table Kpi (kpiid,kpi,kraid). The foreign key for Kpi is kraid. When i import the file the following message appears "Invalid File:Please upload CSV file.", …

Hi everyone, tried to display next and previous records from the coding below but unable to do so.It suppose to display next records for the current user with the when user click "Next" but currently it doesn't display "Next" but only display "Random". When i clicked "Random", it displays next …

Hi everyone, tried to display next and previous records using Next and Previous buttons but unable to do so. The record displayed is the current record whenever i click the Next or Previous buttons ie it doesn't move to the next or previous records. Below is the coding. Please advise. …

Hi everyone, am trying to display the next record with next button and previous record with previous button from 2 tables. But when i click next there is no record displayed eventhough there are records in the database. The same thing happens with previous button. Please advise. Thanks a lot. …

Hi everyone, am trying to display report based on quarter ie Quarter1,Quarter2 etc. However,after keying in record for Quarter2, the report below does not display Quarter2 record but still Quarter1 record. Please advise how to make the report display Quarter2 record if the current month is Jun etc. Thanks a …

Hi, am trying to display the filename after upload but can't display, instead error message "There are no files in the database" is displayed. Please advise. Thanks. <?php // Connect to the database $dbLink = new mysqli('localhost','user','','pq'); if(mysqli_connect_errno()) { die("MySQL connection failed: ". mysqli_connect_error()); } // Get the ID // …

Hi everyone, I have this issue, currently am able to save the attachment name in mysql database. However, after saving it doesn't display the attachment name in the form and so unable to open the attachment. Below is the coding. Please advise how to display the attachment name and open …

Hi everyone. Am trying to send email reminder for users to update their progress 1 month before end of every quarter. So every February and May etc the email notification will be autosend to the users from the system. Below is the code. Please advise if this is the correct …

Hi everyone, am trying to display current date/today's date in php but the output is as below. Please advise. Thanks. <?php $Currentdate2 = date('d-m-y'); echo $Currentdate2; ?> Output: Current date: 2027-10-15

Hi everyone, am trying to save excel/docs filename in mysql and then display the filename and open the file to edit. The filename can be save in mysql but unable to display the filename and open the file. Appreciate if you could advise. Thanks a lot. <div id="tabs-1"> <?php error_reporting(E_ALL …

Hi everyone, i wanted to upload an excel file in a form and then display/edit the file from the form. Currently, the file can be uploaded at localhost but when i try to upload in server it was not successful. I would also want to view/edit the file and save …

Hi everyone, I wanted to display different data from the same table in 2 different tabs in php. When i select the Responsible person and click Notify in tabs-1, it will be saved and displayed in the improvement_plan table. But when i select Responsible person and click Notify in tabs-2, …

Hi everyone, am trying to save and display the text color after select change in php and html. After selecting Selfrating1 ie "Good", the textbox T11 suppose to change to "Green" color. After submit button the text color supposed to be save in mysql and display on the form. The …

Hi everyone, i have this form with 2 divisions. I wanted to retain the current tab after saving records for example, after saving records in tab-2, the tab-2 suppose to appear/retain as current tab. Currently, after clicking submit button the tab will go back to tab-1. Please advise. Thanks. <form …

Hi, i have 2 tabs in one form. After inserting records in tabs-1 for quarter 1 progress, user then updates records in tabs-2 for quarter 2 progress, which is of the same row in the progress table. However when i click submit button or update button, no records are being …

Hi, i have problem to save record and send email in php. After selecting the responsible person, the system supposed to save the responsible person in the database and then send email to notify the responsible person on his progress. The coding is below but it doesn't work. Please kindly …

Hi, tried to update record in table and send email to the responsible person but no email is being sent. When current user select the responsible person from the option select and click Notify2 button, it suppose to update Responsible2 in improvement_plan table and send email to notify the Responsible2 …

Hi,tried to update the improvement_plan table with the records below but unable to do so, as the records are not updated. When i click submit button, no records are saved. Please advise? Thanks. <?php error_reporting(E_ALL ^ E_NOTICE); mysql_connect("localhost","user",""); mysql_select_db("p1"); $table="improvement_plan"; if(isset($_POST['submit'])){ // echo $_SESSION['Picid']; echo $_SESSION['Progressid']; foreach($_POST['Ipid'] as $value) { …

<?php $host="localhost"; // Host name $username="user"; // Mysql username $password=""; // Mysql password $db_name="pqa"; // Database name $tbl_name="improvement_plan"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // get value of id that sent from address bar $Ipid=$_GET['Ipid']; // Retrieve …

<script> function calculateText(el) { var form = el.form; var idx = form.Selfrating1.selectedIndex; if (idx <= 0) { form.reset(); return; } if (form.Selfrating1.value == "Good") { form.T11.value = "#008000"; } else if (form.Selfrating1.value == "Satisfactory") { form.T11.value = "#9ACD32"; } else if (form.Selfrating1.value == "Mixed") { form.T11.value = "#FFFF00"; } else …

Hi everyone,i have this mail notification whereby the receiver is selected from combobox. Upon combobox selection, the sender will click the submit button and the mail suppose to be sent to the receiver. But it seems that the combobox selection cannot be read.There is error message ie "Message could not …

Hi...i would like to save and edit some excel files located in server using php. The coding below upload the file but when i open the page again...the message 'no file chosen' appears. Please help on this matter...thanks a lot... <?php error_reporting(E_ALL ^ E_NOTICE); $_SESSION['Targetid']; $_SESSION["Progressid"]; $conn = mysql_connect("localhost","pqa",""); mysql_select_db("pq",$conn); …

Hi everyone...have this table as header and i want to display it in all 2 tabs ie Quarter tabs.Currently, the header detail is only displayed in Quater 1 tab...and eventhough i've use include (header.php) in Quarter 2 tab, the header detail is not displayed.Please advise how to display the same …

Hi everyone...i have this table ie `Kra,Year,Max(Rating1),Max(Rating2),Tot_Rating`...the task is to display the max occurence of rating.There are 2 types of rating ie "good" or "problematic"..if Max(Rating1)="good" and Max(Rating2)="good", Tot_Rating="good".Below is the coding but it didn't display as what suppose to...please advise...thanks a lot. <!DOCTYPE html> <html> <body> <?php $connection = …

Hi...tried to send email notification in php but not successful. When i check my email there is no email notification received. Below is the coding. Once the user click notify button, an email notification supposed to be sent to responsible person...Please advise...Thanks a lot. <?php error_reporting(E_ALL ^ E_NOTICE); $_SESSION['Targetid']; $_SESSION["Progressid"]; …

Hi,am new in php and appreciate your help in this matter....tried to save the record below into mysql database but couldn't.The field are blank and the Targetid field is always 0.Below is the coding...Please advise...Tqvm <html> <body> <form action="progress1.php" method="post"> <p> Quantitative Progress: <input type="text" name="Quanprogress1"></p> <p>Qualitative Progress: <input type="text" …