Questions tagged as 'mysql'

Tagged questions
2
answers

Query using INNER JOIN with problem

I am doing a query using INNER JOIN , but when I do the JOIN in the A table with the B and there is no id in the B table, it returns me an array empty. I would like it if it did not find the id in the...
asked by 23.04.2014 / 00:28
2
answers

Display column quantities in each table

As I do for phpmyadmin show me this: --- tabelas --- usuarios(5) clientes(20) admins(2) for example using some mysql command or even some phpmyadmin functionality?     
asked by 15.04.2014 / 23:15
1
answer

mysql workbench error [closed]

I'm trying to make a database for an academic project, I'm doing the model in the workbench and then I try to synchronize with phpmyadmin, it happens that when I do the foreign keys, the same error always happens, but I can not figure out what t...
asked by 31.12.2018 / 17:23
1
answer

Insert with three tables in MySQL with PHP

For purposes of study and testing, I have created three tables in phpMyAdmin: People , Contact , CredentialsLogin . The Contact tables and CredentialsLogin are related to People. The goal is to perform the insertion of records for the thre...
asked by 02.01.2019 / 20:13
1
answer

Maverick installation causes the server to stop working

I'm new to apples and recently bought a Mac book, with the Lion operating system. I installed php, mysql, etc and everything worked perfectly. Now I've upgraded the system to Maverick and the server has stopped working. When I type in the bro...
asked by 01.02.2014 / 13:05
1
answer

Returning error in insert function

Good morning. My function is returning an error, but I do not know what you mean, I used the Singleton pattern to do so I will post 2 codes: <?php class IndicadoDAO{ private $idIndicado; private $nome; private $e...
asked by 04.12.2018 / 14:18
1
answer

MultiTenancy application and structure

SaaS applications are on the rise, reducing costs, maintenance, etc. We know we have the concept: MultiTenancy ( link ) They are: By Column: Put an idClient column on all tables By Schema: Separate clients by schema, client1.contacts...
asked by 17.07.2014 / 21:28
2
answers

syntax criteria using yii framework

I'm having trouble performing where using criteria, I'm posting the code I'm doing and below the error .. Criteria Code $criteria->compare('id',$this->id); $criteria->compare('data_hora',$this->data_hora,true);...
asked by 17.07.2014 / 15:52
2
answers

UPDATE only on last inserted rows

I'm importing some Excel spreadsheets via ETL into a relational database. The problem is that for me to be able to perform the relationship of the tables, I am using queries for the insertion of the foreign keys. But as the bank grows, these que...
asked by 11.11.2018 / 05:10
2
answers

php Page Protection

I found a tutorial on how to make a login system ... More problem is that when I try to block the pages only for the login of users logged in does not work although the user is logged in, I think the error is in the page functions.php when the s...
asked by 12.09.2014 / 16:11