Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- `<tr>
- <?php
- $dbserver = 'localhost';
- $dbuser = 'root';
- $dbpass = '';
- $con = mysql_connect($dbserver, $dbuser, $dbpass);
- if(!$con)
- {
- die('Could not connect to database!' . mysql_error());
- }
- mysql_select_db('thisdb');
- $sql = 'SELECT * FROM rawitems';
- $resval = mysql_query($sql,$con);
- if (!$resval) {
- die ('SQL Error: ' . mysql_error($con));
- }
- while ($row = mysql_fetch_array($resval))
- {
- number_format($row['amount']);
- echo '<tr>
- <td>'.$row['id_raw'].'</td>
- <td>'.$row['prodname'].'</td>
- <td>'.$row['kl'].'</td>
- <td>'.$row['ounce'].'</td>
- <td>'.$row['gram'].'</td>
- <td>'.$row['quantity'].'</td>
- <td>'.$row['price'].'</td>
- <td>'.$row['supplier'].'</td>
- <td>'.$row['dateclaim'].'</td>
- <td>'.$row['shelflife'].'</td>
- <td><input type=number name="aji" style="width:100%;" ></td>
- <td><center><input type=submit value="UPDATE" id="button1"></center></td>
- </tr>';
- }?>
- </tr>
- <tr>
- <td><input type=textbox name="a1" style="width:100%;" disabled="disabled" value='<?php echo $SNUM; ?>' required></td>
- <td><input type=textbox name="a2" style="width:100%;" required></td>
- <td><input name="a3" step="any" id="inputKL" type="number" oninput="weightConverter(this.id,this.value)" onchange="weightConverter(this.id,this.value)" style="width:100%;" required></td>
- <td><input name="a4" step="any" id="inputOZ" type="number" oninput="weightConverter(this.id,this.value)" onchange="weightConverter(this.id,this.value)" style="width:100%;" required></td>
- <td><input name="a5" step="any" id="inputGrams" type="number" oninput="weightConverter(this.id,this.value)" onchange="weightConverter(this.id,this.value)" style="width:100%;" required></td>
- <td><input step="any" type="number" name="a6" style="width:100%;" required></td>
- <td><input step="any" type="number" name="a7" style="width:100%;" required></td>
- <td><input type=textbox name="a8" style="width:100%;" required></td>
- <td><input name="a9" style="width:100%;" id="date" type="date" required></td>
- <td><input name="a10" style="width:100%;" id="date" type="date" required></td>
- <TD></TD>
- <td><center><input type=submit value="SAVE" id="button" onclick="kk();"></center></td>
- </table>
- <br/>
- <br/>
- <br/>
- <center> <button id="button" type="submit" name="button_logout">LOGOUT</button></center>`
Add Comment
Please, Sign In to add comment