Posts by ChrisAdler • 1 point
170 posts
-
1
votes3
answers1619
viewsQ: Insert data Database Related tables
I’m having trouble inserting data that has related tables. $sqlinsert2 = "INSERT INTO tb_detalhe_trabalhador VALUES(0,NULL,NULL,'".$MedicaValidade."',.. Currently the data that are as NULL are the…
-
1
votes2
answers1120
viewsQ: INNER JOIN does not return database result
I’m trying to use this code: SELECT * FROM tb_trabalhador INNER JOIN tb_detalhe_trabalhador ON Tb_trabalhador.id = tb_detalhe_trabalhador.tb_trabalhador_id And it returns the blank result. Is there…
-
-1
votes3
answers1762
viewsQ: Php MYSQL query several tables
Good, I’m having difficulty showing the data of a database using 3 tables. <?php include("conectar.php"); $quantidade = 1; $pagina = (isset($_GET['pagina'])) ? (int)$_GET['pagina'] : 1; $inicio =…
-
1
votes2
answers315
viewsA: Page page by Id
Boas, Thanks from now on for the help of @Thiagobarradas I’ll leave the code here complete with the solution. <?php include("conectar.php"); $quantidade = 1; $pagina = (isset($_GET['pagina'])) ?…
-
0
votes2
answers315
viewsQ: Page page by Id
<?php include("conectar.php"); $id = $_REQUEST['id']; if ($id == "") { $id = 1; } $sql = mysql_query("SELECT * FROM tb_trabalhador where codigo =".$id." limit 1"); include("paginacao.php"); //…
-
0
votes1
answer86
viewsQ: Swap Table by topic
i have the data to be shown so currently. echo "<table>"; echo "<tr><td>Nome:</td>"; echo "<td>".$exibe["Nome"]."</td></tr>"; echo…
phpasked ChrisAdler 1 -
1
votes2
answers13056
viewsQ: Changing Mysql data in PHP
I have the Tb_workers where it is filled in by a form. And then I created another page to change this data. Altering.php $id = $exibe["id"]; $Nome = $exibe["Nome"]; $Morada = $exibe["Morada"]; $Tipo…
-
6
votes2
answers1602
viewsQ: Display "longblob" field content containing PDF file
I have a question about the data longblob which are stored in the Database. I currently have so for the other data: echo "<tr><td>Email:</td>"; echo "<td>"; if…
-
-1
votes2
answers512
viewsQ: phpmailer gets blank screen
By experiencing the phpmailer, only thing it does is show the screen of Browser blank. Has anyone ever done that? Could I have been blocked on the mail server? <?php…
-
4
votes2
answers515
viewsQ: php Show the variable
I have a page that sends emails when one of my form dates is ending. Currently he only sends the name of the person who has the date to finish but I want him to inform the date that is at the end.…
-
1
votes2
answers234
viewsQ: Auto increment ID value
In my Mysql Workbench I have 4 tables with auto increment id. But when I fill out the form it adds values not followed. For example: I fill out a form for the first time and the ID it puts me is 3.…
-
2
votes1
answer2336
viewsQ: Type of relations 1:1
'Cause when I was gonna remake the relationships in my table 1:1 1:1 -------- 1.1____ (With the dash in the middle but the straight line) What’s the difference between us?…
-
-2
votes2
answers793
viewsQ: How to place variables in email with phpmailer?
$sql = ("SELECT nome, datas FROM tabelas WHERE datediff(now(), data) <= 10 "); $validade = mysql_query($sql); while.... (codigo phpmailer) // corpo da mensagem $PHPMailer->Body =…
-
-1
votes1
answer117
viewsQ: Form Receive in 2 different tables
I have this code to receive data on two different tables. But only the first table is receiving data. The second table is still blank. It is possible for this code to work this way?…
-
-1
votes2
answers111
viewsQ: Send data to Database
I have a database with the following primary and foreign keys tb_detalhe_trabalhador id tb_funcoes_id tb_trabalhador_id tb_equipamentos id tb_trabalhador_id tb_funcoes id tb_trabalhador id My last…
-
1
votes3
answers856
viewsA: Query search for value in Database
I figured it out. Although it appears in the database 0000-00-00 on the date I put like this: I thank those who helped me :) include("conectar.php"); $sql = mysql_query("SELECT * FROM tb_trabalhador…
-
2
votes3
answers856
viewsQ: Query search for value in Database
I want to show the results obtained in a form but when saving in the comic null but kept so: Date: 0000-00-00 And Numero: 0 Query have so: $sql = mysql_query ("Select *, Count(*) from tabela1,…
-
2
votes7
answers7710
viewsA: How to send email automatically?
I was able to get Php to send an email. I ended up using Phpmailer. I leave the code for those who need it. Thank you all $PHPMailer = new PHPMailer(); // define que será usado SMTP…
-
10
votes5
answers98198
viewsQ: How to display the result of a query on an PHP html page?
How can I display the results of a query in a table of an html page? Below is what I was able to do. However, the code only shows the first record. include("conectar.php"); $sql =…
-
5
votes7
answers7710
viewsQ: How to send email automatically?
How to send emails automatically using PHP? I have a form that receives several dates and when it was 10 days before the deadline, send a message to several people with the warning. I’ve been told…