Questions tagged as 'mysql'

Tagged questions
2
answers

Form making INSERT empty in Database

I am creating a simple registration page and created a Form to store what was typed in the Database. However, even with Form validation in PHP to see if it has any empty fields, when I click Register, it stores blank data in the Database. Could...
asked by 14.04.2017 / 22:46
1
answer

Format xml in php to write to MySQL?

I need to format a xml in php to write to MySQL , but I'm having difficulty understanding and even doing it. Today I have this xml: <?xml version='1.0' encoding='UTF-8'?> <api> <response vers...
asked by 06.04.2017 / 16:23
1
answer

Dynamic Combobox Information Filter

I would like to know how to do a dynamic data filter, so only the data related to the selected one appears, for example: I have in my bank the table Empregado and Empresa , as an example I have: Employee 1 (fk_company 1), Work...
asked by 28.03.2017 / 15:12
0
answers

Project using Laravel and MySql

Hello, I'm doing a registration project and I'm stuck in a business. I have a table of Users in MySql where I have a column that is called 'State' (default), that is, an administrator can 'activate' or 'disable' any users. In my view, I made the...
asked by 28.03.2017 / 14:22
1
answer

Remove last comma from page [duplicate]

I created a page, which is displayed 1,2,3, I would like to know how can I remove the last comma from the last page? And another, the first pages show 1,2,3, and when I pass from 3, it shows 1,2,3,4, does it all show only 3? If you can help me...
asked by 01.05.2017 / 19:06
2
answers

Form system by base date how to get data in $ _POST

How to format ► Put returns between paragraphs ► For line breakage add 2 spaces at the end Italic or bold ► Retrieve the code in 4 spaces ► Serpent escapes parecido _portanto_ ► highlighting by placing > at the beg...
asked by 01.05.2017 / 21:05
0
answers

Select with data from associative tables

I am creating a small database to store the books I own at home, but I came across the following situation: I have two associative tables, one called book_manager , which allows a same book has several authors and a genre_library call, which...
asked by 01.05.2017 / 20:26
0
answers

How to make two xml file calls in the same document

I would like to know if you can generate two XML files in the same document. This is the code I have so far: downloadUrl("connect_xml.php", function (data) { var xml = data.responseXML; var markers = xml.documentElement.getElementsB...
asked by 11.04.2017 / 16:44
0
answers

WordPress problem and connection to MySQL.

All right people I developed a news portal for companies that I work for and on this portal I have an average of 500 thousand accesses a month. I'm having a lot of time with my site at some time. The same has a huge database (4GB) becau...
asked by 01.04.2017 / 05:34
0
answers

Truncate numbers in a Mysql column

I want to leave all the numbers that are inserted in my bank with a maximum of 1 decimal place after the comma without rounding Ex: 3.2567 = 3.2 I want to know if I can truncate the column all of the database (already tried but I could not), usi...
asked by 31.03.2017 / 19:51