Questions tagged as 'mysql'

Tagged questions
1
answer

Uncaught Error: Call to undefined function mysql_connect () [duplicate]

   Uncaught Error: Call to undefined function mysql_connect () the code looks like this: html:      <label>Nome</label><br /> <input type="text" name="nome" /><br /> <label>Idade</l...
asked by 20.08.2017 / 16:48
1
answer

Write multiple records from one table to another with php

I have two tables, a schedule with schedules and a related schedule call. tabela escala id_escala hr_inicio tabela agenda id_agenda id_escala hr_agendamento I want to record in the hr_address field in the scheduler table all the times in...
asked by 20.08.2017 / 08:47
1
answer

Query unique (dynamic) or personalized?

I'm developing a system and am trying to simplify my life with basic querys of insert and update , and I came across a question:    Should I create a query for each case, or one that meets all   cases, and do they have the sa...
asked by 16.08.2017 / 15:40
3
answers

How to do select MySQL using input date type with php?

I'm trying to list certain columns of the database by date but it does not work. Here'ssomecodesnippet:<?phpif($_GET['busca']=="data") { $datai = date('Y/m/d', strtotime($_POST['data'])); $nome = $_POST['nome']; $preco = $_P...
asked by 15.08.2017 / 22:46
2
answers

Check for existence of register with 3 conditions with PHP

I am new to PHP and I am trying to check if there is an equal registration in the database before registering, but so far, the problem is that I can not verify with 3 conditions in WHERE SELECT ex: SELECT * FROM datashowreserva WHERE DAT...
asked by 22.08.2017 / 22:17
1
answer

How to leave a mysql database online?

I have a database on my computer, but I need to share it with others. I am using the MySql database, and I need to access this database outside the network, on other devices. How to leave this database online and share it with other people? I ne...
asked by 23.08.2017 / 03:54
0
answers

MySQL full text does not find results with underscore

I'm using to implement a the problem is that words with an underline (ex: com_company_market.txt) are interpreted as one, is there any way to turn underscores into " separators" from words? like space?     
asked by 13.08.2017 / 21:37
1
answer

Delete record button

I have a page that shows the registrations made in a form. When a registration is required to be deleted, I need to access phpMyAdmin, preventing anyone other than me from deleting the record. What I wanted: I wanted to make a button...
asked by 14.08.2017 / 19:48
2
answers

Error: "Can not connect to local MySQL server through socket"

I just created a domain on locaweb and created a website and database. When I access the site, it loads part of the page, but I get the following error:    SQLSTATE [HY000] [2002] Can not connect to local MySQL server through socket '/var/...
asked by 09.08.2017 / 00:06
0
answers

Connecting to multiple banks with mysql loop

Good afternoon My question is about connecting to several databases in mysql for reporting I would like the annual result of the year 2016 in sales, with this I want to get the result of each month, but this would require a select for each...
asked by 09.08.2017 / 19:09