Questions tagged as 'mysql'

Tagged questions
3
answers

Is it possible to select all the fields in a database except a few?

I've been searching and I can not find it, but I've found that in a mysql query, I need to select almost all the content minus 3 elements, the point is that there are almost 20 columns. I know that php can not show those fields, but the output i...
asked by 04.11.2016 / 17:43
2
answers

Error "Column count does not match value count at row 1" in java [closed]

Good morning, When I insert or update data in MySQL from java I get the commented error. I do not know why, the number of columns is correct ... in fact, before I had the same code but with fewer columns, I do not understand where the problem...
asked by 18.03.2017 / 12:49
1
answer

syntax error, unexpected 'else' (T_ELSE) [closed]

Code with the error: if(!empty($_GET['horarios'])){ $cod_hor=$_GET['horarios']; }else{ header('Location:error.php'); } if($_SESSION['tipo_pro']=='a' or $_SESSION['tipo_pro']=='p'){ $profesor=$_SESSION['ced_...
asked by 05.11.2016 / 04:24
1
answer

Corruption of server-mounted database

I am receiving an advanced PHP programming course in a mini-company that has two servers: MAIN: contains the main programs DEVELOPMENT: here the systems are improved and then the main one is uploaded There are five computers and five pe...
asked by 17.03.2017 / 14:54
3
answers

I need to relate two tables, that the value of one column in table A be taken in another column in table B

I have a table that is products, and another table that is typeProducts, the structure of the first is basic: id, code, description, typeProduct, the table typeProducts only takes id and description, so I need the product table, in the type fiel...
asked by 12.08.2016 / 15:28
2
answers

Error with $ _SERVER ['$ PHP_SELF']

I have a CRUD but when I insert it, I get the following error:    "Forbidden access!   You do not have permission to access the requested object. The object is protected against reading or the server can not read it.   If you believe that t...
asked by 06.08.2016 / 19:09
2
answers

SESSIONS PHP and MySql

I am learning sessions in PHP, I already have my session created, in a login I can already enter with real data from a database, in this case the user and password, in my page where they are already registered I put <?php echo $_SESSION['s...
asked by 16.06.2016 / 07:36
2
answers

Double data format sent to mysql

My question is this: For example, enter the number "1" in a JTextField , then, before sending the number to the database and make the corresponding Insert, pass the number to double, and the number in the database is entered as entered...
asked by 21.06.2016 / 06:19
2
answers

How to count, sort and store in variables, the data that I bring from the BD?

Good morning, I have a small query ... I have this table in Mysql This is my query: SELECT at_ce.condicion, COUNT(at_ce.id) AS cantidad_condicion, gpr.grupo_programa, COUNT(gpr.id_programa) AS cantidad_grupo_prog...
asked by 17.06.2016 / 15:33
1
answer

Javascript - Onclick in links

My question is: can onclick events be done on links? cambiar_estado.php $query = "SELECT * FROM usuarios_datos WHERE ID_OBLIGATORIO = '".$_REQUEST["Id"]."'";...
asked by 15.11.2016 / 17:09