[mysql] Forum Topics

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. …

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**

HI!! How can I create an automatic numerical progression from 0 to 500,000 in html? The code I was given is this: <p><span style="font-family: Calibri, sans-serif;"><span style="text-shadow: rgba(255, 255, 255, 0.8) 0px 3px 2px;">⁴³⁷</span></span></p> how can i make the code progressive and automatic every three minutes? The progression I have …

Hi, the scenario is: I run an apartment complex, someone comes in to pay their rent. I fill in an html form to record payment(update "payments" database table) and print a receipt. I hope u will look at it and offer advice. I hope to combine both the payment and …

Find product who hasn't had any sales in first three months of the year?

Greetings.

Im a Computer Science student from the University of the Republic of Zimbabwe. Im an aspiring Data Scientist who is interested in leveraging in the power of Artificial Intelligence to address and solve our daily life problems. i am looking for opportunities to expose, improve and expand my skillset and …

Hi Guys, Im not sure how to word the title of this question, but i have a table called "daily_recyclables". Inside this table, i have multiple columns of recyclable materials (example copper, stainless steel, brass etc etc) In my PHP application, i have a statistic card (like below) that is …

In my workplace, we have an intranet website developed internally that we use for CRM. The data of our clients are shown there (MS SQL server is used as a backend to store data). The site has a limited search functionality at the moment (it'll try to match the text …

Write the main such that it reads two integers: Start and End and calls the void function of part ‘a’ in order to print the average of integers divisible by 3 in the range: [Start..End].

hello, i need someone to tell me how do i read string in assembly 8086 (nasm) and it would be better to write down the code ~~ thank you

It has been a few years since I actually did real coding... well a few years since i had a job for that. Just dumping about 1000 photos from a directory and want to display them. No magic of fancy stuff. Thanks