Questions tagged as 'mysql'

Tagged questions
0
answers

Is there a limit of simultaneous SQLite PHP connection? [closed]

I currently use Mysql on my server with 50 concurrent connections limit. I thought of using SQL Server which in turn has no concurrent connection limit but is very expensive !! .. So I thought about using SQLlite, but would you like to know i...
asked by 02.09.2018 / 01:06
1
answer

Register and display image in database with PHP [duplicate]

Hello, I would like to know how I can register an image in the database and how do I display it there, I searched the internet and saw that the field in the database has to be as longblob or has a varchar poderser, as I watched in a tutorial i...
asked by 03.09.2018 / 20:22
2
answers

Foreign key FK, is each ID number in a table?

Example: - CLIENTE(Num_cliente, Nome_cliente, Cidade) - PEDIDO(Num_pedido, Data_pedido, Num_cliente, Preco_total) - ITEM_PEDIDO(Num_pedido, Num_item, Quantidade) - ITEM(Num_item, Preco_unitario) - EXPEDICAO(Num_pedido, Num_deposito, Data...
asked by 03.09.2018 / 02:56
1
answer

How to get the latest releases from an inner join

Personal to doing a query in 3 tables with inner join, follows the code: select itensVenda.idVenda, itensVenda.idProd, itensVenda.qtd, produtos.id, produtos.descricao, produtos.foto, venda.id, venda.valor from prod...
asked by 30.08.2018 / 22:41
1
answer

Make INNER JOIN on two different bases

I have 2 different MySQL databases, I can do a query on a base or another specifying which connection I'm going to use like this: $result1 = mysql_query($sql1, $banco1); $result2 = mysql_query($sql2, $banco2); Now a problem has arisen, I ne...
asked by 24.08.2018 / 16:09
0
answers

Panel to hide elements PHP user page

Good evening, I'm doing a management system for the company and now there has appeared an unanticipated requirement that I need to adjust. Within the administrative page of each client there are buttons that are actually images that when clickin...
asked by 23.08.2018 / 04:18
1
answer

Search the Database (Mysql) and create Sitemap in parts (PHP)

I have the following code to generate sitemap: <?php header("Content-type: text/xml"); echo'<?xml version=\'1.0\' encoding=\'UTF-8\'?>'; echo' <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:xsi="http://www.w3.o...
asked by 18.09.2018 / 03:48
1
answer

Query with field as value of IN

I'm trying to do a search using INNER JOIN in the service table , the agenda.serv_id field is a string "vector" and its value in the database is: 1, 2 ' I did 3 insert's in the service, the only problem is that IN only works whe...
asked by 01.10.2018 / 03:50
1
answer

HTTP (Post) Bad Request 400 - How to solve?

I am making a post, but my server is not sending an error (400). Below is the server code. const express = require('express'); const app = express(); const bodyParser = require('body-parser'); const mysql = require('mysql');...
asked by 28.09.2018 / 21:48
1
answer

Error - C # string for Crystal Report

When trying to pass the string from C # Windows Forms to Crystal Report following the procedure of the second image and the code below the crystal report shows the following error! Visual Studio Community 2017, Mysql free and Crystal Report Sap....
asked by 15.09.2018 / 01:49