Questions tagged as 'mysql'

Tagged questions
0
answers

Load date data from a datatimepicker into a form to perform an update

Update the data date (which is a datatimepicker) of a form that must load the value stored in the database to change it and update but not load the saved data < script > function obtener_datos(id) { var received = $("#re...
asked by 15.06.2018 / 19:37
0
answers

php form with mysql, I can only capture a select value in the list

I have a problem with showing some data in a select button, it happens that by default it always shows me the first one in the row, I made the test by entering different values in the database, it takes me but not listing it. When entering a new...
asked by 22.06.2018 / 00:27
1
answer

Problems with the connection to the database

I am making a change in the different registers, which are associated with a service number that is the primary key but at the time of making the change it shows me this error:    Warning: mysqli_error () expects exactly 1 parameter, 0 given...
asked by 18.06.2018 / 14:27
0
answers

java.langNullPointerException (query Mysql in Jframe Form)

I'm new to java programming MySQL I have made a database with Java and managed to insert data but I could not extract the information in certain fields. This is the code to insert in Mysql: import java.awt.event.KeyEvent; import java.sql....
asked by 15.06.2018 / 16:02
1
answer

laravel 5.6 related models to related models softdeletes

I have in the model Finca.php public function piscinas(){ return $this->hasMany(Piscina::class)->select('id' , 'finca_id', 'area' , 'name'); } public function getPiscinasPlanificadasAttribute(){ return $this->hasMany(Pisc...
asked by 15.06.2018 / 01:43
0
answers

Save content from an HTML checkbox in MySql using PHP

I am new using PHP and HTML. I'm using Xampp, where I have a database of "test", with a table named "table" and with a single attribute of type boolean called "accepted". The problem I have is that when I try to execute the php code when making...
asked by 14.06.2018 / 15:20
1
answer

how to insert html code without losing styles in an email

<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title></title> </head> <body style="font-family:'Open S...
asked by 14.06.2018 / 13:50
0
answers

query or cursor mysql

I have a problem with this type of query or it would be better with a cursor I leave you an example table: *create table table11( cod_table int, dni varchar(9), doc_slug varchar(100), doc_tipo int, fecha_vecimiento date, fecha_carga date )...
asked by 13.06.2018 / 20:50
1
answer

How to have the value of a checkbox with javascript

I have a query or query as you like to tell, and in the query that I do to the table would be something like this: $d151="select * from temporal where ncuenta>'399' and LENGTH(ncuenta)>3"; $db1=$dbh->prepare($d151); $db1->execute()...
asked by 13.06.2018 / 22:40
0
answers

WAMPP problems migrate site and BD

I currently have a portal on a local machine with WAMPP, which I want to migrate to another local machine also with WAMPP. The only thing you take is the portal www (c: wamp / www), and its BD (C: \ wamp \ bin \ mysql \ mysql5.5.24 \ data \ b...
asked by 14.06.2018 / 15:34