Posts by Ramiro • 99 points
19 posts
-
-2
votes1
answer86
viewsQ: How to skip line after comma of a variable stored in the Mysql database
In the view.php file, I need to display a field that is already stored in database, of the type sweep, but when displaying I want the text to be shown skipping lines when finding the comma character…
-
0
votes1
answer42
viewsQ: How to format number in 2 decimal places
<script> function calcular() { var p = parseFloat(document.getElementById('peso').value); var e = parseFloat(document.getElementById('estatura').value); …
javascriptasked Ramiro 99 -
-1
votes1
answer101
viewsQ: What is the best way to store files in a webapplication?
I intend to store files of type docx, pdf, among others to access in my web application, where the database is Mysql, and the framework used is Codeigniter. Could someone explain me which way would…
-
1
votes1
answer226
viewsQ: How to use the between command in codeigniter to generate report
I need to generate the following report: The user selects the time interval (start date and end date) and the revenue report is generated by displaying the value of the added recipes. Follow the…
-
0
votes1
answer776
viewsQ: Open modal window according to customer id
In the view I do a foreach to display customers as below: <div class="row"> <div class="col-md-12 col-xs-12"> <div class="table-responsive"> <table class="table…
-
0
votes1
answer176
viewsQ: Limit the number of rows in the second table?
Hello, good night! I have two tables (Process and Movements). I need to generate a report with the Process data, along with the most recent progress. The query I wrote is returning me all the…
-
0
votes1
answer51
viewsQ: How do I add values from different tables?
I have two tables (Costs and Receipts) where I need to make one sum of the field containing values of each of them, after making a calculation (Balance) showing the balance of the Revenue - Costs =…
-
0
votes1
answer195
viewsQ: How to make a datatables data be clicked by calling another view?
Good afternoon guys. Follow the code of my view, which is working fine. It turns out that I would like to do the number of the process (2º <td>), be clickable by calling another view. It is…
-
0
votes1
answer199
viewsQ: How to pass variable between views?
My problem is this. My project’s Dashboard has an input where the user inserts the process number and clicks to search, as code below: <form class="navbar-form navbar-left" role="search"…
-
1
votes1
answer100
viewsQ: How to capture only last record of a table?
The pure query (sql) below, only returns me one row of the table, it occurs that I am working with two tables (Process and Progress) and that progress has as foreign key the primary key of Process.…
codeigniter-3asked Ramiro 99 -
1
votes1
answer150
viewsQ: How to view data from three tables in a view?
I have three tables: Process, Progress and Costs: how do I display the data of the three in a View, and the tables Tempo and Custas have as a foreign key, the primary Process key? I made a foreach…
-
0
votes1
answer72
viewsQ: How to upload an Error 404 page to the website and another to the HTACCES application?
.htacess of the site # BEGIN WordPress <IfModule mod_rewrite.c> RewriteEngine On RewriteBase / RewriteRule ^index\.php$ - [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond…
-
1
votes1
answer79
viewsQ: How to sort VARCHAR field in Codeigniter
How to sort fields of type VARCHAR in class model codeigniter? Already achieve in pure SQL that way: order by strtodate(dtdespesa, '%d-%m-%Y') desc; However, the version of Codeigniter I am using,…
-
1
votes1
answer142
viewsQ: How to list data from one table, even the other (INNER JOIN) being empty?
On my page index, own a input search for the user to search the data in the database, this input calls this method in the Controller: public function pesquisar() {…
codeigniterasked Ramiro 99 -
2
votes1
answer741
viewsQ: How to capture mysql (Duplicate entry) error and display a message on the screen to the user using codeigniter?
How to capture mysql error (Duplicate entry) and display a message on the screen to the user using codeigniter? Error Number: 1062 Duplicate entry '123456' for key 'process' INSERT INTO processo…
-
0
votes1
answer315
viewsQ: How do I sort a date field in mysql?
How do I order decreasingly (select * from tabela order by date desc) a date field inserted by the datepicker script in the format dd-mm-yyyy in Mysql? Note: The dates are being ordered only by day,…
-
1
votes1
answer234
viewsQ: How do I write the following SQL code in the Codeigniter Model?
select count(situacao) as Qtde, sum(valorcausa) as Total_Valor_Causa from processo where situacao = "Tramitando";
-
0
votes1
answer156
viewsQ: How to load two tables in a single select (html)?
I have two client charts, one called personal and one called personal I need to load both tables within 1(a select) using php and codeigniter 3.6. Be able to load the personal table, as follows the…
-
1
votes1
answer167
viewsQ: How do I hide the Controller name in the url?
I would like to know how to hide the controller’s name in Codeigniter. Knowing that codeigniter works as follows: www.meusite.com/CONTROLADOR/FUNÇÃO Ex: www.meusite.com/dashboard/login I want you to…