Questions tagged as 'mysql'

Tagged questions
0
answers

More than one query on a very slow request on the first request in C #

I have a method that requests data to the bank and in this same method I call another method that also requests the bank (mySql). public class Viagem { public int idViagem { get; set; } ... public Cidade origem { get; set; } publ...
asked by 05.06.2017 / 19:06
1
answer

UPDATE with AJAX

I'm doing an AJAX which, after the user selects a checkbox and sets a status (status is select ), AJAX gets the information and sends it to a page called status.php where the status change is executed different query that will chang...
asked by 17.06.2017 / 20:54
1
answer

Failed to install MySql Server 5.x on Windows 10 (64bit) [closed]

Good evening, I'm trying to install MySql Server 5.x (32 and 64bit) on Windows 10 (64bit), but in the middle of the installation the process is aborted with the following message: '... there is no MySql Server version available ...' Can...
asked by 19.06.2017 / 04:16
1
answer

Get the PK from one table and Insert As FK into another

I have an inheritance in my work and I'm having trouble making it work. Tables Example CREATE TABLE IF NOT EXISTS pessoa ( idpessoa INT NOT NULL AUTO_INCREMENT, tipopessoa VARCHAR(45) NOT NULL, PRIMARY KEY (idpessoa) ); CREATE TABLE IF NO...
asked by 18.06.2017 / 01:01
0
answers

The Map (google maps API - javascript) stops working when I add a function in the script!

The map to appear when I put the AllLink function, when I remove it the map will appear again as always var map; var markers = []; function initMap() { map = new google.maps.Map(document.getElementById('map'), { center: {lat: 7...
asked by 25.06.2017 / 02:58
1
answer

Get Mysql Data Using Php and Pass to JavaScript

I'm using this code: <?php include '../config/config.php'; if($_POST['type'] == 'load_url') { $id = (int) $_POST['id']; $sql = mysql_query("SELECT * FROM players WHERE id='$id'"); $item = mysql_fetch_arr...
asked by 25.06.2017 / 15:37
1
answer

How to run a Query in Azure?

I have a PHP WebService type SOAP in Azure and I'm using MySQL in App. The database is up and running ... but I can not execute a simple Query! Where is the error? <?php $connectstr_dbhost = ''; $connectstr_dbname = ''; $connectstr_dbusern...
asked by 31.05.2017 / 18:18
1
answer

Relationship between four tables

Good afternoon, guys. I changed the diagram of a bank I had and now I need a help to select correctly. I have four tables, where: 1 - Faculty 2 - Training 3 - Coordinator 4 - Instructor From the faculty, any data can be instructor or co...
asked by 31.05.2017 / 21:13
1
answer

Insert multiple PHP PDO values

I want to insert multiple values into the table, for each reported parcel quantity. It's all right, it works, however .. I need every time the expiration date has the month added up. The code below: $response['status'] = ""; $response['html']...
asked by 09.06.2017 / 06:05
1
answer

Problem inserting into the database by java

I'm trying to make an app from a veterinary clinic and I followed all the right steps to create the database, connect with the eclipse, and so on. The program connects but does not enter anything that was entered into the program in the database...
asked by 23.05.2017 / 01:33