Anonymní profil Rastislav – Programujte.com

Příspěvky odeslané z IP adresy 90.176.10.–

Rastislav

PHP › mysql list pridanie policka…

20. 12. 2018 #382619

Chci docílit: vypisat data s mysql tabulky na koniec kazdeho zaznamu pridat policko input s numerickou hodnotou aby v nom bolo mozne menit udaje a nasledne vsetko odoslat do inej tabulky.

Kusal som nieco take no neviem to odoslat do tabulky

KOd:

</div>


<div id="rightcolumn"> ...
<form method="POST">
<label>Editovať údaje :
<input type="submit" name="save" value="save">
</label>
<?php
$con=mysqli_connect("localhost","root","","mat_szm");

// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
mysqli_query($con, "SET NAMES 'utf8'");

$result = mysqli_query($con,"SELECT * FROM material");
echo " <table border='1' align='center'>
<tr>
<th>Kod_CPV :</th>
<th>Názov :</th>
<th>Množstvo :</th>
</tr>" ;
while($row = mysqli_fetch_array($result))
{
$id = $row['ID'];
echo "<tr>";
echo "<td bgcolor=#CCCCCC> <b>". $row['Kod_CPV'] ."</b> </td>";
echo "<td>" . $row['Nazov'] . "</td>";
echo "<td>" . '<input type="number" name="s"[ ] value="0">' . "</td>";
echo "</tr>";
}
echo "</table></div>";

mysqli_close($con);
?>
</form>
</div>

Rastislav

PHP › Chyba v kode, neviem si rady

19. 12. 2018 #382608

#2 peter
Premenoval jsem sloupce v tabulke a uz to funguje diky moc za radu.

Rastislav

PHP › Chyba v kode, neviem si rady

19. 12. 2018 #382604

Dobry den,

potreboval by som najst chybu v kode PHP. Stale mi to vypisuje tuto chybu :

Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:\xampp\htdocs\newSZM\admin\editxxx.php on line 102

Riadok 102 v kode je tučny a podtrhnuty.

Ked si dam vypisat udaje pomocou echo pred pouzitim UPDATE tak ich vidim ale v tabulke nedojde k zmene.

Zdrojový kod :

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>2 Column - fw-12-2-col</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link rel="stylesheet" type="text/css" rel="nofollow" href="styles.css" />
<link rel="stylesheet" type="text/css" rel="nofollow" href="style.css" />
</head>
<body>

<div id="wrapper">

<div id="header"><h1>Objednávkový systém ŠZM</h1></div>


<div id="leftcolumn"> Menu Administrátor

<div class="container">

<ul>
<li class="dropdown">
<input type="checkbox" />
<a rel="nofollow" href="#" data-toggle="dropdown">Materiál</a>
<ul class="dropdown-menu">
<li><a rel="nofollow" href="index.php">Pridanie materiálu</a></li>
<li><a rel="nofollow" href="edituj.php">Editovanie materiálu</a></li>
<li><a rel="nofollow" href="tab/index2.php">Vymazanie materiálu</a></li>
<li><a rel="nofollow" href="index1.php">Výpis všetkého mat.</a></li>
</ul>
</li>
<li class="dropdown">
<input type="checkbox" />
<a rel="nofollow" href="#" data-toggle="dropdown">Objednávky</a>
<ul class="dropdown-menu">
<li><a rel="nofollow" href="zam/index1.php">Vytvorenie objednávky</a></li>
<li><a rel="nofollow" href="zam/index2.html">Editácia objednávky</a></li>
<li><a rel="nofollow" href="zam/index3.html">Vymazanie objednávky</a></li>
<li><a rel="nofollow" href="zam/index4.php">Prehľad objednávok mes.</a></li>
<li><a rel="nofollow" href="zam/index5.html">Prehľad objednávok rok</a></li>
</ul>
</li>
<li class="dropdown">
<input type="checkbox" />
<a rel="nofollow" href="#" data-toggle="dropdown">Žiadanky</a>
<ul class="dropdown-menu">
<li><a rel="nofollow" href="#">Vytvorenie žiadanky</a></li>
<li><a rel="nofollow" href="#">Vytvorenie všetkých žiadaniek</a></li>
</ul>
</li>
</ul>
</div>

</div>


<div id="rightcolumn"> ...

<?php
$idx =$_REQUEST['ID'];
// Prepisanie dat pomocou UPDATE
$con=mysqli_connect("localhost","root","","mat_szm");

mysqli_query($con, "SET NAMES 'utf8'");

$result = mysqli_query($con, "SELECT * FROM material WHERE ID = '$idx' ");
$test = mysqli_fetch_array($result);
if (!$result)
{
die("Error: Data not found..");
}
$s1=$test['Kod CPV'] ;
$s2=$test['Nazov'] ;
$s3=$test['Cena'] ;
$s4=$test['Merná jednotka'] ;
$s5=$test['Skladom'] ;
if(isset($_POST['save']))
{

$s1_save = $_POST['x1'];
$s2_save = $_POST['x2'];
$s3_save = $_POST['x3'];
$s4_save = $_POST['x4'];
$s5_save = $_POST['x5'];
mysqli_query($con,"UPDATE material SET
Kod CPV = '$s1_save' ,
Nazov = '$s2_save' ,
Cena = '$s3_save' ,
Merná jednotka = '$s4_save' ,
Skladom = '$s5_save'
WHERE ID = '$idx'")
or die(mysqli_error()); // Toto je riadok 102 a neviemco je zle ?
echo "Uložené !";
mysqli_close($con);

}
// Koniec UPDATE
?>

<form method="POST">
<label>Nahrať opravenú objednávku :
<input type="submit" name="save" value="save">
</label>
<table width="837" border="3" bordercolor="#000000" bgcolor="#CCCCCC">
<tr>
<th width="124" scope="col"><span class="style12">*<span class="style13"> Kod CPV </span></span></th>
<th width="374" scope="col"><span class="style12">*<span class="style13"> Nazov </span></span></th>
<th width="134" scope="col"><span class="style12">*<span class="style13"> Cena </span></span></th>
<th width="173" scope="col"><span class="style12">*<span class="style13"> Merná jednotka </span></span></th>
<th width="173" scope="col"><span class="style12">*<span class="style13"> Skladom </span></span></th>
</tr>
<td><label>
<div align="center">
<input type="text" name="x1" value="<?php echo $s1 ?>"/>
</div>
</label></td>
<td><label>
<div align="center">
<input type="text" name="x2" value="<?php echo $s2 ?>"/>
</div>
</label></td>
<td><label>
<div align="center">
<input type="number" name="x3" value="<?php echo $s3 ?>"/>
</div>
</label></td>
<td><label>
<div align="center">
<input type="text" name="x4" value="<?php echo $s4 ?>"/>
</div>
</label></td>
<td><label>
<div align="center">
<input type="number" name="x5" value="<?php echo $s5 ?>"/>
</div>
</label></td>
</div>




</div>

</body>
</html>

Rastislav

PHP › Jak odoslat tabulku nacitanu…

15. 11. 2018 #382328

#2 peter
toto viem ale ja potrebujem v tej vytvorenej tabulke pridat mnozstvo a potom to cele poslat do inej tabulky s mnozstvom na konci kazdeho riadku je moznost zmenit mnozstvo v povodnej tabulke su vsetky udaje okrem mnozstva.

Rastislav

PHP › Jak odoslat tabulku nacitanu…

15. 11. 2018 #382324

Poprosil by som o pomoc. Nacitam tabulku s SQL a pridam policko input. Ako vsetky udaje dostat do inej tabulky. prikladam kod na vypis tabulky. Udaje odosielam skriptom send.php

Kod :

mysqli_query($con, "SET NAMES 'utf8'");

$result = mysqli_query($con,"SELECT * FROM 1_roztoky");
echo " <table border='1' align='center'>
<tr>
<th>Názov tovaru :</th>
<th>Popis položky :</th>
<th>Rozmer :</th>
<th>Počet ks v bal. :</th>
<th>Cena za ks :</th>
<th>Cena s DPH za ks :</th>
<th>Katalogové číslo :</th>
<th>Dodávateľ :</th>
<th>Obj. množstvo :</th>
</tr>" ;
while($row = mysqli_fetch_array($result))
{
$id = $row['ID'];
echo "<tr>";
echo "<td bgcolor=#CCCCCC> <b>". $row['Nazov_tovaru'] ."</b> </td> ";
echo "<td>" . $row['Popis_polozky'] . "</td>";
echo "<td>" . $row['Rozmer'] . "</td>";
echo "<td>" . $row['p_ks_bal'] . "</td>";
echo "<td>" . $row['cena_ks'] . "</td>";
echo "<td>" . $row['cena_s_DPH'] . "</td>";
echo "<td>" . $row['katalogove_cislo'] . "</td>";
echo "<td>" . $row['dodavatel'] . "</td>";
echo "<td>" .'<input type="number" name="s".[$id] value="0">' ."</td>";

echo "</tr>";
}
echo "</table></div>";
mysqli_close($con);
?>
Ako vystup dostanem nieco take :

Připojen obrázek.