39,326 Topics
 | |
| | $sql = "SELECT cl_id, cl_name, cl_service_description, cl_contact, cl_dept,status, expiry_date from contract_list"; $result = $conn-> query($sql); if($result->num_rows > 0) { while($row = $result-> fetch_assoc()) { echo "<td>$row[cl_id]</td>"; echo "<td>$row[cl_name]</td> "; echo "<td> $row[cl_service_description]</td>"; echo "<td>$row[cl_dept]<td>"; echo"$row[status]"; echo "<td>$row[cl_contact]</td>"; echo "<td>$row[expiry_date]</td>"; echo "<td></td>"; echo "<td><div class=table-data-feature>"; echo "<button class='item' data-toggle='tooltip' data-placement='top' title='send'>"; … |
| | <?php require('cns.php'); $conn = mysqli_connect("localhost", "root", "", "cns"); if ($conn-> connect_error) { die ("Connection failed:". $conn-> connect_error); } $sql = "SELECT cl_id, cl_name, cl_service_description, cl_contact, cl_dept,status, expiry_date from contract_list"; $result = $conn-> query($sql); if($result->num_rows > 0) { while($row = $result-> fetch_assoc()) { echo "<td>$row[cl_id]</td>"; echo "<td>$row[cl_name]</td>"; echo "<td> $row[cl_service_description]</td>"; echo … |
| | Please let me give more details $datetime1 = new DateTime($orderdate); $datetime2 = new DateTime($currdate); $interval = date_diff($datetime1, $datetime2); $interval->format('%m months'); $months_diff = $interval->format('%m months'); for($i = 1; $i <=($months_diff+1); $i++){ $totalFees = $fees + $totalFees;  |
| | Hi there, I have been a developer since 1999 but I was in an auto accident and have a severe traumatic brain injury which hasn't helped me write php code at all...LOL But I'm still here and trying. I need some help with file uploading in php. It's giving me … |
| | Hello. My name is Eben and I'm a beginner in php. I've been getting this error message "Notice: A non well formed numeric value encountered in C:\wamp64\www\Project\FeePayment.php on line 145". This is the code; for($i = 1; $i <=($months_diff+1); $i++){ $totalFees = $fees + $totalFees; Please I need help.  |
| | [ { "regionCode": "0", "": { "amount": "291377681.35999995", "kwh": "5589027.089364664", "numberOfPay": "43876" } }, { "regionCode": "3", "AZARE Region": { "amount": "13494424.550000023", "kwh": "286885.42398979055", "numberOfPay": "3863" } }, { "regionCode": "7", "BAUCHI Region": { "amount": "55739882.11", "kwh": "1297297.378804144", "numberOfPay": "11199" } }, { "regionCode": "5", "BUKURU Region": { "amount": "77074190.08000007", …  |
| | I have a problem to do price data and i don't know to insert it into the coding this is question  this is the coding that i have made <?php $page_title = 'Yoho Express!'; include ('includes/header.html'); ?> <form action="q2.php" method="post"> <p><h1><fieldset><legend>Enter your information in the form below:</legend></p></h1> <p><b>Departure day:</b> … |
 | Good morning, i have a section in a php page as per code: <div class="container section" id="afterHeader"> <div class="row"> <div class="tabs movies"> <a class="style1">1^ WEEK</a> <ul> <li><a href="#thu">GIO</a></li> <li><a href="#fri">VEN</a></li> <li><a href="#sat">SAB</a></li> <li><a href="#sun">DOM</a></li> <li><a href="#mon">LUN</a></li> <li><a href="#tue">MAR</a></li> <li><a href="#wed">MER</a></li> </ul I would need to replace the part <ul> </ul> … |
 | Hi, I've been trying to troubleshoot this iframe issue all day. I need help. First, the issue is an iframe on the frontpage is to load a php script for an Video ad. Second the frontpage is a php search script. Now, when you visit the frontpage initially everything is … |
| | I moved my website from host to another, moved database and public_html file, Also, I modified wp-config file and deleted hlaccess. But, now I can't update any plugin or delete there is message said update_option( 'siteurl', 'https://zone1on.com' ); update_option( 'home', 'https://zone1on.com' ); Skip to main contentSkip to toolbar At the … |
| | $company_id = $_SESSION['compid']; $sql="SELECT * FROM `movies` WHERE companyID = ? AND name LIKE '%$search%' OR description LIKE '%$search%' " ; $stmt=mysqli_stmt_init($conn); if (!mysqli_stmt_prepare($stmt,$sql)) { header("location:main.php?error=stmt failed"); exit(); } mysqli_stmt_bind_param($stmt,"i", $company_id); mysqli_stmt_execute($stmt); $result = $stmt->get_result(); |
| | |
 | Hi I have mysql table as below id | item_id | date | received Now I want to make a html table from above data where columns are year and rows are months. and value will be sum of received on month _ year. like below demo | | 2018 … |
| | > Hi guys, I blinked and got lost. All I want to do is copy Payfile to Pmtfile and then update records in Payfile that have been paid(amtpaid !=''). The update doesn't happen and the insert-note comments at botom of post. <?php $link = mysqli_connect("localhost", "root", "", "prerentdb"); // Check …  |
| | I have learning this from youtube,php quiz using ajax. I am facing problem when click on next button after last question it is not redirecting on final page. Please help me to fix this. I think responseText not working. Question.php page to where i display question <script type="text/javascript"> var questionno="1"; … |
 | From the below, how can I make the variable $new_status recognisable within those brackets? $sendData = '{ "messages" : [ { "content" : "Your order is $new_status.", } ] }'; Problem: The above sends out text message successfully on status update, but the variable $new_status does not get updated. I … |
| | How can I build a responsive mobile app with PHP as a web developer, I'm a newbie in web development please and I wish to maintain apex growth in this field |
| | I need to add variable called $new_status, but its not being recognised on php, any suggestions. $sendData = '{ "messages" : [ { "content" : "Your order is $new_status.", } ] }'; |
| | Hi. I got some problem. I want to search data from 2 tables in database and display the result based on the search value. For example, I search employee id number, it will search the employee id number in table 1 and table 2. If the data exist in either … |
| | I want to know the logic of how to creat a program for converting a string number to a sentence, each number represent a alphabet, number are seperated by space. and words in a sentence are seperated by Plus + character. 1=A 2=B ...... 26=Z and the example input is … |
| | I have a database that has columns called start date, start time, end date and end time and want to be able to output the difference so it shows the total time spent per project. Below is the code I have but it shows the error PHP Fatal error: Uncaught … |
| | <?php $name = $email = $password = $repeatpass = ''; $name = $_POST['name']; $email = $_POST['email']; $password = $_POST['password']; $repeatpass = $_POST['repeatpass']; $con = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); $sql = "INSERT INTO user-regis (name, email, password, repeatpass) VALUES ('$name', '$email', '$password', '$repeatpass')"; $result = $con->query($sql); if (!$result) { header("Location: … |
| | <?php require_once './includes/config.php'; $con = new mysqli(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME); $sql = "SELECT * FROM contact-info"; if($result = $con->query($sql)){ while($row = $result->fetch_object()){ //display record 1 by 1 printf(' <tr> <td>%s</td> <td>%s</td> <td>%s</td> <td>%s</td> <td>%s</td> </tr> ',$row->id, $row->name, $row->email, $row->phone, $row->comment); } } printf(' <tr> <td colspan="5"> %d record(s) returned. [ <a href="insert-student.php">Insert Student</a> … |
| | HI, CAN I GET SOME HELP RE-WRITING THE BELOW. CODE 2 REFERENCES CODE 1 USING $sendData VARIABLE. I WOULD LIKE TO REMOVE CODE 1 COMPLETELY. CAN I GET HELP WRITING CODE 1 INTO CODE 2, PERHAPS IN FORM OF ARRAY? CODE 1 $sendData = '{ "messages" : [ { "content" … |
| | Hello please help me troubleshooting the problem below. I got the 500 Internal Server Error in My WP Site>Dashboard>Appearance>Custom.. Pleaaaaase. Below is the error shows when i check the document on Cpanel>File Manager>home3/faithcr4/public_html/error_log... [07-Aug-2021 07:15:40 UTC] PHP Warning: Cannot modify header information - headers already sent by (output started at … |
| | > Hi, This little program checks to see if the contract is valid. I have a database field "expiry" (int 3) from which 1 is subtracted when run. As long as the expiry is above 0 I want to redirect to "sysnav.html", otherwise I want to redirect to "expiredpage.html". I … |
| | i need to show the image displayed in database but it shows default image <?php $link = new PDO("mysql:host=localhost;dbname=campusdrive", "root", ""); $link->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $Sql = "SELECT Image FROM student_form WHERE Sessionid = :Sessionid"; $stmt = $link->prepare($Sql); $stmt->bindParam(":Sessionid", $sessionid, PDO::PARAM_STR); $sessionid = session_id(); $stmt->execute(); $count = $stmt->fetchAll(); if($users = $stmt->fetchColumn()){ echo … |
| | [ { "": { "amount": "152870", "kwh": "0", "numberOfPay": "54" } }, { "AZARE Region": { "amount": "119500", "kwh": "0", "numberOfPay": "45" } }, { "BAUCHI Region": { "amount": "944473", "kwh": "0", "numberOfPay": "376" } }, { "BUKURU Region": { "amount": "494000", "kwh": "0", "numberOfPay": "138" } }, { "GBOKO … |
| | I am trying to output data for selected dates and think I have managed to do the sql query but it's currently not outputting the total amount, below is what it is currently outputting I am looking for the following From To Expense Category Expenses Total 01/01/2018 31/12/2018 Accounting Costs …  |
| | Hi guys. I have just created an intranet in my online store and I'm new at programming so need some help. I'm developing a system that makes this possible: when a user registers, the database detects that they are already a customer who has bought previously and it makes their … |
The End.