All Questions
18,416
questions
0
votes
1
answer
52
views
Mysql/html how to get output like this, or similar
PhpMyAdmin
Looking for output like this:
In Mysql/PHP, how can I get output like this, or similar (photo 2)?
$start = mysqli_query($conn, $sql);
if (mysqli_num_rows($start) > 0) {
$row = ...
- 19
0
votes
1
answer
39
views
Get data to display on a modal using Python, HTML and CSS
I would like this data to be displayed in my modal which rests on a template managehouses.html. the code that fetches the data from the database is
def housetypes():
cur = mysql.connection.cursor()
...
- 121
-1
votes
0
answers
21
views
Fix Error: This page isn’t working localhost redirected you too many times. Try clearing your cookies. ERR_TOO_MANY_REDIRECTS [duplicate]
This is the code to my login.php
<?php
// Include the database connection file
include('db.php');
// Start the session
session_start();
if ($_SERVER["REQUEST_METHOD"] == "POST"...
0
votes
0
answers
56
views
Php variable within html input
I wrote a large registration system in html/php/mysql many years ago. I had to upgrade a lot of code when php was upgraded. I have been having issues with passing php variables in html input. A ...
- 11
0
votes
1
answer
38
views
filter_input or FILTER_SANITIZE_FULL_SPECIAL_CHARS causing troubles with non-english language in PHPMailer
I am having problems with PHPMailer and no similar answer is helping me.
The problem seems to be in filter_input or FILTER_SANITIZE_FULL_SPECIAL_CHARS but I really don't know how to fix it.
Here is ...
- 21
1
vote
0
answers
37
views
Is it possible to user filter_input together with htmlspecialchars?
I am reading about FILTER_SANITIZE_STRING being deprecated so I am looking for the best option to filter inputs for security reasons to prevent mysql injections and xss injections too.
My users will ...
- 21
1
vote
1
answer
48
views
Trouble adding new data to mysql database when using HTML form onsubmit to call a JavaScript function
I am trying to get the users Email address to add it to an existing mysql data base, previously I used this HTML and PHP code which works and does add the data to the database both on my server and ...
- 43
-1
votes
1
answer
27
views
PHP date from MySQL format to swedish month. Error DateTimeInterface
I have a row coming from mysql query like this:
$date=$row['date'];
In MySQL this date is stored like this:
2024-12-28 (Y-m-d)
I want to display this date in Swedish language like this:
28 Maj 2024
...
- 21
-1
votes
1
answer
35
views
how to compare form request with mysql table data if exist
I am flask starter. I was trying to loop through my mysql table data to check if the data in my form exists or I insert the form request in the table.
This is what I have tried but it only keep saving ...
0
votes
0
answers
20
views
Only my first SQL statement is working, the following statements appear to be broken [duplicate]
I am a student creating a dynamic website for a school project and I'm attempting to implement a checkout button which selects all items from the basket and inserts each of them into a new order. ...
- 13
1
vote
0
answers
24
views
python flask and mysql database
please how can i retrieve an image from mysql database and display it in my html website
these are what I have tried:
app.py
@app.route('/customerDetails', methods=['GET', 'POST'])
def customerDetails(...
0
votes
0
answers
42
views
How to count the number of students from each course from the mysql database?
So, I want to make a calculator that will calculate this formula:
Result = No. of Attendance / (No. of Students * No. of School Days)
but I want the No. of students to be counted automatically by ...
0
votes
0
answers
33
views
I am making a web app with Flask/ Python, trying to show QR-code in a table, but it is not showing,
I am learning Flask/ Python, i got a problem i cannot resolve myself, i have also tried chatgpt but it says everything is correct (but its not working)
I make a webapp where you can type in your name, ...
- 59
0
votes
0
answers
31
views
Error message 'Column '<columnname>' does not belong to table .' [duplicate]
I am working on an html site. I'm using an SQL database. I have a session 'user' that I am trying to add a value to from my table. Whenever I try to run the program it says the column does not exist, ...
- 11
0
votes
1
answer
42
views
Using flask to link to mysql
My teacher gave me a task to link a form that takes name and email address made with flask and html. He said to link it to a database in mysql. This data base will store the information received from ...
- 9