Questions tagged as 'mysql'

Tagged questions
3
answers

Make count in several mysql fields

Good, I have a db in mysql, I would like to count a certain value in many fields in the same table (not in a single field), for example in this case I have the table A = Fair S = Outstanding E = Excellent Table: notes As you can see it...
asked by 10.10.2017 / 01:51
1
answer

Help with a query of two tables

I am making a login and in it, I want to consult two tables and that according to what I enter in the input, I bring a single result of the tables that I consult, I put the way I am doing it but I have not succeeded SELECT u.id_usuario, u.id_t...
asked by 18.08.2017 / 17:22
2
answers

Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or ...?

I'm doing a school work that is just to check ratings I'm doing in php and I already have the login but when I click on my menu to show me my qualifications send me the following error I'm using Xampp I leave my code I guess my error is in the...
asked by 08.08.2017 / 23:13
1
answer

Problem with datatable search

I am currently using the datatables plugin to dynamically list data from tables I have made for a system I am working on. Currently I have read enough of the plugin and I have not had many problems to use it, but today I have found a big prob...
asked by 10.08.2017 / 16:29
1
answer

Warning: session_start (): Can not send session cookie - headers already sent

Error when trying to enter I explain in localhost it works fine but when uploading it to some server it marks this error Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /storage/ssd3/893/822893...
asked by 05.09.2017 / 19:20
1
answer

When using CONCAT, I get an error saying "The input string does not have the correct format"

It turns out that data charges to DataTable in the following way: private void cargarempresas() { dt_hogar = new DataTable(); String sql = "SELECT CAST(CONCAT(nombre,'-',apellido)AS CHAR) AS nombre,fechacreacion FROM hogar";...
asked by 24.07.2017 / 07:34
1
answer

Error exporting database to Excel with PHPExcel library

I am trying to export a table from my database to an excel file, using the library PHPExcel The structure of my table is:    reg, folio, key, date, place, address, telephone, name, subject, depto1, depto2, state, observations, scan,...
asked by 21.07.2017 / 21:28
1
answer

Overlap records in a MySQL table from PHP

Someone would help me to make records overlap in the same table and I have the record of everything I want to see if you can help me is to know how to overlap those records. ---+--------+----------------+------------+----------+----------+----...
asked by 08.07.2017 / 08:26
1
answer

Consultation in laravel

I make this query: $costo = Habitacion::where("id","=", $habestatus)->select('hab_costo')->first(); * Habestatus is a variable that has the id of the room. and when you print the result, you throw this at me: {"hab_costo":2000}...
asked by 05.03.2018 / 23:28
1
answer

Problem inserting the data array for google maps bookmarks

I have a table html that is created with a php calling the database Example: <table> <tr> <th>id</th> <th>Name</th> </tr> <?php $query = "select id, name from pizza"; $result = $con...
asked by 24.06.2017 / 21:23