Exemplo n.º 1
0


<html>
<head>	
	<title>Edit Data</title>
</head>

<?php 
// including the database connection file
include "mysql.php";
$connection = new createCon();
$connection->connect();
session_start();
//getting id from url
if (isset($_GET['nid'])) {
    $nid = $_GET['nid'];
} else {
    echo "nid nicht gesetzt";
}
$abfrage = "SELECT * FROM nahrung WHERE n_id='{$nid}'";
//selecting data associated with this particular id
$result = mysqli_query($connection->myconn, $abfrage);
while ($row = mysqli_fetch_array($result)) {
    $bez = $row['bez'];
    $menge = $row['menge'];
    $kalorien = $row['kalorien'] / $menge;
    $eiweiss = $row['eiweiss'] / $menge;
    $kohlenhydrate = $row['kohlenhydrate'] / $menge;
    $fett = $row['fett'] / $menge;
}
Exemplo n.º 2
0
<?php

include 'connect.php';
// Database Connection
//$host="ftp.imoucf.org";
//$uname="*****@*****.**";
//$pass="******";
//$database = "imoucfor_mrs";
$conn = new createCon();
//echo $conn->host;
$conn->connect();
$link = $conn->conn;
//mysql_connect($host,$uname,$pass);
//echo mysql_error();
//or die("Database Connection Failed");
$selectdb = mysqli_select_db($link, $conn->db) or die("Database could not be selected");
$result = mysqli_select_db($link, $conn->db) or die("database cannot be selected <br>");
$output = "";
$table = "SUM15";
$sql = mysqli_query($link, "select * from {$table}");
$columns_total = mysqli_num_fields($sql);
// Get fields
for ($i = 0; $i < $columns_total; $i++) {
    $heading = mysqli_fetch_field_direct($sql, $i);
    $output .= '"' . $heading->name . '",';
}
$output .= "\n";
// Get records
while ($row = mysqli_fetch_array($sql)) {
    for ($i = 0; $i < $columns_total; $i++) {
        $output .= '"' . $row["{$i}"] . '",';