Select Mysql database data inside a PHP file without refresh.
Example:
<?php
// Essa select abaixo tem que buscar a cada 5 segundos sem atualizar a página
$selecionaTabela = mysql_query("SELECT * FROM nomeTabela")or die(mysql_error());
/...
I created a login form with the following code:
Login.html:
<form action="login.php" method="post">
<input type="hidden" name="id" value=''>
Usuário<input type="text" name="usuario" id="usuario" >
Senha<input type="pass...
In my database in the paginas table I have the fields pagina_1 , pagina_2 and pagina_3 representing the three pages of my site.
In these fields I'll insert the page views as below.
In my "page one" code, for exam...
I'm trying to make an empty select, which if not selected no option pulls all the results, using the AND in SELECT the form forces me to choose some option, how can I solve this? Here are the codes:
<form action="index2.php" method="post" &...
Follow the code:
//informações necessarias para inserir no DB.
coo := copy(lTemp,53,6);
ccf := copy(lTemp,47,6);
ecf := copy(lTemp,4,20);
//Data sendo formatada para ser inserida...
I'm using Inner Join to combine two tables:
SELECT eventos.colab_id, colaboradores.setor
FROM colaboradores INNER JOIN eventos
ON colaboradores.id = eventos.colab_id
So far so good, however I have cases where I need to delete the...
I'm trying to create a form to register services performed, so I came across the first problem, I'm trying to keep it as light as possible because a lot of data. I want to store the "employee", "client", "services" ... I chose to use an autocomp...
I need to go through a json and get the values and insert into the bank but I think it would be a bad idea to put an insert inside a loop.
I would like to know how to do multiple simultaneous inserts with php.
I would like to know what kind of conventions exist in database names, tables and columns in mysql , is it usually used camelCase or other type of convention?