Spalten auslesen MySQL/ PHP Style anpassen

BreadScript · 7. Juli 2018

Hallo,

wie ist es möglich in PHP alle schleifen auszulesen und in einer Form anzeigen zu lassen ? Zum beispiel untereinander ?
Hat da jemand eine Idee für mich ? Ich verwende WAMP aktuell als Webserver und habe stelle wie folgt eine Datenbank verbindung her,

PHP: db.php

<?php
// Enter your Host, username, password, database below.
// I left password empty because i do not set password on localhost.
$con = mysqli_connect("localhost","fa","passwort","fa");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
?>

Xuki · 7. Juli 2018

Habs jetzt nicht getestet und auf die schnelle hingeklatscht^^
Aber kannst es mal so probieren.
Wird in dem Fall in einer Tabelle ausgegeben.

PHP

<?php
// Enter your Host, username, password, database below.
// I left password empty because i do not set password on localhost.
$con = mysqli_connect("localhost","fa","passwort","fa");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
  else
{
	$select = "SELECT * FROM Tabellenname";
	$res = mysqli_query($con, $select);
	$num = mysqli_num_rows($res);


	echo "
		<table>
			<tr>
				<th>X1</th>
				<th>X2</th>
			</tr>
	";


	while($ds = mysqli_fetch_assoc($res))
	{
		$x1 = "$ds[Spaltenname(DB)]";
		$x2 = "$ds[Spaltenname(DB)]";
		echo "
		<tr>
			<td>$x1</td>
			<td>$x2</td>
		</tr>
	";
	}
	echo "</table>
			<br/>";

Alles anzeigen

BreadScript · 7. Juli 2018

PHP

$select = "SELECT * FROM fahrzeuge";

gibt folgende Fehlermeldung aus

PHP

Parse error: syntax error, unexpected '$select' (T_VARIABLE) in C:\wamp64\www\schaden\view.php on line 6

Meine aktuelle PHP Datei

PHP

<?php
// Enter your Host, username, password, database below.
// I left password empty because i do not set password on localhost.
include("db.php")


$select = "SELECT * FROM fahrzeuge";
$res = mysqli_query($con, $select);
$num = mysqli_num_rows($res);
echo "
	<table>
		<tr>
			<th>X1</th>
			<th>X2</th>
		</tr>
";
while($ds = mysqli_fetch_assoc($res))
{
	$x1 = "$ds[id]";
	$x2 = "$ds[kennzeichen]";
	echo "
	<tr>
		<td>$x1</td>
		<td>$x2</td>
	</tr>
";
}
echo "</table>
		<br/>";

Alles anzeigen

datgame · 7. Juli 2018

Zitat von BreadScript

Meine aktuelle PHP Datei

In Zeile 4 fehlt ein ;

BreadScript · 8. Juli 2018

Fehler bleibt dennoch bestehen

Xuki · 8. Juli 2018

Datenbankverbindung funktioniert?
Sieht so aus, als könnte keine Verbindung mit der Datenbank hergestellt werden.

BreadScript · 8. Juli 2018

Funktioniert nun. Nun zum nächsten Problem, ich würde die Werte gerne nebeneinander anzeigen lassen. Max 3 Stück.

PHP

<!doctype html>
<!--[if gt IE 8]><!--> <html class="no-js" lang=""> <!--<![endif]-->
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>Onlinetool - Firma</title>
    <meta name="description" content="Sufee Admin - HTML5 Admin Template">
    <meta name="viewport" content="width=device-width, initial-scale=1">


    <link rel="apple-touch-icon" href="apple-icon.png">
    <link rel="shortcut icon" href="favicon.ico">


    <link rel="stylesheet" href="assets/css/normalize.css">
    <link rel="stylesheet" href="assets/css/bootstrap.min.css">
    <link rel="stylesheet" href="assets/css/font-awesome.min.css">
    <link rel="stylesheet" href="assets/css/themify-icons.css">
    <link rel="stylesheet" href="assets/css/flag-icon.min.css">
    <link rel="stylesheet" href="assets/css/cs-skin-elastic.css">
    <!-- <link rel="stylesheet" href="assets/css/bootstrap-select.less"> -->
    <link rel="stylesheet" href="assets/scss/style.css">
    <link href="assets/css/lib/vector-map/jqvmap.min.css" rel="stylesheet">


    <link href='https://fonts.googleapis.com/css?family=Open+Sans:400,600,700,800' rel='stylesheet' type='text/css'>


    <!-- <script type="text/javascript" src="https://cdn.jsdelivr.net/html5shiv/3.7.3/html5shiv.min.js"></script> -->


</head>
<body>




        <!-- Left Panel -->


    <aside id="left-panel" class="left-panel">
        <nav class="navbar navbar-expand-sm navbar-default">


            <div class="navbar-header">
                <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#main-menu" aria-controls="main-menu" aria-expanded="false" aria-label="Toggle navigation">
                    <i class="fa fa-bars"></i>
                </button>
                <a class="navbar-brand" href="./"><img src="images/logo.png" alt="Logo"></a>
                <a class="navbar-brand hidden" href="./"><img src="images/logo.png" alt="Logo"></a>
            </div>


            <?php
				include("menu.php");
				?>
        </nav>
    </aside><!-- /#left-panel -->


    <!-- Left Panel -->


    <!-- Right Panel -->


    <div id="right-panel" class="right-panel">


        <!-- Header-->
        <header id="header" class="header">


            <div class="header-menu">


                <div class="col-sm-7">
                </div>


                <div class="col-sm-5">
                    <div class="user-area dropdown float-right">
                        <a href="#" class="dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                            <img class="user-avatar rounded-circle" src="images/admin.jpg" alt="User Avatar">
                        </a>


                        <div class="user-menu dropdown-menu">
                                <a class="nav-link" href="#"><i class="fa fa- user"></i>Mein Profil</a>


                                <a class="nav-link" href="#"><i class="fa fa -cog"></i>Einstellungen</a>


                                <a class="nav-link" href="#"><i class="fa fa-power -off"></i>Logout</a>
                        </div>
                    </div>
                </div>
            </div>


        </header><!-- /header -->
        <!-- Header-->


        <div class="breadcrumbs">
            <div class="col-sm-4">
                <div class="page-header float-left">
                    <div class="page-title">
                        <h1>Startseite</h1>
                    </div>
                </div>
            </div> 
        </div>
<?php
// Enter your Host, username, password, database below.
// I left password empty because i do not set password on localhost.
include("db.php");
$select = "SELECT * FROM fahrzeuge";
$res = mysqli_query($con, $select);
$num = mysqli_num_rows($res);
while($ds = mysqli_fetch_assoc($res))
{
	$x1 = "$ds[id]";
	$x2 = "$ds[kennzeichen]";


echo '<div class="content mt-3">';
echo '<div class="col-md-4">';
echo '<div class="card">';
echo '';
echo '<div class="card-body">';
echo '<div class="mx-auto d-block">';
echo '<img class="rounded-circle mx-auto d-block" src="images/auto.png" alt="Card image cap">';
echo '<h5 class="text-sm-center mt-2 mb-1">';
echo "$x2";
echo '';
echo '</h5>';
echo '';
echo '</div>';
echo '<hr>';
echo '<div class="card-text text-sm">';
echo 'W';
echo '';
echo '</div>';
echo '</div>';
echo '</div>';
echo '</div>';
echo '</div>';




}


?>
 </div> <!-- .content -->
    </div><!-- /#right-panel -->
	 <script src="assets/js/vendor/jquery-2.1.4.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.3/umd/popper.min.js"></script>
    <script src="assets/js/plugins.js"></script>
    <script src="assets/js/main.js"></script>




    <script src="assets/js/lib/chart-js/Chart.bundle.js"></script>
    <script src="assets/js/dashboard.js"></script>
    <script src="assets/js/widgets.js"></script>
    <script src="assets/js/lib/vector-map/jquery.vmap.js"></script>
    <script src="assets/js/lib/vector-map/jquery.vmap.min.js"></script>
    <script src="assets/js/lib/vector-map/jquery.vmap.sampledata.js"></script>
    <script src="assets/js/lib/vector-map/country/jquery.vmap.world.js"></script>
    <script>
        ( function ( $ ) {
            "use strict";


            jQuery( '#vmap' ).vectorMap( {
                map: 'world_en',
                backgroundColor: null,
                color: '#ffffff',
                hoverOpacity: 0.7,
                selectedColor: '#1de9b6',
                enableZoom: true,
                showTooltip: true,
                values: sample_data,
                scaleColors: [ '#1de9b6', '#03a9f5' ],
                normalizeFunction: 'polynomial'
            } );
        } )( jQuery );
    </script>

Alles anzeigen

aktuell werden sie untereinander angezeigt. Was kann ich ändern

Canna · 9. Juli 2018

Da du Bootstrap verwendest, schau dir einmal das Grid System an.

breadfish.de 12. März 2022