Questions tagged as 'mysql'

Tagged questions
2
answers

Problem saving text in Arabic language in mysql [duplicate]

I have a site where there are several languages, but when trying to save a text field in the Arabic language, it saves with characters of type "اÙØμÙØØ © اÙØ ± Ø|ÙسÙØ ©", already try to change the chatset of the mysql for utf8 and cp1256, e...
asked by 11.01.2017 / 18:48
1
answer

Comparison of database dates with system date

Hello I need to compare the month of registration of information present in a database table with the current month provided by the system. In the database I enter the number for the month in a column. For example: On 16/12/2016 I regis...
asked by 17.12.2016 / 17:59
1
answer

Error Call to a member function prepare

The connection to the database is working perfectly, but the getList method returns this error: Fatal error: Uncaught Error: Call to a member function prepare() on null in /opt/lampp/htdocs/site/config/config.class.php:32 Stack trace: #0 /opt/...
asked by 08.03.2017 / 23:59
2
answers

Doubts to query the mysql bank?

Is there a way to create a code to check if a new record exists in the database? EX: I've inserted id = 2, I need to create a code that will generate a notification every time a new id pops up.     
asked by 09.03.2017 / 23:57
5
answers

Php View Columns

I have two columns A and B with varying words, I want to remove the whole line of A and B that in column B is less than 8 characters long. How do I do this in php?     
asked by 10.03.2017 / 19:50
1
answer

send rfid data to Mysql [closed]

How do I get the following information when the tag passes through the rfid reader: "Salvador", "Bahia"?     
asked by 16.03.2017 / 10:31
2
answers

mysql error 1215 can not add foreign key constraint

Personally I've researched several other topics about this error and none solved my problem so I'm posting here for you. It is as follows: I have a table called "members" that already has content and I am creating a new table called member_photo...
asked by 15.03.2017 / 18:55
1
answer

Is there a way to use a MySQL table in developing an app with ionic and cordova?

I would like to know if there is a way, because I am developing a simple project that uses only one database.     
asked by 16.03.2017 / 14:20
1
answer

Currency Format

To be complete could not enter with a FORMAT (Value, 2) even in CONCAT? SELECT * , CONCAT('de ', Valor, ' por ', desconto) AS promocao FROM (SELECT Valor, Valor - Valor * 20/100 AS desconto FROM comissao ORDER BY comissao.Valor DESC) t;...
asked by 07.12.2016 / 02:14
1
answer

Enter time period in database [closed]

I've been thinking here ... Is there any way to insert multiple dates at the same time into the database? For example, an event that starts on 03/02 and runs until 07/02. How to insert this range into MySQL so that every day between 03 and 07...
asked by 01.02.2017 / 19:37