Questions tagged as 'mysql'

Tagged questions
3
answers

How to relate tables in MySQL to more than one entity?

How can I relate a table (entity) to more than one entity in the MySQL database? following the following example ... I have the tables: fornecedores , clientes and telefones . fornecedores , may have more than one...
asked by 26.11.2015 / 02:11
2
answers

Working with directories to make a require in PHP

I have a page where I generate some information, stored in the Database. This page is within 5 folders: pasta1/pasta2/pasta3/pasta4/pasta5 . For SELECT to work, I need a require to connect to the bank. This file is in a directory...
asked by 26.11.2015 / 21:27
1
answer

Improvement in Chat application

I am developing a chat for my site where a user sends an invitation to the other user, if it accepts it will open and the system will be checking for new messages. For the system to do this, I use a while , and while it does not return...
asked by 04.12.2015 / 20:01
1
answer

Exporting my database to CSV with PHP

I created a code in php that performs a twitter search and saves the result (100 tweets) to a database. In this code, I also have the option to select all tweets from the database and export them to a csv file. However, if the tweet has a lin...
asked by 27.08.2015 / 22:11
3
answers

Json PHP and Mysql

I'm working on a personal project with an open database, and I need a JSON file from a MYSQL query, I've been trying to solve this problem for a few days now and I'm having a hard time getting the name of the My data. Example: I make a query to...
asked by 29.09.2016 / 01:45
1
answer

Select selecting the attendant below the average of calls

Good morning, These are trying to make a select to select only the attendants who have the number of calls below the average. It seems simple, but I'm not getting it, I've tried it in several ways ... I would not have to count the numbe...
asked by 21.09.2015 / 15:43
1
answer

Convert MySQL code to MySQLi [closed]

3 Errors are presented:    Notice: Undefined variable: save in C: \ xampp \ htdocs \ index.php on line 6    Warning: mysql_num_rows () expects parameter 1 to be resource, boolean given in C: \ xampp \ htdocs \ index.php on line 133    No...
asked by 24.10.2015 / 17:57
1
answer

Phonegap Serve, Build Phonegap and MySql

I'm developing an app using jquery mobile and phonegap . Question: Why when I test the application in 'phonegap serve' of node.js it works and when I download apk created by Buil Phonegap no? Example:...
asked by 22.10.2015 / 18:42
2
answers

How to generate a statement per month in the database?

I have to generate an extract in the database that is similar to the bank statement and present the cumulative balance. I have the following columns Data, Debito, Crédito. Data entry is daily but the statement I need is per month. 01/...
asked by 06.09.2015 / 00:58
2
answers

Write to two different tables using the same View

I'm doing a supplier registration, and I need to record it in one table and its address in another. I use a single view vendors.blade to fill in all the data. How can I separate this data to write them to their respective tables? Suppliers...
asked by 07.09.2015 / 00:22