This is the select of my table, the query I'm using follows in the image below:
It brings the normal result, but I wanted it to bring it this way:
| Id_Unica | Pixel | Inch | Quantity |
18 1080p 15 2
Can it be personal?...
I can fill a combobox with DataTable, but in my case I need to fill 2 combobox and 1 checkedboxlist with data from a MySQL bd
//formulário cadastro
private void frmCadastroRecibo_Load(object sender, EventArgs e)
{
Classes.DBconect con = ne...
I wanted to know how I can enter data in MySQL via Ajax + PHP using the Zurb Foundation 5 Framework? Does the "data-reveal-ajax" property of the framework already override an insert Ajax function?
After I created the project with the command composer create-project --prefer-dist laravel/laravel laravel-scout I made the following changes in the .env file
DB_DATABASE=course
DB_USERNAME=root
DB_PASSWORD=1234
Then I created the...
I'm getting the following error when time to perform a query to insert data into a table in the database:
You have an error in your SQL syntax; VALUES ('Refined Sugar', '2', '') 'at line 1
My code:
<html>
<head>...
Does anyone know how to tell me some program to manage database > in Windows?
On Mac I use one called Sequel Pro , however it is Mac only.
Does anyone know of any similarities?
I would like to know how to write a SQL for control purposes of the statement being sent to the database:
$sql = $pdo->query("SELECT * FROM imovel WEHRE CATEGORIA = 'APARTAMENTO'");
How to print the SQL statement being sent to the bank?...
In MySQL, when we are going to make a SELECT , we can usually specify each field we want to return.
SELECT id, nome FROM usuarios
However, let's imagine a scenario where I have 50 columns in a table and I did not want the senha...
For example you have in the table the values: green, red, blue, blue, pink, pink, pink, yellow. I would need to return from the table colors only once blue and pink. Do you have any way to do this?
How can I pass a php page to a selected checkbox list, I have this that shows me the checkboxes, but I'm having trouble sending them to php.
function SelecionaChecks() {
var Check = document.getElementsByName("check");...