Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Removal of line from database table

Kadir

I'm making a conclusion. row:

    <?php
    session_start();
$sql = mysql_query("SELECT * FROM users WHERE id='".$_SESSION['id']."'");
$row = mysql_fetch_array($sql);

?&gt;
&lt;html&gt;
&lt;head&gt;
&lt;/head&gt;
&lt;body&gt;

<?php echo $row['loc'];  ?>

</body>

</html>

Please tell me what the mistake is.

morde last edited by

Initially, we need to connect to the OBD system and then only select and store data and data.
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

Pass variable php in javascript function
Software Programming • javascript php laravel • • Analeea

2

0
Votes

2
Posts

0
Views

D

It is important to know that PHP runs on the server, and returns HTML. JavaScript can be written within HTML tags. So to pass a PHP value to JavaScript is just do:<?php $valorNoPHP = 'meu valor veio do PHP'; ?> <script> var variavelJavaScriptComValorDoPHP = '<?= $valorNoPHP ?>'; </script>
A

Configure localhost to display header send warnings
Software Programming • php • • amarantha

2

0
Votes

2
Posts

0
Views

You can configure displaying errors in two places in php.ini or directly in a file.php. iniOpen the file and add or modify the line:error_reporting = E_ALL | E_STRICT This says to display all kinds of errors and warnings E_ALL is enough but in php5.3 some warnings have been separated to E_STRICT, then keeping the two is more question of compatibility and certainty that all types of errors/warnings will be displayed.By fileCan display errors/warnings of only one particular file with the use of functions error_reporting() and ini_set().The first function overwrites the default value(which comes from php.ini) of the directive display_errors to display errors other possible pass value is -1 that has the same effect as true. The second function defines the level of errors that will be displayed.<?php ini_set('display_errors', true); error_reporting(E_ALL|E_STRICT); $str = 'inválido'
Help to convert from mysql to mysqli
Software Programming • mysql mysqli • • morde

2

0
Votes

2
Posts

0
Views

C

Do as follows:In connection with the database:$link = mysqli_connect("localhost", "user", "senha", "banco") or die("Erro a conectar"); And whenever it is necessary to use mysqli query you call the $link variable, as follows:$sql = mysqli_query($link, "SELECT * from tabela WHERE row='$row'"); The case repeats for all parameters of mysqli.
C

How to number MySQL query results?
Software Programming • mysql sql • • courtlanda

2

0
Votes

2
Posts

0
Views

D

Try this code:set @row_num = 0; SELECT @row_num := @row_num + 1 as row_index, Departamento, ROUND(AVG(EDAD),2) as Media_Depart FROM tabla_a GROUP BY Departamento; If what you want is to order the results test with this:set @row_num = 0; SELECT @row_num := @row_num + 1 as Ranking, Departamento, ROUND(AVG(EDAD),2) as Media_Depart FROM tabla_a GROUP BY Departamento ORDER BY Ranking;
Z

How to remove repetitive lines
Software Programming • c sharp • • zymir

2

0
Votes

2
Posts

0
Views

K

Group the text, separate each price group and select one element from the group:foreach (DataRow row in price_table.Rows .Cast<DataRow>() .GroupBy(row => row.Field<string>("text")) .Select(g => g.OrderBy(r => r.Field<int>("Price")).First())) { row.Delete(); } price_table.AcceptChanges();
J

Repeat Data in an Arrangement
Software Programming • php json mvc • • jonetta

2

0
Votes

2
Posts

0
Views

Z

This is a simple example that clones a JSON using JSON and another one using JQUERY, I hope it serves you. The code is commented for better understanding.<!DOCTYPE html> <html> <head> <title>Prueba</title> </head> <body> <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.js" ></script> <script type="text/javascript"> (function ($) { //clonar usando JSON function fnCloneJSON (obj) { return JSON.parse(JSON.stringify(obj)); } //clonar usando jQuery function fnClonejQuery (arr) { return $.extend(true, [], arr); } //ejemplo de un formato JSON var list = [{x:2, y:3}, {x:5, y:8}]; //clonamos var clone1 = fnCloneJSON(list), clone2 = fnClonejQuery(list); //aqui concatenamos var nuevo = clone1.concat(clone2); console.log("Este es nuevo:", nuevo); })(jQuery); </script> </body> </html>
J

Numbering of the same ID in MTSQL withdrawal
Software Programming • mysql • • jonetta

2

0
Votes

2
Posts

0
Views

Table datatable (num, val)♪SELECT num, @num:=1+@num*(num=@prev) pos, val*(num=(@prev:=num)) val FROM datatable, (SELECT @prev:='',@num:=0) x ORDER BY num; Change the names of the table and the fields on your own, no matter what.PS. The method of numbering values in a group with one order number may not be consistent with the starting point of withdrawal in the reference table.
N

Accession of database tables
Software Programming • sql server sql delphi • • Nykeriab

2

0
Votes

2
Posts

0
Views

R

Putting in shape. TADOConnection, give him a line of connection. For MS SQL Server, something like:Provider=SQLNCLI.1;Persist Security Info=False;User ID=sa;Data Source=127.0.0.1Then you're walking. TADOTableindicating as Connection yours TADOConnection and rely on the right table. After that, you're pulling into shape. TDataSource, you give him the meaning of the properties DataSet yours. TADOTableand already chained components to work with the fields (e.g. Data Controls).
C

Removing the line on the cable
Software Programming • javascript dom • • courtlanda

2

0
Votes

2
Posts

0
Views

E

That's right. nodeParent a parentNode♪To search the nearest tr Use the function closest♪Let's go through. remove♪So you've got the code almost right, and there's only a little to do.Also in your code, you've moved the cycle to a more beautiful and modern view.var buttons = document.querySelectorAll('button'); for (var b of buttons) { b.onclick = function() { var el = this.closest("tr"); el.remove(); } }table { border: 1px solid black; } td { padding: 5px; } button { width: 50px; height: 50px; }<!DOCTYPE HTML> <html> <head> <meta charset="utf-8"> <link rel="stylesheet" href="style.css"> </head> <body> <table> <tr> <td><button type="button"></button></td> <td>...</td> <td>...</td> <td>...</td> <td>...</td> <td>...</td> <td>...</td> <td>111</td> </tr> <tr> <td><button type="button"></button></td> <td>...</td> <td>...</td> <td>...</td> <td>...</td> <td>...</td> <td>...</td> <td>222</td> </tr> <tr> <td><button type="button"></button></td> <td>...</td> <td>...</td> <td>...</td> <td>...</td> <td>...</td> <td>...</td> <td>333</td> </tr> </table> </body> </html>
How to find a link inside a html file and exchange for another link?
Software Programming • php • • Demir

2

0
Votes

2
Posts

0
Views

G

To perform replacement can use str_replace or preg_replace.In this case just change to:<?php //... if(preg_match("/arquivo.txt/",$le)){ $conteudo = str_replace("arquivo.txt", "novo_arquivo.txt", $le); // Alternativa: preg_replace("/\barquivo.txt\b/", "novo_arquivo.txt", $le); // Substitui o arquivo.txt por novo_arquivo.txt fwrite($aq, $conteudo); // Escreve o conteúdo editado. } //.. ?> Ideal solution:Abandon fopen, it will be easier and will not have such loss of performance.<?php //... foreach ($arquivos as $caminho){ $conteudoArquivo = file_get_contents($caminho); // Isso irá pegar todo o conteudo do arquivo if(preg_match("/arquivo.txt/", $conteudoArquivo)){ // Se existir arquivo.txt $conteudoEditado = str_replace("arquivo.txt", "novo_arquivo.txt", $conteudoArquivo); // Novo $conteudoEditado terá a alteração file_put_contents($caminho, $conteudoEditado); // Salva as alterações } } //.. ?> Important (function feof()There are some cases where feof() can create an infinite loop, including examples in PHP documentation, which can be accessed http://php.net/manual/pt_BR/function.feof.php .
Write a function that takes a set of lines, and removes a line that somehow took the elements from the end and began
Software Programming • javascript liabilities • • Demir

2

0
Votes

2
Posts

0
Views

If it's very simple, it's as simple as that. const f = array => { let clone = [...array]; let length = clone.length; let result = ''; for(let i = 0; i < length; i++){ result += i % 2 === 0 ? clone.shift() : clone.pop(); } return result; } console.log(f(["a", "b", "c", "d", "e", "f"])); console.log(f(["a", "b", "c", "d", "e"]));Even better...const f = array => array.reduce((result, item, index, array) => { let i = Math.floor(index / 2); let length = array.length - 1; let isEven = index % 2 === 0; let word = array[isEven ? i : length - i]; return result + word; }, ''); console.log(f(['a', 'b', 'c', 'd', 'e', 'f'])); console.log(f(['a', 'b', 'c', 'd', 'e']));
A

Avoid repeating html table lines on a mysql table in php
Software Programming • php html mysql • • Amritpal

2

0
Votes

2
Posts

0
Views

K

This is the final code making modifications. It is true that it contained unnecessary code, but the result was giving it to me. The problem had it in the for that did not pass from the first value of the array.<div id="categorias"> <table> <caption>GASTOS POR CATEGORIAS</caption> <tbody> <?php $query = "select DISTINCTROW tipo from viaje WHERE viaje_nombre= '".$Reg."'"; $result = mysqli_query($conn,$query); //$row=$result->fetch_assoc(); $count = mysqli_num_rows($result); //Bucle for para rellenar a array @valoresTipo for ($i = 0; $i < $count; $i++) { $valorTipo = mysqli_fetch_array($result); $valoresTipo[$i] = $valorTipo["tipo"]; } ?> <tr> <?php for ($i = 0; $i < $count; $i++) { ?> <th><?php echo $valoresTipo[$i]; ?></th> <td><?php $query="SELECT CONCAT(SUM(cantidad), ' €') '".$valoresTipo[$i]."' FROM viaje WHERE tipo = '".$valoresTipo[$i]."' and viaje_nombre= '".$Reg."'"; $result = mysqli_query($conn,$query); $row=mysqli_fetch_assoc($result); //Si no hay gasto poner '0 €' if (!empty($row[$valoresTipo[$i]])){ echo $row[$valoresTipo[$i]]; ?></td> <?php } else { echo '0 €'; ?></td> <?php } ?> </tr> <?php } //FIN FOR ?> </tbody> </table>
S

How to concatenate the records of two columns?
Software Programming • mysql functions • • simrah

2

0
Votes

2
Posts

0
Views

E

First of all, do backup your database and information related to it. Sometimes very large changes https://dev.mysql.com/doc/refman/5.7/en/crashing.html .The function to concatenate the tuples in the database is the https://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_concat . It returns the sequence that results from the contention of the arguments, and it may have one or more arguments.In your case, to concatenate column values nome and sobrenome, just run the following code:UPDATE tabela set nome = concat(nome, " ", sobrenome); In advance I took the freedom to add a blank space (" "), so that it would be adding a space between concatenation. If you don't want just run this query instead of the first:UPDATE tabela set nome = concat(nome, sobrenome); You can also see this http://sqlfiddle.com/#!9/f59a79c/1 that demonstrates the way to accomplish what you want.
N

Choose lines from the table, by condition from another table
Software Programming • mysql select • • nishika

2

0
Votes

2
Posts

0
Views

J

Your request is incorrect, he'll give out the extra notes. Prove it.SELECT `history_oper`.* FROM `history_oper` INNER JOIN err_opers ON `history_oper`.`date_oper` = err_opers.dat AND `user_phone` = err_opers.tel WHERE `sms` LIKE CONCAT('%',err_opers.sum,'%')
B

Request from one table, linking the number of lines from another table
Software Programming • sql delphi firebird interbase • • Burma

2

0
Votes

2
Posts

0
Views

D

Use it. outer join:inner join - Category left join

Removal of line from database table

Suggested Topics

Pass variable php in javascript function Software Programming • javascript php laravel • • Analeea

Configure localhost to display header send warnings Software Programming • php • • amarantha

Help to convert from mysql to mysqli Software Programming • mysql mysqli • • morde

How to number MySQL query results? Software Programming • mysql sql • • courtlanda

How to remove repetitive lines Software Programming • c sharp • • zymir

Repeat Data in an Arrangement Software Programming • php json mvc • • jonetta

Numbering of the same ID in MTSQL withdrawal Software Programming • mysql • • jonetta

Accession of database tables Software Programming • sql server sql delphi • • Nykeriab

Removing the line on the cable Software Programming • javascript dom • • courtlanda

How to find a link inside a html file and exchange for another link? Software Programming • php • • Demir

Write a function that takes a set of lines, and removes a line that somehow took the elements from the end and began Software Programming • javascript liabilities • • Demir

Avoid repeating html table lines on a mysql table in php Software Programming • php html mysql • • Amritpal

How to concatenate the records of two columns? Software Programming • mysql functions • • simrah

Choose lines from the table, by condition from another table Software Programming • mysql select • • nishika

Request from one table, linking the number of lines from another table Software Programming • sql delphi firebird interbase • • Burma

Pass variable php in javascript function
Software Programming • javascript php laravel • • Analeea

Configure localhost to display header send warnings
Software Programming • php • • amarantha

Help to convert from mysql to mysqli
Software Programming • mysql mysqli • • morde

How to number MySQL query results?
Software Programming • mysql sql • • courtlanda

How to remove repetitive lines
Software Programming • c sharp • • zymir

Repeat Data in an Arrangement
Software Programming • php json mvc • • jonetta

Numbering of the same ID in MTSQL withdrawal
Software Programming • mysql • • jonetta

Accession of database tables
Software Programming • sql server sql delphi • • Nykeriab

Removing the line on the cable
Software Programming • javascript dom • • courtlanda

How to find a link inside a html file and exchange for another link?
Software Programming • php • • Demir

Write a function that takes a set of lines, and removes a line that somehow took the elements from the end and began
Software Programming • javascript liabilities • • Demir

Avoid repeating html table lines on a mysql table in php
Software Programming • php html mysql • • Amritpal

How to concatenate the records of two columns?
Software Programming • mysql functions • • simrah

Choose lines from the table, by condition from another table
Software Programming • mysql select • • nishika

Request from one table, linking the number of lines from another table
Software Programming • sql delphi firebird interbase • • Burma