All Questions
1,589
questions
-2
votes
1
answer
121
views
Mysql Keeps deleting the written ID but the ID Doesn't exist in Database
I have created a HTML form where you can delete the staff just by putting the ID which is directly connected to the database.
When I put the ID first time it will delete it if its existing but even if ...
- 1
0
votes
1
answer
41
views
Cant make user following script work accordingly
I feel like I'm missing out on something so little. I can't seem to logically understand how to display whether they are followed or not at the moment. I am able to insert and delete the rows whenever ...
- 77
-2
votes
1
answer
600
views
how to block bad words in php input form [duplicate]
i have a feedback form in a website (created for school). but input are coming bad words and bad links. what will do next
(website page in php).
i need like when anyone entering the bad words then ...
-1
votes
1
answer
39
views
Get the id before the current one
I have the following code to have as a result the id previous to the current one, I do not use any calculation such as adding one or subtracting one because sometimes I have skipped ids, for example, ...
- 21
-4
votes
1
answer
265
views
How to fix when a Variable is NULL? [duplicate]
I would be really grateful if someone can help me solve this. I just want the data to be displayed from the database, but this error keeps on happening.
The variable is Null, I have checked it using ...
-5
votes
1
answer
51
views
Automatically show selected value
There are two separate tables for users and roles. So for the roles would have a number between 1~7 and would have different roles depending on each users. We are trying to create a dropdown for when ...
- 3
-3
votes
1
answer
164
views
php only displaying first result from sql query [duplicate]
I'm very new to PHP and I'm trying to get some code that someone else has written to work. As the title says it is only showing the first result when it should be displaying many and I have no idea ...
- 1
0
votes
1
answer
599
views
How to fetch data with same id in a row but different value in another column and display one month into table in php
I have the following data in MySQL table:
emp_id
date
shift
1001
2022-08-01
M
1001
2022-08-02
M
1001
2022-08-03
N
1002
2022-08-01
M
1002
2022-08-02
E
1002
2022-08-06
M
Output should be like ...
0
votes
0
answers
17
views
Trying to combine 2 tables of data to show a list across multiple queries in PHP Attempt 2 [duplicate]
I am trying to combine 2 tables of data. However, all of my results were getting stuck in one set of results. I need the results to go across multiple. Someone posted a reply to that post with a code ...
0
votes
1
answer
194
views
how can i store data in dynamic field using php and mysqli
I am creating a dynamic resume form in which I have created dynamic add remove field with the help of java script but I am not getting any idea to store the input values of this dynamic form in ...
-2
votes
1
answer
707
views
Get value of html text field using sql query with php
LOGINPAGE.html:
This is where the user will input their username and password. PHP method is POST.
<html>
<head>
<title>
LOG IN
</title>
<style>
body {
text-align: center;...
- 5
0
votes
0
answers
11
views
Problem displaying incoming text from mySql using php [duplicate]
This utf8 problem bothered me again
It's ok on the other pages, but it can't show it on this page
I tried the following methods but it did not work
mysqli_query($conn, "SET NAMES utf8");
&...
- 322
0
votes
1
answer
47
views
PHP How to choose which table to display and then keep that table displayed after a form submission
I'm trying to use an HTML dropdown form in order to let the user choose which table from the database to display. This part works fine, but I want them to be able to add to whichever table they ...
- 19
1
vote
0
answers
30
views
Quotes utf 8 not rendering on html [duplicate]
I'm reading others references on stackoverflow
for add <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> under head
but as you can see on frontend the ...
- 1,048
0
votes
1
answer
277
views
Combine multiple columns values to one label in chart.js
My table(tb_ticket) which like this :
technician_1
Technician_2
Ema
Ema
Tom
Ema
Lisa
Tom
Ana
Lisa
Tom
Tom
My question is how to make it like this :
Ema=3, Tom=4, Ana=1, Lisa=2
My query
<...
- 1