Questions tagged as 'mysql'

Tagged questions
1
answer

How to load JSON into MySQL, including JSON specific fields [closed]

Can anyone help me with a question that is killing me? First, I'm trying to load this JSON into MySQL { "business_id": "fNGIbpazjTRdXgwRY_NIXA", "full_address": "1201 Washington Ave\nCarnegie, PA 15106", "hours": { }, "...
asked by 30.07.2015 / 04:45
2
answers

C # and MySQL with AspNetUsers, tables deleted

I'm developing a system with C # (MVC) and MySQL. Everything works perfectly fine when I use my local instance of the Database. I've duplicated this database on UolHost and that's where something bizarre happens. When I change the connection...
asked by 30.07.2015 / 02:24
1
answer

SQL LIMIT always returns the same last 3 records

I have a problem with a select. I have the following table id id_de id_para mensagem --- --------- ----------- ----------- 1 10 20 Oi David. 2 20 10 Oi José 3 10 20...
asked by 18.06.2015 / 02:03
2
answers

How to login with php and session in ionic?

I'm making a mobile application with ionic and I need to login to external database users, I need to know how I can login through php and create a session with id of user ?     
asked by 05.08.2015 / 16:17
3
answers

Return the difference between the last two records [closed]

What I need to do is in this image. How do I do it? This is the query I made and it is coming empty and I do not know why. SELECT event_type, value from teste t1 Where exists (select event_type, value from test...
asked by 29.06.2015 / 21:04
2
answers

MYSQL Android Security

I'm making a login system. But I'm in doubt: I connect to the database through PHP? I mean, would I just open the link and the server would perform the procedure? or do I directly from the application through the connector? If I do it by t...
asked by 24.09.2015 / 17:27
3
answers

How to avoid duplicate registration in a php form

I would like examples of how to avoid duplicate email if a user attempts to make multiple registrations. <form action="processar.php" method="POST"> <input type="text" name="nome"> <input type="email" name="email"&g...
asked by 02.06.2015 / 21:46
1
answer

Query data mysql with x Days to win

I do not know what I'm doing wrong. in this code down was to show me the list of records with the dates that entered the house of the 3 days to win only that there are records that have already won $cmd = "SELECT f.*,a.* FROM a_finan AS...
asked by 06.06.2015 / 16:55
2
answers

Multiple image file

There I come to you for help novalmente! I created a function to register images in the database, one of them being the cover and the rest of the album images. The script even registers the cover image and album, but the album is only registe...
asked by 18.09.2015 / 22:00
1
answer

Problems with SELECT option with PDO

Friends re-edited the PDO connection below: <?php $conn = new PDO( 'mysql:host=localhost;dbname=pbfjacar_site' , 'pbfjacar_murilo' , 'smc100164' ); $stmt = $conn-> prepare('SELECT font FROM fontes'); $stmt-> execute(); $result = $stmt...
asked by 10.05.2015 / 03:17