Posts by Ryan Felipe • 353 points
11 posts
-
0
votes1
answer439
viewsQ: Optimize 20 Million registry mysql database
Create code: CREATE TABLE `tb_empresas_ativas` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cpf` varchar(255) DEFAULT NULL, `nome_cliente` varchar(255) DEFAULT NULL, `razao_social` varchar(355) DEFAULT…
-
6
votes1
answer1264
viewsQ: Send text via php using my phone number
I would like to send sms via php, but without using third party api, I wanted to put my own mobile number as sender and it consume my credits for each send, ie just "automate" the sending of sms.…
-
2
votes1
answer345
viewsQ: Using multiple group by in a query
I have 3 tables: Products, Orders and Order Item. Table: Produtos id_produto foto_produto categoria sub_categoria --------------------------------------------------------- 0081 15487.jpg 4 32 0491…
-
0
votes1
answer328
viewsQ: How to increment a value to a session?
I’m looking to add a value to a GET session. I’m doing it this way but it doesn’t work. function addCart($product){ $cart['cart'][$product] = 0; $_SESSION[] = $cart; }…
phpasked Ryan Felipe 353 -
-2
votes1
answer710
viewsQ: UTF-8 Charset error when returning from database
My system has charset error, but it is only with the data returned from the database. My HTML charset is right, the one in the database is also right, and on php.ini is also right. How do I solve…
-
3
votes2
answers452
viewsQ: How to get the sum of three tables in sql
I have 3 tables, being them: Schoolhouse: id, id_escola and nome_escola; Professor: id, id_escola and nome_professor; Students: id, id_escola, sala_aula and numero_alunos; I am aware of the joins,…
-
2
votes3
answers164
viewsQ: Return the id of a table in another table
I have a client table containing ID_CLIENTE, NOME_CLIENTE and another approval table containing CLIENTE_APROVADO. The approval table is filled with SOME clients in the client table but only the…
-
2
votes2
answers53
viewsQ: Return data difference from two sql tables
I have a table ESCOLA with ID_ESCOLA and NOME_ESCOLA and another table PROFESSORES containing a FK_ID_ESCOLA and NOME_PROFESSOR. I wanted a table that would return me the names of all schools but…
-
2
votes1
answer228
viewsQ: Sort data with google Chart
I have the following google chart Chart: https://jsfiddle.net/ektcghyk/ I wanted to sort the left columns as follows: Basic, Below Basic, Proficient and Advanced. Currently it is out of order, there…
-
0
votes1
answer2236
viewsQ: Illegal string offset in php
I am trying to run the code below, but is returning the error: Warning: Illegal string offset 'name' tasks.php on line 89 <?php session_start(); if (isset($_GET['nome']) && $_GET['nome']…
-
5
votes6
answers636
viewsQ: How do you turn the average to red?
How do I make the average result turn red if the value is less than 20? Follows the code: <?php function media($p1,$p2,$p3) { $resultado = ($p1 + $p2 + $p3)/3; return $resultado; }…