Posts by Igor Silva • 661 points
38 posts
-
0
votes0
answers96
viewsQ: Error in connection to SQL Server database using Pentaho PDI and BA Server
Personal I am with error in the connection of Pentaho PDI and BA Server. I configured the drivers according to this link:…
pentahoasked Igor Silva 661 -
2
votes1
answer259
viewsQ: Merge php arrays by allocating combined values between the two
I have the following arrays: $corretor = array( 'Carlos', 'Andre', 'Rosinei', 'Vinicius', 'Thales' ); $comissao = array( 5, 3, 3, 3, 2 ); How do I join both, printing result as follows: Carlos - 5%…
-
0
votes1
answer2986
viewsA: Group two fields in the same table with mysql
The solution found at the time was the union of the fields through two querys: SELECT c.nome_corretor1 as corretor, ( COUNT(c.nome_corretor1)/ ( SELECT count(vt.idDados_corretor) FROM Dados_corretor…
-
2
votes1
answer2986
viewsQ: Group two fields in the same table with mysql
I’m trying to put together a query, where I can print out the broker’s name and the sales percentage for it. When grouped by name1, the field name_broker2 does not group and vice versa, when grouped…
-
1
votes0
answers231
viewsQ: Store video session inside Session or php cookie
How do I store the time of viewing a video (Html5) in a Session or cookie with php? The idea is to create a mini video platform, and to store the runtime within a cookie | Session, and when the user…
-
1
votes1
answer290
viewsQ: encrypt and determine valid time for php url
I need to encrypt some url parameters, such as email and client code, and determine the valid time for the forwarded link. I looked at Facebook, Google and Twitter that use this methodology to…
-
5
votes1
answer420
viewsQ: Doubt about relationship between tables in mysql
I have the following tables: Table: Customers Table: Interests of the client Table: User In the client interests table, I need to enter the user id and the client id as foreign keys, the user id…
mysqliasked Igor Silva 661 -
0
votes2
answers190
viewsA: How to pass company id to employee table?
This would actually be a primary key relationship id_emp on the table empresa and foreign key id_emp on the table funcionario. IN phpmyadmin itself you can create the indexes and then create the…
-
0
votes2
answers861
viewsA: How to generate code before entering data into the database
Be able to solve the problem with the following code: LESS CREATIVE OPTION public function geraCod(){ //Conexão $db = new MysqliDb('localhost', 'root', 'usbw', 'atendimento'); //Seleciona o último…
-
4
votes2
answers861
viewsQ: How to generate code before entering data into the database
I need to generate a code that matches id which will be auto-incremented in the database. It will be a routine that checks the last id generated and generates a code that will be the id later before…
-
0
votes0
answers788
viewsQ: Control of bootstrap tabs
I have three tabs with bootstrap, the option to navigate the tabs with the buttons back and next are working, as picture below: How do I enable the next tab only if all fields of the first tab are…
-
0
votes0
answers523
viewsQ: Add parameter in javascript url
My problem: I have a property listing to be sorted every time a filter is made, the way I am doing when selected the sort option, the whole content is ordered and not the current one. How do I keep…
-
1
votes2
answers386
viewsA: What(s) problems will I have with using ob_start() and ob_end_flush()?
My problem wasn’t exactly with ob_start(), but rather the server cache. I am hosting on the kinghost with the Varnish cache server active which totally bugged my application, for the simple fact…
-
0
votes0
answers176
viewsQ: view list of returned items in json format with php and mysql
I am developing a website for a real estate, at the moment I am listing the properties and paging the result with sql queries, are listed more than 2000 properties and there is a significant delay…
-
2
votes2
answers386
viewsQ: What(s) problems will I have with using ob_start() and ob_end_flush()?
My application is a website for a real estate company and I’m having problems with a feature developed with Session similar to a shopping cart to add more than one property in a single proposal. The…
-
1
votes1
answer83
viewsQ: Host server integration with local server
I will integrate the system hosted on the kinghost server with a local server. The idea is that when some content is updated on the hosting server update the content of the local server system, and…
-
2
votes1
answer304
viewsQ: URL friendly with various paramteros in htaccess
i see that some sites like olx, search among others, when sent several parameters in the url is separated these parameters by / or -. For example:…
htaccessasked Igor Silva 661 -
0
votes1
answer289
viewsQ: Add get parameters with a select/option value in the url
I have on the page that lists the properties of my site a search form and a select that makes the result ordering. The problem: Doing a search in the form and passing the values via get…
-
5
votes2
answers2206
viewsQ: Redirect with htaccess keeping the URL
I need to redirect a registered domain (domain.com.br) to a domain folder of my hosting (domain.com/exclusive), but I want to keep the domain.com.br in the address bar, without losing the integrity…
-
1
votes1
answer1088
viewsQ: search product/property with autocomplete and fill content dynamically with php and mysql
I am developing a quick search field with jquery ui, php and mysql autocomplete. The autocomplete works perfectly however, I would like to do otherwise. When the user starts typing in the field is…
-
3
votes1
answer470
viewsQ: recover localstorage array and turn into a sql query in php
I am developing a feature to add and remove favorite properties with localstorage. //Com esse código eu recupero os itens que foram armazenados em um array no localstorage $(function(){ var…
-
0
votes2
answers91
viewsA: Loop between an existing Simplexml Photo Tag loop
I developed a webservice for the integration of the real estate of our real estate with the beview application I think you can understand what I’m doing and adapt in yours, it was like this: $result…
-
1
votes1
answer110
viewsQ: Subscribe to a php Session
When the user accesses the property details page on my website, I need to store the broker’s email in a Session, and when he sends the proposal form, the broker’s email is sent to the file…
-
0
votes0
answers210
viewsQ: show similar product/property with php and mysql
I am developing a feature on my site to show similar properties by title and value 9r, but it did not work very well my idea: <?php //Armazeno o resultado do titulo da consulta anterior da tabela…
-
1
votes1
answer252
viewsQ: Problem with validation of various forms with ajax and php
On my website I have several forms: Real Estate Filter Form, Contact Form, Contact Form and Contact Form. Is there any way to recover all forms except the property filter form and send to different…
-
0
votes4
answers886
viewsA: Select data from two tables
Use the INNER JOIN if you want to bring all the fields of the other table you are relating use the LEFT JOIN.
phpanswered Igor Silva 661 -
1
votes2
answers135
viewsA: Check if the e-mail has already been sent
if( $enviado ){ echo "<script>alert('E-mail enviado com sucesso!')</script>"; header("Location: index.php"); } else { echo "<script>alert('E-mail não foi…
phpanswered Igor Silva 661 -
1
votes0
answers1087
viewsQ: Automatic e-mail response with phpmailer
Fala galera! I am using phmailer to send email, it is working very well in sending but I would like to know how to make an automatic response through phpmailer itself. Could someone give me a hint?…
-
1
votes1
answer712
viewsA: Passing parameters from one page to another in PHP
Friend, to send the id_usuario via post, you have to send with ajax. That would be about it: $('#link').click(function(e){ e.preventDefault(); var valores = $('#link').serialize()…
-
3
votes1
answer94
viewsA: Charset Mysql and PHP
How is your connection made, Mysql Conect, Mysqli, PDO? I think that would be the solution: @mysql_query("SET NAME 'utf8'"); @mysql_query("SET character_set_connection=utf8"); @mysql_query("SET…
-
2
votes1
answer143
viewsQ: Prefer immovable/product with Session/cookies using php
How is developed applications that gives the user option to add real estate/products to a favorites list with Session/cookies using php without database?
phpasked Igor Silva 661 -
3
votes1
answer886
viewsQ: Additional GET parameters does not work with htaccess
I am developing a dynamic web site m pages and url friendly, my problem is the following: When I put the id on the link to view the details of the property <a href="/imovel?id<echo…
-
0
votes1
answer626
viewsQ: Add and remove favorite items with php Session and ajax
Personal talk, I need to implement a feature on my site, which will allow the user to select the properties of their liking by clicking an "add to favorites" button, and clicking again it can remove…
-
0
votes3
answers10359
viewsA: Access only via login and password, Inhibiting direct access via url
Buddy, it’s more like that: Either vc does a function that checks if there is a session with the logged in user, or vc includes the verification code on each page you n want q to be directly…
-
1
votes0
answers1318
viewsQ: Intel XDK connection to Mysql database
I have a question about connecting my application to an external database on Intel XDK. Could someone tell me what other techniques to connect my application with an external database, besides the…
-
1
votes0
answers486
viewsQ: Upload different input images using PHP and Mysql
I am developing a PHP system that will generate a Folder to be placed in the shop window. My form is composed of some fields, among them, 4 <input> guy file to upload a featured image and…
-
3
votes1
answer1770
viewsQ: Xampp as an enterprise solution for a web server with php applications
I have a machine that will serve as a web server, with php applications and applications with embedded server like Pentaho and odoo Erp, which will be used as intranet and extranet systems.…
-
5
votes1
answer3110
viewsQ: Use Javascript/Google Maps database addresses
I have in a database the following columns: customer name, active or inactive, address and coordinates lat and lng. I need to develop a PHP application that will display green markers in Google Maps…