Questions tagged as 'phpmyadmin'

Tagged questions
1
answer

Please help me with this problem Err # 1235

First of all a big greeting, my problems are this: I have two different "secondary" tables linked to a "main" table, which I want to update when a record is inserted in the main one. This is my code: INSERT INTO Secundaria1 (a1, a2, P_ID) V...
asked by 01.03.2018 / 20:02
0
answers

Do not insert all the fields in my BD

<?php $turno = $_POST['idctg_turno']; $entrada = new DateTime($_POST['hr_entrada']); $salida = new DateTime($_POST['hr_salida']); $arraydia = $_POST['idctg_dia']; $mysqli = new mysqli("localhost", "root", "", "admon"); if ($...
asked by 22.02.2018 / 10:04
1
answer

Why this error comes up: Uninitialized string offset: 1 in line 13

<?php require("connect_db.php"); foreach($_POST['idctg_dia'] as $index => $value) { // $value tendrá valor desde 1 (lunes) hasta 7 (domingo) $entrada = $_POST['hr_entrada'][$index]; $salida = $_P...
asked by 17.02.2018 / 08:54
1
answer

Error in SQL order: Delete where id in list

I'm trying to delete the rows of a table that correspond to the id (varchar) '938110842071146496', '938110904666853378', '938195226333777920', '938309442671665152', '938777508123734017' For this I use the following SQL command: DELETE FROM...
asked by 04.03.2018 / 16:45
1
answer

Why does not this trigger insert anything in any of the two tables?

The syntax does not mark any error which means that I have bad logic, the problem is that I am new in phpmyadmin and I do not know very well if I place the if correctly DELIMITER $$ CREATE TRIGGER VALIDADOR BEFORE INSERT ON validacion...
asked by 07.03.2018 / 20:16
2
answers

what kind do I have to put in MySQL to get two values

I'm extracting data from a web page and saving it in my database (MySQL) but I have a problem, I have a data that is 40:20, that is, they are two separate numbers with two points and I do not have to type (DECIMAL or FLOAT) so that when I...
asked by 15.02.2018 / 11:12
0
answers

Do not load me page by php

I am trying to load a page when I pass the control of the login before I did it but now I do not load it and I do not know what is the code. This is the PHP code <?php session_start(); include ("conex.php"); $usuario = $pass = "...
asked by 14.02.2018 / 17:49
1
answer

Product check in Wordpress [Woocommerce]

Good morning community StackOverflow, I have some doubts because I want to make a check in PHP on the Wordpress platform, in the table wp_posts . I want to check if the title of a product exists. But how should I proceed to perform a check, for...
asked by 07.02.2018 / 09:36
2
answers

I can not find the right sql query

I have a question in which I need to know the number of updates since the last time a user enters a thread . Each time a user enters a thread, the following query is executed: INSERT INTO visita_post ('postId', 'nick', 'fecha_ultimo_acceso...
asked by 08.02.2018 / 15:45
0
answers

PHP - I do not work fetch_all (MYSQLI_ASSOC)

Fatal error: Uncaught Error: Call to undefined method mysqli_result :: fetch_all () in C: \ MAMP \ htdocs \ gdlwebcamp \ index.php: 76 Stack trace: # 0 {main} thrown in C: \ MAMP \ htdocs \ gdlwebcamp \ index.php on line 76   getMessage ();   ...
asked by 29.04.2018 / 04:17