<HTML>
<HEAD><TITLE>Ads</TITLE>
</HEAD>
<BODY>
<?php
// code that will be executed if the form has been submitted:
if ($submit)
{
//please change the server name username and password according to your mysql server setting
$mysql_server="loaclhost";
$mysql_username="root";
$mysql_password="dbpass20";
$mysql_database="rnr";
//connect to database using above settings
@MYSQL_CONNECT("localhost",$mysql_username,$mysql_password);
@mysql_select_db("rnr");
/* Add backslashes before characters that need to be quoted in database queries etc.
These characters are single quote ('), double quote ("), backslash () and NUL (the NULL byte). */
$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));
//set the picture id a unix timestamp. I thought this will not have repeatations. You can keep anything what you like
$ads_id=time();
/* Now insert the values into the table
oh sorry i forgot the mention the details of the table and here it goes. I have given the query to make ur work easier
CREATE TABLE ads
(
id varchar(15),
description varchar(255),
bin_data LONGBLOB,
filename varchar(50),
filesize varchar(50),
filetype varchar(50),
link varchar(255),
shownno integer(5),
clickcount integer(5),
unique(id)
);
*/
$result=MYSQL_QUERY("INSERT INTO ads (id,description,bin_data,filename,filesize,filetype,link,shownno,clickcount) ".
" VALUES ($ads_id,'$form_description','$data','$form_data_name','$form_data_size','$form_data_type','$form_link',$form_count ,$form_ccount)");
//print the id once the data is updated and this can be omited. Just incase....
print "<p>This file has the following Database ID: <b>$ads_id</b>";
//close the mysql database connection...
MYSQL_CLOSE();
}
else
{
// else show the form to submit new data:
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>Enter The Add Details</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<!-- Take a note this will work only if enctype in form is given as bellow since
this is how it is done when submitting files in forms.
-->
<form method="post" action="<?php echo $PHP_SELF; ?>" enctype="multipart/form-data" name="s">
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td>File Description:</td>
<td>
<input type="text" name="form_description" size="40">
<!-- this is to check is not over sized -->
<input type="hidden" name="MAX_FILE_SIZE" value="1000000">
</td>
</tr>
<tr>
<td>File to upload/store in database:</td>
<td>
<input type="file" name="form_data" size="40">
</td>
</tr>
<tr>
<td>Link Of the ad</td>
<td>
<input type="text" name="form_link" size="40">
</td>
</tr>
<tr>
<td>Shown Count</td>
<td>
<input type="text" name="form_count" size="40" value="0">
</td>
</tr>
<tr>
<td">Clicked Count</td>
<td>
<input type="text" name="form_ccount" size="40" value="0">
</td>
</tr>
<tr>
<td> </td>
<td>
<input type="submit" name="submit" value="submit">
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<?php
}
?>
</BODY>
</HTML>
|
|
Store
Your email: