I have a modal that opens from a button which comes with the id of the post. This id stores it in an input type "hidden", in the modal.
My problem is having this field already loaded with the selected post id How can I filter data from a data...
Update ...
I have the following table:
CREATE TABLE 'chrislat_cms'.'opciones' (
'id' INT(11) NOT NULL AUTO_INCREMENT ,
'nombreOpcion' VARCHAR(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ,
'valorOpcion' LONGTEXT CHARACTER SE...
On the page when the user gives you to save changes in the form:
echo"<form id='contact' action='actualizar.php' method='post' name='actualizar'>";
echo "<fieldset>";
echo " Nombre:<span class='obligatorio'>...
How to create two subqueries in MySQL ? effectively and optimized.
The current code throws me the error #1241 - Operando debe tener 1 columna(s) from the phpMyAdmin .
The first subquery calculates the total number of availab...
I need to be able to modify a record using a table, but it happens that when I want to execute the action of the button, it sends me an error.
I had previously done a test with a table of 15 records or so and it did work, but when I tried to...
When the user enters correctly with the access data to the system, it registers in the database failed attempts in the following tables.
failed_attempt This table posts every failed attempt as a registered or unregistered user, all faile...
I am trying to send an email using the php library that is PHPMailerAutoload.php
The reason I use this library is to retrieve a user's password. NOTE: I am using gmail.
I have the code configured this way:
//Método getValor
function getValor($...
I'm doing this code:
<?php
$tempSQL = "CREATE TEMPORARY TABLE IF NOT EXISTS tempUsers
SELECT CONCAT(NOMBRE,' 'AP_PATERNO,' ',AP_MATERNO) AS NOMBRE,
EMP_ID, AREA FROM EMPLEADOS WHERE ESTADO = 1";
mysqli_query($conn,$tempSQL);
if(mysqli_affe...
I'm doing a query on the model of a web application in PHP with MVC . The idea is to make a query in which to put the value in empresa_id I see the total rows with that company, for this I used COUNT() in the query...