I am a student and trying to make my own database in MySQL and use php to submit and retrieve data from MySQL. I want to do this all from a Web browser (OS: mac osx).
I am successful to submit data from a browser and also retrieve the submitted data from MySQL. Since I am a newbie, I have the following to problems to solve,
1. I can retrieve the data from MySQL and can view the results from the php file by opening it in a browser.
I don't know how to bring the php file output to a html page, so that I can view my MySQL data from a html page and I want to add more html codes to get better view of the results.
2. I want to add a search form in the html page, so that I can search the MySQL database and view the results back in html page.
3. I have a column named "tag" in my database and each row has several words on the tag column.
I want to have a link for each tag in my html page that can bring me the results of the corresponding tags.
Here's the script that I have done so far.
HTML form to submit data
<html><body>
<form enctype="multipart/form-data" action="randam_new.php" method="POST">
Title: <input type="text" name="title"><br>
Year: <input type="text" name = "year"><br>
Tags: <input type="text" name = "tag"><br>
DOI: <input type="text" name = "doi"><br>
<table>
<tr>
<td width="246">
Image: <input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="userfile" type="file" id="userfile">
</td>
<td width="80"><input name="upload" type="submit" class="box" id="upload" value=" Upload "></td>
</tr>
</table></form></body></html>
php script to write the submitted data into MySQL database
<?php
$uploadDir = 'images/';
$title=$_POST['title'];
$year=$_POST['year'];
$tag=$_POST['tag'];
$doi=$_POST['doi'];
if(isset($_POST['upload']))
{
$fileName = $_FILES['userfile']['name'];
$tmpName = $_FILES['userfile']['tmp_name'];
// get the file extension first
$ext = substr(strrchr($fileName, "."), 1);
// make the random file name
$randName = md5(rand() * time());
//$filePath = $uploadDir . $fileName;
$filePath = $randName . '.' . $ext;
$result = move_uploaded_file($tmpName, $uploadDir.$filePath);
if (!$result) {
echo "Error uploading file";
exit;
}
include '../library/config.php';
include '../library/opendb.php';
if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
$filePath = addslashes($filePath);
}
// Connects to your Database
mysql_connect("127.0.0.1", "Ramesh", "") or die(mysql_error()) ;
mysql_select_db("test") or die(mysql_error()) ;
$query = "INSERT INTO new2 (title, year, tag, doi, image ) ".
"VALUES ('$title', '$year', '$tag', '$doi', '$filePath')";
mysql_query($query) or die('Error, query failed : ' . mysql_error());
include '../library/closedb.php';
echo "<br>Files uploaded<br>";
}
?>
php script to retrieve the data from MySQL
<?php
// Connects to your Database
mysql_connect("127.0.0.1", "Ramesh", "") or die(mysql_error()) ;
mysql_select_db("test") or die(mysql_error()) ;
//Retrieves data from MySQL
$data = mysql_query("SELECT * FROM new2") or die(mysql_error());
//Puts it into an array
while($info = mysql_fetch_array( $data ))
{
//Outputs the image and other data
Echo "<b>Title:</b> ".$info['title'] . "<br> ";
Echo "<b>Year:</b> ".$info['year'] . " <br>";
Echo "<b>Tag:</b> ".$info['tag'] . " <br>";
Echo "<b>DOI:</b> ".$info['doi'] . " <br>";
Echo "<img src=images/".$info['image'] ."> <hr>";
}
?>
Please assist me to get better coding.
