Posts by Luciano Silva • 139 points
11 posts
-
0
votes1
answer230
viewsQ: how to create and write txt file with fopen in a network folder
I wonder if there is a way to create , write a file txt with in a folder located outside the PHP application, in another machine on the same network . The PHP server is under Ubuntu Linux and I have…
phpasked Luciano Silva 139 -
1
votes1
answer21
viewsA: Is it possible to perform an innerJoin to know the quantity of the second table?
I do not understand very well but I think this is it. use alias for table name is cleaner. SELECT A.*, COUNT(B.categoria) as ContarCategoria FROM tabelaA A INNER JOIN tabela B ON A.id = B.id GROUP…
mysqlanswered Luciano Silva 139 -
1
votes0
answers56
viewsQ: redirect all air requests to index.php and take the value passed by the URL
I need to redirect all requests to index.php so that you can insert the . php file corresponding to the url into the body. Example when accessing the www.dominio.com.br/forgot password click on the…
-
0
votes1
answer32
viewsA: I specify the icon I want to apply on my button with bootstrap, but it only appears empty on the page... What’s going on?
Which version of bootstrap are you using? version 4 no longer has glyphicon. instead use https://fontawesome.com/v4.7.0 fontawesome this in version 6 plus the 4.7 is very good. if you go to 3 you…
-
0
votes1
answer101
viewsQ: PHP and Mysql Division without rest in PHP task division
Galley is the following need to assign tasks to a variable number of participants. EX: Through a select I got 49 tasks to be executed and I have to distribute to 4 employees. In other words the…
-
0
votes1
answer651
viewsA: Invalid utf8 Character string + LOAD INFILE+ MYSQL LOCAL DATE
I’ve only managed to put CHARACTER SET Latin1
-
0
votes1
answer651
viewsQ: Invalid utf8 Character string + LOAD INFILE+ MYSQL LOCAL DATE
I am trying to import a stock file in CSV and in this files it contains several accents À Á Ú ' ñ etc in the fields Descricao , Nomefornecedor. Bank and and fields are UTF8 at connection instance as…
-
1
votes1
answer845
viewsQ: remove the php extension and force the entire page as https via htaccess
Folks I’m trying to rewrite in . htaccess to force https on all pages and hide the . php extension. He’s staying at the kinghost and I already have the certificate. I have separate codes but I…
-
0
votes1
answer116
viewsQ: convert decimal and date to LOAD DATA INFILE
I am importing a CVS file into Mysql. I have two columns: a quantidade and the other as data. I am trying to convert to Mysql default. In the database this column is as decimal and date. You are…
-
4
votes3
answers160
viewsQ: Select Where IN all records
Gentlemen , will searched for days the answers to this doubt that I think is silly , but I could not. I created a view that has Matricula | Name |Job |Shift | Centrocusto | Codtreina | Status I made…
-
3
votes0
answers582
viewsQ: Select from all records of an IN clause in Mysql
I would like your help because I made a simple query that would need to return all records specified in clause IN. In this clause ( TF.Codtrains IN ) it comes from a select. The problem is that it…