Questions tagged as 'mysql'

Tagged questions
0
answers

How to do an update on several rows of a table with codeigniter

Hello, I'm having the following problem, I have a stock table. follows img: TheseinventoryproductsaregroupedeverytimeIgiveanentryitaddstowhatalreadyexistsandcreatesanewrowinthedatabase. The issue is I can not do an update that would be...
asked by 29.11.2016 / 18:57
1
answer

Softaculous with connection error with MySQL

I'm working on a hosting server with centos-webpanel and a remote MySQL server. centos-webpanel is already working normally with remote MySQL, it creates the banks and users phpmyadmin is also OK. But I can not install any...
asked by 22.11.2016 / 14:10
1
answer

Problems inserting an OBJ into a LIST

I'm doing a search using LIKE , MySQL with JSF . Whenever I enter the search result within a array to return to my JSF , array adds, but always overwrites items with the last inserted. My code...
asked by 23.11.2016 / 00:59
1
answer

Retrieving images from the database using PHP + MYSQL

I need to load images from a MySql database using PHP, and then put inside a tag in HTML, I am not getting using this code: $con = mysqli_connect("localhost","roberto","",""); $query = ("select imagem from FOTOS_PRODUTOS where id = 1"); $image...
asked by 18.11.2016 / 16:31
0
answers

Trigger mysql - error?

Hello, this is the first time I'm using triggers and I do not know how to solve a bug I'm having and a problem I do not know how to do. I want to make a trigger for when an inserted date (start and end date) is superimposed between a date tha...
asked by 01.12.2016 / 22:01
1
answer

Insert value in javascript from php-mysql

Hello, I'm not programmed, but I'm doing a site where I want to put a counter to determine what will be the expiration of the registration of the site. I used the 3D Cube Countdown script, but I would like the date to come straight from php-mysq...
asked by 01.12.2016 / 15:12
1
answer

How to hide table columns if there is no record in the database?

<?php // Pega o id do produto vindo da URL $id_produto = $_GET['produto']; ?> <table width="100%" class="table table-bordered table-inverse table-hover table-responsive text-uppercase" id="tb_dados_produtos"> <tr>...
asked by 13.12.2016 / 18:49
1
answer

Check duplicate items and update a column in all but one

I have a table of products that bring information from an XML, and another table in the system that basically receives these products after approval (we have an interface to define what goes in or not, basically changing a value in the product s...
asked by 15.12.2016 / 16:19
1
answer

Insertion in Mysql via PHP foreign key

I'm creating an application in PHP and mysql to manage people outside my company. ThelogicisthisandIinsertedtheCompaniesthatIwillassociatewitheachentityPeoplebutwhentryingtoinsertintothebankviaphpthereisnoanswerneitherinException.(viamysqlis...
asked by 10.12.2016 / 14:02
0
answers

Check expired vip users

Good afternoon guys, I have a classified portal and I'm putting VIP accounts in it, these accounts will have the possibility to make an amount of vip postings by the contracted plan. I already know how to prevent her from continuing to enjoy...
asked by 08.12.2016 / 21:37