Questions tagged as 'mysql'

Tagged questions
1
answer

update multiple records with php checkbox mysql

I need to update a mysql table with data coming from a / two checkbox where checked is 2 and unchecked is 1. It turns out that if you check the id1 of col1 it will update id4. What will be wrong? My mysql table looks like this: id col...
asked by 01.03.2016 / 02:34
1
answer

Difficulty in saving 3 input with different name with foreach

Hello, I'm creating a shopping cart and I need to record the products selected by the customer via form. This is almost all working, just missing the products in the item sale table. I made this foreach below to list the products with your da...
asked by 19.12.2015 / 04:20
1
answer

Backup mysql with create schema

I need to do the backup of a database (DUMP) that comes with create schema . What command line using PUTTY (via SSH) to do such a task? I researched and found this command but it only backs up the tables and data. mysqldump -h HO...
asked by 22.02.2016 / 17:54
1
answer

Login page using mysqli_fetch_row

I am creating a fairly simple login page where the user enters their name and password, the system does the database scan (mysql) and validates its input, however, when I enter the values correctly the system returns null . Follow the html co...
asked by 22.02.2016 / 19:49
2
answers

SQL - Using Distinct

Friends I need a Select that loads: (all portals linked to a user and an additional column informing which portals were selected in a given news item) So far my SQL is like this ...: select distinct case when usudesc.txt_nome is nul...
asked by 04.02.2016 / 13:27
2
answers

Query is not running, inserts nothing

What could be wrong? Do not insert anything into the bank. Form: <form class="form-horizontal" action="chk-gerente.php?nro_pergunta=<?php echo $nro_pergunta; ?>" method="GET"> <fieldset> <legend><b>...
asked by 13.02.2016 / 13:47
2
answers

Can I connect to a database using JS?

I'm developing a website for myself and would like to know if I can use JavaScript to connect to the database and get a value. The site is local, and the bank is also on my machine, do you know if I can connect using JS? How?     
asked by 20.02.2016 / 01:09
1
answer

How do I select all the records in the table

How do I select all the records in the select below: $select = "SELECT COUNT(1) AS id_mark, SUM(a.rate) AS rate, b.name_mark, b.id FROM tb_comment a, tb_mark b WHERE a.id_mark=b.id AND b.id_category=:id_c GR...
asked by 17.12.2015 / 19:45
1
answer

WordPress users report

I need to pull a report with the Name, City, Type of Store and Email information that were registered from a registration form. Is there a plugin that I can pull this report with this information?     
asked by 18.11.2015 / 14:07
1
answer

How to save data from a form in DB with CakePHP

Good Morning I need help because I'm creating a form to save only dates ... and I'm having trouble creating this code ... for lack of experience ... the view is already created with 4 fields for dates ... and then in the controller I'm kin...
asked by 18.11.2015 / 13:20