Questions tagged as 'mysql'

Tagged questions
1
answer

mysql_fetch_array () does not show all records

Hello, I'm having problems, in my database table I have 3 records, I use the code below to search for them: public function buscarMateriaProva($codigoProva){ $query = " SELECT codigoMateria, codigoProva, quantidadeQuestao...
asked by 26.03.2015 / 22:23
1
answer

How to hide given in a table according to the status

I have a code that fetches the data in the database and prints a table on the screen. My table that appears on the user's screen has the fields: Referência | Abertura |Status |Objeto Reference is an ID, Open is a date and time, St...
asked by 26.03.2015 / 03:25
1
answer

mysql encoding

I have the data in the database, in the charset utf-8, and I want to export the listing in .csv, however when I give a select it returns me the data, for example "Property and Property Management ". How do I return the data in the selected accen...
asked by 07.05.2015 / 18:55
4
answers

How to create a real-time notification system similar to Stack Overflow?

I am developing a Help Desk system, and would like some ideas on how to create a notification system similar to Stack Overflow itself, whenever any new support is registered. I want to use PHP, MySQL and jQuery only. Should I use window...
asked by 16.03.2014 / 20:21
0
answers

Problem with conditional insert

I am trying to get a conditional insert so I do not duplicate entries in the table but you are not inserting anything to me Code <?php session_start(); if(isset($_SESSION['user_id'])){ mysql_query("INSERT INTO visitas_estabeleciment...
asked by 20.02.2015 / 21:09
0
answers

Content outside of while php

Well I have a loop while that shows all my posts on the page and for each post I have a input box to comment the post. I need a way to put it (input) out of the while but stay in all the posts. How can I do this? Code $resul...
asked by 20.02.2015 / 23:03
1
answer

Mysql - Triggers of derived values

I researched and found nowhere. I'm starting to study in Database and need the following help: A Class table has the following structure: Id_turma (self-incrementing) Max_children (maximum number of students) student_sum (column derive...
asked by 03.06.2015 / 05:22
1
answer

Database does not appear information

Well, I created a database in PhpMyAdmin with name students a table called information and put the data in it ... Then I added it to my site when I add the code appears instead of the table information ... Here is my code below:...
asked by 30.04.2015 / 13:38
2
answers

links between tables

$sql = "SELECT * FROM Inscricao WHERE al_id = ".$_GET['idc']; $sql = "SELECT * FROM Aluno WHERE al_id = ".$_GET['idc']; $sql = "SELECT * FROM EncarregadoDeEducacao WHERE ee_id = ee_id.inscricao where al_id = ".$_GET['idc']; tables: CREATE TA...
asked by 14.04.2015 / 12:32
0
answers

Send and receive data from MySQL with Android

And, peace of mind? I have an activity that is listing a series of products from a MySQL database. I need to click on any of these products, transfer to another activity, take the product ID together, and for that collected ID, search the MySQL...
asked by 14.04.2015 / 19:07