Questions tagged as 'mysql'

Tagged questions
2
answers

Parse error: syntax error, unexpected 'if' (T_IF) in C: \ xampp \ htdocs \ Web System \ conexion.php on line 17

This error is indicated to me, but I can not make it work. I attach the connection code.php class Conexion { public function __construct($server, $nameBD , $user , $pass) { $con = mysql_connect($server, $user , $pass);...
asked by 19.04.2018 / 17:25
0
answers

Error Mysql # 1215 - Can not add foreign key constraint

I have the following doubt, build a model with mysql and when exporting the script and executing it, all the works are created except this one, the keys are declared and the tables that form this one also have it, what would be the error and wha...
asked by 19.04.2018 / 00:03
0
answers

Jboss connection pool does not connect to the DataBase

I am using JBoss 7.1, and I am trying to create a Database Connection Pool through Application Server. Right now I am trying it with a mySQL Db, but I have also tried with a Postgre DB, but the error is still the same. The problem is that appare...
asked by 20.04.2018 / 08:51
1
answer

Problems with special characters in an XML file created with PHP

I have a php script that generates an xml of some tables and it seemed to work correctly, but now one of the values of the fields has a "Ñ" and the browsers take it as an error: XML read error: malformed Line number 33, column 36: ARTURO C...
asked by 20.04.2018 / 02:40
0
answers

Insert information in a MySQL table that contains a foreign key

The invoices table is linked to the provider table by the provider_id field, but when I insert data, I get a foreign key error, and tried in CASCADE, RESTRIC etc mode and it does not work, validate that the IDs of the tables be primary keys, the...
asked by 21.04.2018 / 01:56
1
answer

error when entering mysql with XAMPP 3.2.2

Hello everyone I have I am finding myself with the following problem when trying to enter the phpmyadmin server on my local host sends me the following error in my config.inc.php /* * Servers configuration */ $i = 0;...
asked by 19.04.2018 / 19:08
0
answers

Create mysql DB from php with prepared queries

my problem is that I'm trying to create a DB from php, with queries prepared, but mysql gives me an error. The PHP code is: private static $sql = array( 'create database :nombreBD default character set utf8 collate utf8_unicode_ci;',...
asked by 17.04.2018 / 18:17
1
answer

Problem with PHP file path

<html> <head> <meta charset="utf-8"> <title></title> </head> <body> <?php require_once "Sistema Web/Data.php"; $d = new Data(); $productos = $d->getProductos(); fore...
asked by 28.04.2018 / 14:14
1
answer

Fixed letters in a mysql field using php

I have this code that generates a consecutive number every time I insert a data and I would like to add the fixed ESP letters so that it comes out every time I add a new record, the code is as follows: $codigo = (empty($consulta['num']) ? 1 :...
asked by 18.04.2018 / 10:23
0
answers

problem when updating MySQL DB with ResultSet

I have a problem updating my MySQL DB with a ResultSet. Current source attachment. public void insertaTabla(Object[] empleados) throws SQLException{ modelo.insertRow(modelo.getRowCount(), empleados); int ultimaFila = modelo.getRowCou...
asked by 18.04.2018 / 09:06