Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +----+------+-------+-----------+-----------+
- | id | name | state | xcoord | ycoord |
- +----+------+-------+-----------+-----------+
- | 1 | lake | CA | 36.746585 | 22.234564 |
- | 2 | pond | TX | 26.123123 | 12.456789 |
- +----+------+-------+-----------+-----------+
- "; ?>
- ID Name State X Coord Y Coord
- {$row['id'] {$row["name"] {$row["state"]} {$row["xcoord"]} {$row["ycoord"]}
- <?php
- /*
- * db.inc.php
- * These are the DBMS credentials and the database name
- */
- $hostName = "xxxx";
- $databaseName = "yyyy";
- $username = "zzzz";
- $password = "wwww";
- // Show an error and stop the script
- function showerror()
- {
- if (mysql_error())
- die("Error " . mysql_errno() . " : " . mysql_error());
- else
- die ("Could not connect to the DBMS");
- }
- ?>
- <html>
- <head>
- <title>Locations</title>
- </head>
- <body>
- <table border=1>
- <tr>
- <th>ID</th>
- <th>Name</th>
- <th>State</th>
- <th>X Coord</th>
- <th>Y Coord</th>
- </tr>
- <?php
- include 'db.inc.php';
- // Connect to MySQL DBMS
- if (!($connection = @ mysql_connect($hostName, $username, $password)))
- showerror();
- // Use the location database
- if (!mysql_select_db($databaseName, $connection))
- showerror();
- // Create SQL statement
- $query = "SELECT * FROM locations"; // the table name is "locations"
- // Execute SQL statement
- if (!($result = @ mysql_query ($query, $connection)))
- showerror();
- // Display results *** My inclination is that something is awry with the following echo
- while ($row = @ mysql_fetch_array($result))
- echo "<tr>
- <td>{$row['id']</td>
- <td>{$row["name"]</td>
- <td>{$row["state"]}</td>
- <td>{$row["xcoord"]}</td>
- <td>{$row["ycoord"]}</td>
- </tr>";
- ?>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement