Posts by ChrisAdler • 1 point
170 posts
-
0
votes1
answer674
viewsQ: Problem inserting php mysql ID data
I have a problem entering data in mysql due to table id. Tb_details_worker: id, Name, Function $sqlinsert = "INSERT INTO tb_detalhe_trabalhador VALUES ('','".$Nome1."','".$Funcao1."') Error: Column…
-
-3
votes1
answer51
viewsQ: Save button with option
I have a save button in the html that serves to store the data of a form in the BD but after saving I want it to open a window asking:"New record?" with two options with yes and no. If yes open page…
-
0
votes2
answers1887
viewsQ: php/html Insert various data with the same information
I am in need of some help because I am a bit stuck on that. I have a form where I put information on a worker. Now I want to change this page to be able to insert several workers. At most up to 16…
-
7
votes2
answers11326
viewsQ: Create HTML table using PHP
Can I create a table to separate this code? Because it’s the only way to align the data I have if($exibe['Nome1'] != NULL) { echo '<p><b>Nome: </b>'.$exibe["Nome1"].'…
-
3
votes5
answers4257
viewsQ: Row size Too large (> 8126)
Gave me an error while loading mysql data. Row size Too large (> 8126). Changing some Columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In Current Row format,…
-
-1
votes1
answer72
viewsQ: Php data disappears on page
I have a code in PHP and when viewing the page it cuts the text data. echo '<div id="tabs-2"> <p><b>Ficha de Aptidão Médica:</b></p> <p>Trabalhador (1)…
phpasked ChrisAdler 1 -
-1
votes1
answer150
viewsQ: Parse error: syntax error, Unexpected '
I have a mistake: Parse error: syntax error, Unexpected 'Medicavalidade' Trabalhador (1) Validade:'; If (($exibe['MedicaValidade'] != 0000-00-00) && ((strtotime($exibe['MedicaValidade'])…
phpasked ChrisAdler 1 -
-1
votes2
answers177
viewsQ: Join 2 if’s Php
it is possible I join two if’s almost in a row? ' <p>Trabalhador (4) Validade:'; if ($exibe['MedicaValidade4'] != '0000-00-00') { if (strtotime($exibe['MedicaValidade4']) < time()) { echo…
phpasked ChrisAdler 1 -
0
votes2
answers60
viewsQ: Rescue BD Data Only Filled
I’m having a problem when I have to show the database data and they’re empty because the name pops up and the blank space. Nome: Pedro Nome: Ricardo Nome: Nome: Nome: and wanted to know if it was…
-
-2
votes3
answers2040
viewsQ: PHP Table background color
$aux = mysql_num_rows($sql2); $html = ''; $html .= '<table border="1">'; $html .= '<tr>'; $html .= '<td colspan="3"><b><Center>'.$row[0].'…
-
1
votes2
answers436
viewsQ: Query SQL condition if
I have a problem in doing a query where I have 3 fields and just one of them is filled that no longer shows this result. Someone can help me do that? select * from tabelas where campo1 and campo2…
-
-2
votes1
answer93
viewsQ: Call Variable for php file name
I have a problem calling the variable name to the Excel file name. I have to put Variavel’s name on the file. The variable name comes from Select * ... //--- Fazendo o preenchimento inicial…
-
1
votes3
answers233
viewsQ: Add enumerator to a PHP table
I would like to add a sequential numerical enumerator (1, 2, 3, ...) to names that are obtained through a query. The end result would be: sequencial | Nome ----------------- 1 | João 2 | Pedro 3 |…
-
2
votes1
answer282
viewsQ: Export Excel PHP Workbench Variable data
I’m having doubts regarding generating an excel with the query. <?php include("conectar.php"); $id = $_GET['id']; $arquivo = 'Não autorizado .xls'; First question is this: In the $file part I can…
-
-2
votes2
answers143
viewsQ: Tabs with different PHP Query’s
I’m having difficulty creating a page with two tabs but each with a different query. <ul> <li><a href="#tabs-1">TAB1</a></li> <li><a…
phpasked ChrisAdler 1 -
4
votes3
answers12958
viewsQ: Generate Excel with php query
I need some help. I have a query in php and Mysql and would like to add to this query the option to export the data also to excel. It is possible to do this with php? <div id="tabs">…
-
-2
votes1
answer277
viewsQ: Query of date check
I have a normal query: select * from TABELAS Where (AlvaraNumero <> '0') and ( AlvaraValidade <> '0000-00-00' ) and ( AlvaraAnexo is NOT Null ) and ( AcidenteNumero <> '0') and (…
queryasked ChrisAdler 1 -
1
votes1
answer114
viewsQ: Galeria Fotografias
I’m having a little trouble making some changes to the photo gallery. http://jsfiddle.net/Qpm5g/ I’d like to make time for the images to play. I wish I could change the buttons to a corner on top of…
-
1
votes1
answer223
viewsQ: Table without color IE
I have a problem on the page of IE11 because I see the rectangle to White and in Chrome appears correctly. <form method="post" action="Procurarquery.php" enctype="multipart/form-data"> CSS:…
-
3
votes1
answer582
viewsQ: Google Images Chrome and IE
I’m making an HTML site. When opening the image, in PNG format, in Google Chrome (below) it appears correctly and when opening in IE 11 (above) it appears with pixels <td id="Autorizado"…
-
0
votes1
answer1505
viewsQ: html buttons dropdown menu
I have a drop down menu and when I move the mouse to the second chance it disappears. <nav> <ul class="menu"> <li><a href="#">Home</a> <ul> <li><a…
-
0
votes2
answers38817
viewsQ: How to define the dimensions of an HTML page?
I’m using Dreamweaver and now I’ve tried the website, and the page gets really wide. How I can control the width and height of the page?
htmlasked ChrisAdler 1 -
1
votes2
answers213
viewsQ: Show data and click on it to open
I have a question. I’m doing a job where I have a page that shows the name of a club. while($exibe = mysql_fetch_array($qr)){ echo '<p><h2>'.$exibe['Nome'].'</h2></p>'; } And…
phpasked ChrisAdler 1 -
-1
votes1
answer204
viewsQ: PHP page without background color in Internet Explorer
I have a problem opening a PHP page on the Internet Explore. It removes background colors. In Google Chrome opens all pages normally. <table style="width:100%;height:100%;" bgcolor="#4682B4"…
-
3
votes2
answers19115
viewsQ: Mysql Workbench Import and Export
I have a Mysql Workbench Database with the data filled and I want to pass this data all filled to another Mysql Workbench, but on another computer. Is it possible to do that or I’ll have to fill out…
-
-1
votes1
answer786
viewsQ: Query show image
I wonder if I can show an image depending on the name. $qr = mysql_query($sql) or die(mysql_error()); while($exibe = mysql_fetch_array($qr)){ echo'<div id="tabs-1"> <p>Nome:…
-
-3
votes3
answers161
viewsQ: Plicas and IF php problem
Parse error: syntax error, Unexpected 'if' (T_IF), expecting ',' or ';' in I have that error in the second line of this code: echo '<div id="tabs-2"> <p>Ficha de Aptidão Médica Validade:…
phpasked ChrisAdler 1 -
-1
votes2
answers369
viewsQ: Show php data inside tabs
I have a question about tabs. Previously had the data to be shown all within a table with pagination . Now my doubt is. with tabs divisions I have to open and close php every time I change tab? How…
phpasked ChrisAdler 1 -
0
votes1
answer260
viewsQ: html with jquery (tabs)
I’m having a problem getting tabs to work. I get the names of the tabs but not how they should appear inside a rectangle. because next I want to put the php data inside…
-
-1
votes1
answer76
viewsQ: Query php shows no expected result
I have a problem with a query because I ask to show me all fields that a certain condition that in a column is written 'Lisbon', but the result is: Lisbon and port. Query: Select * From…
-
-1
votes1
answer243
viewsQ: Paging with Switch
Where I choose my options: <span class="IWLABEL10CSS" id="IWLABEL7">Distrito</span> <select name="Distrito" size="1" width="180" class="COMBODISTCSS" id="COMBOFAB" tabindex="1">…
-
-5
votes3
answers247
viewsQ: Switch Result
<?php include("conectar.php"); $quantidade = 1; $pagina = (isset($_GET ['pagina'])) ? (int) $_GET['pagina'] : 1; $inicio = ($quantidade * $pagina) - $quantidade; $where =…
-
-3
votes2
answers483
viewsQ: Data type Date
I have a doubt and I do not know if it is possible in Html. Within a form I have several types of fields and one of them is the type DATE that receives (Day/month/Year) and now I wanted to change…
-
1
votes3
answers210
viewsA: Undefined variable when updating Database
Thank you guys. I’d jump a field when I got the data. enctype="multipart/form-data" $AcidenteAnexo=''; if (isset($_FILES["AcidenteAnexo"]) && $_FILES["AcidenteAnexo"]["name"] != '') {…
-
-1
votes3
answers210
viewsQ: Undefined variable when updating Database
I have a problem doing Database Update. $AcidenteValidade = $_POST["AcidenteValidade"]; $AcidenteAnexo=''; if (isset($_FILES["AcidenteAnexo"]) && $_FILES["AcidenteAnexo"]["name"] != '') {…
-
-2
votes1
answer145
viewsQ: Invalid variable
I have a problem because of an invalid variable. It always tells me that the variable AlvaraAnexo is invalid. <?php include("conectar.php"); $id = $_GET['id']; $sql = mysql_query("Select* From…
phpasked ChrisAdler 1 -
5
votes2
answers6999
viewsQ: How to change content of a select from another select
How can I put a button related to each other? Example: <span class="IWLABEL10CSS" id="IWLABEL7">Distrito</span> <select name="PAIS" size="1" width="180" class="COMBODISTCSS"…
-
-1
votes2
answers273
viewsQ: Switch with several POST
I have a question about the Switch . I want to put several options for a Switch and currently I have so and does not work: if (isset($_POST['estado'])&& ($_POST['Distrito'])) {…
-
2
votes2
answers491
viewsQ: Query Select Option PHP
How to do a query with select option that the user can choose? On the frontend: <form method="post" action="Procurarquery.php" enctype="multipart/form-data"> <span class="LABEL4CSS"…
-
1
votes3
answers2936
viewsQ: How to automatically fill in a field?
I have a form where I want to ask District and County using the Postal code and showing the fields I want with auto-fill. For example: One places the Postal Code "5489-698" and Aparece district and…
-
2
votes2
answers117
viewsQ: Highlight Data Filter
I’m having a problem highlighting data from a filter. In other words, I filter and show many dates. <?php include("conectar.php"); $quantidade = 1; $pagina = (isset($_GET ['pagina'])) ?…
-
3
votes3
answers32219
viewsA: Fetch last 7 days data from current date
$sql = "SELECT * FROM Tabelas WHERE Campos BETWEEN CURDATE() AND CURDATE() + INTERVAL 7 DAY";
-
9
votes1
answer58526
viewsQ: How do I make a SELECT in 2 or more Tables with 2 or more conditions?
I have a problem making a select with the following conditions: I want to show the data either with condition1 or with condition2 Select * tabela inner join tabela2 WHERE campo = 0 and campo2 = ''…
-
-1
votes2
answers702
viewsQ: Update data File
I have a question about changing FILE data. <?php include("conectar.php"); $id = $_GET['id']; $sql = mysql_query("Select* From tb_trabalhador WHERE id = $id"); while($exibe =…
-
2
votes1
answer5300
viewsQ: Query server problem has Gone away
An error occurred to me in the Query part mysql_query(): MySQL server has gone away What kind of mistake is this? Query: $sqlinsert = "INSERT INTO tb_trabalhador…
-
0
votes1
answer48
viewsQ: Include in the email only the dates that are about to end
I’m preparing an email to send, but I just want to include in it the dates that are to end within X days. At present I have so: while ($row = mysql_fetch_array($validade)) { $id = $row[0]; $Nome =…
-
3
votes1
answer247
viewsQ: Check records between today and 10 days in the future to send by email
I’m using Phpmailer to send an email with data when it’s 10 days away. When I send the email, all the records are showing up when the idea is to show up the logs between today and 10 days in the…
-
3
votes1
answer326
viewsQ: Problems sending FILE to Database
I have a problem sending FILE data to BD. With the help of @Zuul I came to this problem. <?php require("conectar.php"); //chama o arquivo de conexão ao BD if (isset($_POST['Nome'])) { $Nome =…
-
6
votes4
answers41617
viewsQ: Sign of different Query
I have a problem presenting the Query. I got the field alvaraValidade which only receives Data fields. When I put nothing in that field, the field date is guarded as 0000-00-00. $sql = "Select *…
-
3
votes3
answers9800
viewsQ: Mysql Workbench - Create Database based on EER Model (Forward Enginner Options)
Doubt: In Workbench I created the table in EER Diagram and now I want to connect to Hostname 127.0.0.1. The way I walk is Forward Engineer -> Next -> and then I have a lot of options, I have…