Questions tagged as 'mysql'

Tagged questions
1
answer

What is the best type in SQL to use with CryptoCurrency?

I am developing a system where I will store transactions of CryptoCurrencies, type Bitcoin, I can not in any way have problems of conversion and rounding, in C # I checked and the best is decimal , right? The values will be in this forma...
asked by 08.12.2017 / 19:31
1
answer

Friendly Url in PHP and Sql

I have the following php code to make my site urls friendly: <?php $atual = (isset($_GET['pg'])) ? $_GET['pg'] : 'home'; $permissao = array('home', 'contato', 'sobre', 'politica'); $pasta = 'arquivos'; if (substr_count($atual, '/') &g...
asked by 01.02.2015 / 03:46
3
answers

How to do PHP and MySQL pagination?

I want to make a pagination on my blog. I will not have 50 posts on the first page, so I want to limit the page to the last 15 posts added and then clicking the "older posts" button will show me the oldest posts. In the background I do not want...
asked by 23.07.2014 / 16:14
6
answers

Copy of WordPress database without using PHPMyAdmin

I need to migrate a WordPress site from one server to another. One of the necessary steps is to export the database used in the current site, edit some data if necessary (such as the site address and URLs of the files) and import the database to...
asked by 27.02.2014 / 23:01
7
answers

How to insert data in DB with jQuery / Javascript without using PHP?

I'm learning Javascript and jQuery and am wanting to make a small website to test the insertion of data into a database. I have no knowledge in PHP, I would like to know if it is possible to insert data into a database only with Javascript or jQ...
asked by 30.01.2014 / 00:24
3
answers

What is an absolute value?

Viewing the MySQL documentation you can find the mathematical function ABS (x) , which returns the absolute value of x . mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); -> 32 What exactly is this absolute va...
asked by 05.09.2017 / 19:29
3
answers

System of categories and subcategories / infinite children

I'm building a system of infinite, simple categories and subcategories. I found a script on the internet that meets the requirements, but its customization and adaptation to my project made it almost unusable. I studied a simple structure and...
asked by 14.04.2014 / 01:31
3
answers

Error "HTML contains invalid UTF-8 character (s)" when using mpdf

I have a problem using mPDF. Basically, I have a code that makes a select of a table and then displays the values on a PDF page. The problem is that if any table value has an accent (example: "Hello") the error appears:    "HTML con...
asked by 06.07.2014 / 15:57
3
answers

Records with recurring dates filtered by a period

The Problem I am creating a financial system where I need to register a recurring movement, such as a light bill that repeats itself every month. In the system, this type of transaction is treated as a fixed expense / revenue. My table has...
asked by 28.08.2014 / 07:33
1
answer

Long Polling performance with PHP, Mysql and Ajax

I'm developing a PHP site, and using Long Polling techniques for real-time notifications. I'm getting the script to wait 50 seconds for a response, and not getting one, in 2 seconds it asks again, to give greater turnover of connections, as t...
asked by 29.04.2015 / 21:36