Questions tagged as 'mysql'

Tagged questions
2
answers

How do I select from Php in MySQL

I want to do a simple select from mysql, how do I do it? I think it would be something like that? <?php mysql_conect('127.0.0.1','root','clave'); mysql_query ('Select coluna1,colunna2 from tabla') ?>     
asked by 08.08.2016 / 03:20
3
answers

Send form array, php, mysql

Good, these days I was doing a form to keep some links inside my database, but the truth had never used the forms with array & I've searched a lot, but none of them I do. How can I make it work? My code is as follows: $screenshot = $...
asked by 10.09.2016 / 20:10
1
answer

Load data in a table without ajax

This is the first question I ask in this medium, I am new in terms of WEB programming and I am costing certain things. I have a problem when loading data, to see if I can explain myself: I'm using php and javascrip for a university projec...
asked by 09.10.2018 / 21:58
1
answer

Place several foreign keys to a primary

I'm starting with SQL and I wanted to know if it is possible to place several foreign keys from one table to a primary key from another table, I have something like this create table producto( llave int primary key auto_increment, producto var...
asked by 13.09.2018 / 15:18
3
answers

Null value in MySQL with PHP

Ajax is used to insert data, and although at the time of inserting, it works correctly, the problem is when they are inserted in null. It should be noted that the data to be inserted is of the date type in the database. when inserting an e...
asked by 20.09.2018 / 19:39
1
answer

C # Problem when updating registration with mysql "Windows Form"

Well send me this error message    "You have an error in your SQL syntax; check the manual that   corresponds to your MySQL server version for the right syntax to use   near 'id_raza = 8' at line 1 " This is my method to update public bo...
asked by 19.09.2018 / 07:45
3
answers

fusion of 3 select

SELECT vendedores.Nombre,SUM(factura.Total) FROM vendedores,factura WHERE vendedores.Codigo=factura.CodigoVendedor AND factura.Fecha BETWEEN '2018-09-13' AND '2018-09-14' GROUP BY vendedores.Nombre SELECT vendedores.Nombre,SUM(sales.Total...
asked by 26.09.2018 / 04:51
5
answers

Sort priority when making an update

I have the following table where I sort by priority ASC ---------------------- |prioridad|actividad | |---------|-----------| | 1 |act1 | | 2 |act2 | | 3 |act3 | | 4 |act4 | | 5 |a...
asked by 05.09.2018 / 17:11
1
answer

Logic in MySQL Query only if 2 conditions are met

I have the following code: $query = "SELECT * FROM pedidos WHERE usuario = '$usua' AND status_pedido = 'ESPERANDO' "; $result = mysqli_query($db, $query); if ($result){ echo '<div class="alert alert-danger" role="alert"" >...
asked by 30.08.2018 / 15:17
3
answers

Get full value of a query as a Laravel fix?

Cordial greetings colleagues, it turns out that I'm doing the following query using query builder in laravel: public function getSocial_network_post(Post $post) { $query = DB::table('post_social_networks')->select('social_netwo...
asked by 31.07.2018 / 23:57