xymalf99
-
Posts
2 -
Joined
-
Last visited
xymalf99's Achievements
Newbie (1/5)
0
Reputation
-
I have created a simple add links database http://www.xymalf.co.uk/AED/index.php how do i make the links clickable in SQL?
-
[the database connection file db.php] <?php session_start(); //connect.php DEFINE ('DB_HOST','217.174.253.159'); DEFINE ('DB_USER','xymalfco3'); DEFINE ('DB_PASSWORD','tArq*****'); DEFINE('DB_NAME','xymalfco3'); $dbc =@mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) OR die('Could not connect to MySql:'. mysqli_connect_error() ); ?> [/db] ============================================================================== [the index file] <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Books</title> </head> <body> <form method="post"> <table> <tr> <td>WebsiteTitle:</td> <td><input type="text" name="websitetitle" /></td> </tr> <tr> <td>Link</td> <td><input type="text" name="link" /></td> </tr> <tr> <td>WebMaster</td> <td><input type="text" name="webmaster" /></td> </tr> <tr> <td>Description</td> <td><input type="text" name="description" /></td> </tr> <tr> <td> </td> <td><input type="submit" name="submit" value="add" /></td> </tr> </table> <?php if (isset($_POST['submit'])) { include 'db.php'; $websitetitle=$_POST['websitetitle'] ; $link= $_POST['link'] ; $webmaster=$_POST['webmaster'] ; $description=$_POST['description'] ; mysql_query("INSERT INTO `links`(WebsiteTitle,Link,WebMaster,Description) VALUES ('$websitetitle','$link','$webmaster','$description')"); } ?> </form> <table border="1"> <?php include("db.php"); $result=mysql_query("SELECT * FROM links"); while($test = mysql_fetch_array($result)) { $id = $test['LinkID']; echo "<tr align='center'>"; echo"<td><font color='black'>" .$test['LinkID']."</font></td>"; echo"<td><font color='black'>" .$test['WebsiteTitle']."</font></td>"; echo"<td><font color='black'>". $test['Link']. "</font></td>"; echo"<td><font color='black'>". $test['WebMaster']. "</font></td>"; echo"<td><font color='black'>". $test['Description']. "</font></td>"; echo"<td> <a href ='view.php?LinkID=$id'>Edit</a>"; echo"<td> <a href ='del.php?LinkID=$id'><center>Delete</center></a>"; echo "</tr>"; } mysql_close($dbc); ?> </table> </body> </html> [nb view and edit php are not showing don't know why is this a tree directory issue? ] ----------------------------------------------- [view.php] <?php require("db.php"); $id =$_REQUEST['LinkID']; $result = mysql_query("SELECT * FROM links WHERE LinkID = '$id'"); $test = mysql_fetch_array($result); if (!$result) { die("Error: Data not found.."); } $WebsiteTitle=$test['WebsiteTitle'] ; $Link= $test['Link'] ; $WebMaster=$test['WebMaster'] ; $Description=$test['Description'] ; if(isset($_POST['save'])) { $websitetitle_save = $_POST['websitetitle']; $link_save = $_POST['link']; $webmaster_save = $_POST['webmaster']; $description_save = $_POST['description']; mysql_query("UPDATE links SET WebsiteTitle ='$websitetitle_save', Link ='$link_save', WebMaster ='$webmaster_save',Description ='$description_save' WHERE LinkID = '$id'") or die(mysql_error()); echo "Saved!"; header("Location: index.php"); } mysql_close($conn); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> </head> <body> <form method="post"> <table> <tr> <td>WebsiteTitle:</td> <td><input type="text" name="websitetitle" value="<?php echo $WebsiteTitle ?>"/></td> </tr> <tr> <td>Link</td> <td><input type="text" name="link" value="<?php echo $Link ?>"/></td> </tr> <tr> <td>WebMaster</td> <td><input type="text" name="webmaster" value="<?php echo $WebMaster ?>"/></td> </tr> <tr> <td>DESCRIPTION</td> <td><input type="text" name="description" value="<?php echo $Description ?>"/></td> </tr> <tr> <td> </td> <td><input type="submit" name="save" value="save" /></td> </tr> </table> </body> </html> [/view] --------------------------------------------------------------------