What kind of colleagues I need your help, I have been alleviating an error that has overwhelmed me for many hours and I can not solve it before it worked but my PC formats and it does not work anymore, it sends me an error when I try to create a...
I am trying to update a "group" attribute of my process table, I do the relationship with the subprocess table which has as reference the idProcess of the process table, but it marks me an error when executing the query.
UPDATE P set P.grupo="...
I would like to know how I can perform a query prepare in mysql using the LIKE clause to filter
$stmt = $this->db->prepare("SELECT * FROM ARTICULOS WHERE DESARROLLO LIKE :search ");
$search_ = '%'.$name.'%';
$stmt->bin...
I just installed the whole Apache package together with PHP and phpMyAdmin. The problem is that when I try to log in I get this error:
# 1698 Access denied for user 'root' @ 'localhost'
and
mysqli_real_connect (): (HY000 / 1698):...
someone can help me with this:
I do not see the relationship view, I already added the foreign keys but it does not show me that view. Could someone help me?
Hello, I have a small user registration code but you are not inserting the data into my database:
conexion.php
<?php
$con = new mysqli('localhost','root','','coco');
?>
formulario.php
<!DOCTYPE html>
<html>
&l...
I have a problem when creating a trigger in phpmyadmin . This is my syntax in the definition field:
DECLARE n_ubicacion VARCHAR(45) DEFAULT '';
IF (OLD.id_ubicacion <> NEW.id_ubicacion) THEN
SELECT ubicacion INTO n_ubicaci...
Good morning, I have a problem, because I was using a website sending the data by GET and of course now I am aware of this and I want to modify it to POST so that the data is not displayed.
The GET data sent them via URL as follows:
<td>...
I have the database of DATA created in this format.
the code you use for the query is the following: only that the class table increases The column Bimester to demilitar the query.
<table class="table table-bordered table-striped t...
I am looking for a way to import an xls with rich text to the server database through phpExcel. Some cells in the file contain plain text and other rich text, with several formats in the same cell.
I have already checked the option getStyl...