10,932 Topics
| |
Hello I'm trying to create an update statement where it updates inlever_datum with a date from now + 7 days later I already have this case "0": //doesn't work $id = $_GET['id']; $date = date("Y-m-d"); $new_date = date('Y-m-d', strtotime($date. '+7 day')); // je moest '' eromheen zetten $sql = "UPDATE … | |
Hi, I need your help. I am a newbie in PHP and my update statement is not working despite seeing all the values from the console. My code for the bootstrap modal file: <!----------------------------------- modal begin --------------------------------------> <div class="modal fade" id="editmodal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div … | |
$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'>"; … | |
Hello , I have a program which show reports of students i habe multipile dropdown lists in my page and what the supervisor do is selecting what he wants to show first " for example students who live in usa " /ps i have multi dropdown lists /then my program … | |
hello i'm trying to schedule event from mysql in node js i know how to execute query (connection.query("select * from test") but how to do that in nodejs --------> CREATE EVENT IF NOT EXISTS reurring_event ON SCHEDULE EVERY 1 MINUTE STARTS CURRENT_TIMESTAMP ENDS CURRENT_TIMESTAMP + INTERVAL 1 minute DO INSERT … | |
[ { "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 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 … | |
Hello ... i have a table which has one button i need to send the id of that record in the table to the next page the will be directed to once i click the butoon i don't want to send it in the url ... so what i did … | |
$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(); | |
hello i am using node js and mysql and i am dealing with payment table and i wanna insert record automatically based on the date and perod for example i have student who will pay every week something so i wanna be able that insert record every week in my … | |
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, I am currently working on a banlist and I am thinking about which data type to choose for storing the IP address in the database. Will the Binary data type be ideal? | |
> 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 … | |
Been programming more than half my life and been in industry for over a decade. | |
Illustrate a database for the video club using a recent video club entities | |
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 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> … | |
I have managed to get blog posts displayed from each blog category but I want to limit it to 1 article from each blog category but unsure how to do it in the sql query I have, below is what I have so far (SELECT BP.postID,postTitle,postSlug,postDesc,postDate,postImage FROM blog_posts BP, blog_post_cats … | |
hi i just came here if theres someone who coudl help me with my problem whenever i add a new user this keeps on appearing\ "INSERT INTO teacher_info (firstname,middlename,lastname,gender,address,date_joined,username,password) VALUES ('John','Doe','Doenut','Male','New york USA','2021-06-11','john','admin') Fatal error: Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of … | |
I found this peaice of code to import a Access database table to sql server Private Sub btnImport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnImport.Click Dim fileName As String = "" Dim ofd As New OpenFileDialog If ofd.ShowDialog = Windows.Forms.DialogResult.OK Then fileName = ofd.FileName PerformImportToSql(fileName) End If End … | |
> 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 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 … | |
| I am trying to connect MySQL(8.0.25) and python(3.8) using mysql.connector but getting the error: mysql.connector.errors.ProgrammingError: 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Windows 10 same code working for pymysql.connect the code used: import mysql.connector as sql s=sql.connect(host='localhost' ,user='root', password='<correct password>) The password I entered is the one … |
--Hi DaniWeb. I have been doying bulk data Uploads from Excel Sheet to MySql data base and hence thought that I may need the reverse of this process and so Export MySql Tables into Excel Format for Backup purposes (I also will be happy for a better suggestion for a … | |
| Hello, so as the title says, I'm looking to include a Session Variable into a MySQL Update statement. I'm not exactly sure what I'm doing wrong, but I certainly know I am. I'm also fairly new to this, so that may explain it lol! Thanks in advance for your help. … |
I want to ask how to make when we press the value for the combo box. For other textbox can easily appear. So, the user can do input 2 times. Here I attach my code Private Sub combo1() conn.Open() Dim stringsql As New MySqlCommand("select * from supplier", conn) Dim dr … | |
Trying to have a script built that locks the content until user refers a friend to signup, then they are granted access. They have a set amount of time, as a timer counts down or their account is deactivated. Its for a game we are creating and want to use … | |
Hi its Huzaifa From Pakistan! i am a designer (web and graphic). want to learn **programming** |
The End.