Questions tagged as 'mysql'

Tagged questions
2
answers

How to do in a select html, when clicking select more than one row at a time?

I have a query that brings me the first 3 letters of the name of a month with the last two digits of the year for example: JAN.16 in my combobox it brings me months independent for example: JAN.16 FEV.16 ... and on and on. I wanted the combob...
asked by 08.06.2016 / 17:39
1
answer

Find nearby restaurants registered in the database through google maps

I need some help. I have a PHP system with a mysql database with several registered restaurants, with fields like: id, name, address, longitude and latitude and I'm creating an application with Ionic using AngularJS. In this application I had...
asked by 28.02.2016 / 05:57
1
answer

Best DB structure with large number of data and filterable columns

I have a Mysql database with a table that is taking a long time to complete a query. I would like to know what would be the best database structure indicated for a table with many fields that are filterable, have more than 5 million records and...
asked by 14.11.2016 / 12:46
1
answer

Connection Problem with MySQL - Connection must be valid and open

I have a problem in a Windows Form in C # that uses DataGridView . The following is done: When clicking on a row in the dataGrid the information of the respective row, saved in a database, should appear in a group of TextBoxes and from it...
asked by 11.11.2016 / 17:12
1
answer

Problem adding column values and displaying in highcharts

I have the table: numitens | data | email 1 | 01/01/15 | [email protected] 1 | 01/01/15 | [email protected] 2 | 01/01/15 | [email protected] 1 | 02/01/15 | [email protected] The format you...
asked by 17.01.2015 / 23:52
1
answer

How to save the checkbox options in the bank?

I need to save the fruits and values in different fields in the database " PHP: <?php session_start(); //if (!isset($_SESSION["usuario"])){echo "<script>alert('O SEU INGRESSO É VALIDO');window.location=\"index.php\";</scrip...
asked by 14.12.2014 / 06:21
3
answers

DELETE FROM users WHERE user_id = $ id

I have a script of simple PHP + MySQL query: <table > <tr> <td ><h2>GERENCIAR ANUNCIOS </h2></td> </tr> <tr> <td > <table > <tr> <th >ID</th>...
asked by 30.01.2015 / 13:02
3
answers

Error creating a MySQL database via PHP in WampServer

I have a problem when creating the database, on the net I found little content about, only meeting how to mount database by phpMyAdmin, but it is via script that I want to create. > I have the following code: <?php $mysqli = new mysqli...
asked by 28.09.2014 / 14:52
3
answers

Verify Connection Existence with MySQL in PHP

I came across this question recently, how to check if there is an open connection to mysql? Everyone knows that in order to use mysql_real_escape_string need to have a certain connection, so I wanted to check if there is one, if yes then...
asked by 10.04.2014 / 15:49
4
answers

How to handle vectors in a MySQL database?

I have a supermarket carton application where after the end of the sale needs to insert a record with data referring to that sale in a table, this record should include the code of the products bought and the quantity of each. As I'm using a...
asked by 12.12.2013 / 14:13