Like this code?
Show the author your appreciation.
1. open config.php and edit it.
<?php
/*
include "config.php" ;
$auth = 0 ;
$PHP_AUTH_USER == $user ) && ( $PHP_AUTH_PW == $pass )) $auth = 1 ;
$auth != 1 ) {
header ( "WWW-Authenticate: Basic realm=Authorization Required!" );
header ( "HTTP/1.0 401 Unauthorized" );
'Authorization Required!' ;
$con = mysql_connect ( $db_host , $db_user , $db_pass );
$result = mysql_select_db ( $db_name , $con ) or die ( mysql_error ());
$sql = "SELECT * FROM $table" ;
$result = mysql_query ( $sql ) or die ( mysql_error ());
$action == "" && $show == "" && $mod == "" ){
"<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">
;
$data = mysql_fetch_assoc ( $result )){
" <td width=\"210\" style=\"border: 1px dotted #CCCCCC;\"><div align=\"center\"><font color=\"#FF0000\"><strong><font face=\"Geneva, Arial, Helvetica, sans-serif\">$data[title]</font></strong></font></div></td>
;
"
;}
$action == "add" ){
"<html>
;
$action == "addnew" ){
$title = $_POST [ dtitle ];
$url = $_POST [ durl ];
$insert = "INSERT INTO $table (title,URL)
;
mysql_query ( $insert ) or die ( mysql_error ());
$sql = mysql_query ( "
);
" <!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">
;
$action == "mod" )
$title = $_POST [ dtitle ];
$url = $_POST [ durl ];
$mod = $_POST [ mod ];
$query = "UPDATE $table SET title='$title' WHERE title='$mod'" ;
$result = mysql_query ( $query ) or die ( mysql_error ());
$query = "UPDATE $table SET URL='$url' WHERE title='$mod'" ;
$result = mysql_query ( $query ) or die ( mysql_error ());
$query = "ALTER TABLE `download_$mod` RENAME `download_$title`" ;
$result = mysql_query ( $query ) or die ( mysql_error ());
"success" ;
$show != "" )
"<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">
;
$sql = "SELECT * FROM download_$show" ;
$result = mysql_query ( $sql ) or die ( "mysql_error() four" );
$data = mysql_fetch_assoc ( $result )){
" <tr> <td width=\"103\" style=\"border: 1px dotted #CCCCCC;\"><div align=\"center\">$data[IP]</div></td>
;
" </tr>
;}
$mod != "" )
"<html>
;
?>
<?php
// MySQL settings:
$db_pass = "pass" ;
$db_user = "user" ;
$db_name = "name" ;
$db_host = "mj-smile.com" ;
// Main table name:
$table = "download_titles" ;
// Admin Panel settings
$pass = "pass" ;
$user = "user" ;
/*
$type = "SSI" ;
?>
<?php
include "config.php" ;
$con = mysql_connect ( $db_host , $db_user , $db_pass );
$result = mysql_select_db ( $db_name , $con ) or die ( mysql_error ());
$action == "" ){
$sql = "SELECT * FROM download_$title" ;
$result = mysql_query ( $sql );
$ref = $_SERVER [ "HTTP_REFERER" ];
$agent = $_SERVER [ "HTTP_USER_AGENT" ];
$IP = $_SERVER [ "HTTP_X_FORWARDED_FOR" ];
$Remote = $_SERVER [ "REMOTE_ADDR" ];
$query = "INSERT INTO download_$title (IP, RemoteAddr, agent, ref) VALUES ('$IP','$Remote','$agent','$ref')" ;
$result = mysql_query ( $query ) or die ( mysql_error ());
$sql = "SELECT URL FROM $table WHERE title='$title'" ;
$result = mysql_query ( $sql );
$data = mysql_fetch_assoc ( $result );
$url = $data [ 'URL' ];
header ( "Location:$url" );
$action == "show" )
$query = "SELECT * FROM download_$title" ;
$result = mysql_query ( $query );
$numrows = mysql_num_rows ( $result );
$type == "SSI" )
printf ( "%d" , $numrows );
"document.write($numrows)" ;
?>
CREATE TABLE download_titles (
bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL , PHP , MySQL , Complete Programs , Databases GroupIT Engine v1.00rc1
Categories : PHP , Content Management , MySQL , Databases Convert a File database into MySQL Categories : PHP , Filesystem , Databases , MySQL , Beginner Guides PhpLens PHP Application Server Categories : Content Management , Databases , PHP , MySQL PHP Transfer data from text file to Mysql Table Categories : PHP , PHP Classes , Filesystem , Databases , MySQL This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server. Categories : Databases , MySQL , Complete Programs , PHP , Databases Simple pipe delimited file export program that downloads to a local machine Categories : PHP , Filesystem , Databases , MySQL , HTTP I`d like to use the mysql_fetch_row function along with a "randomizer"
function that would give me a random result from a mySQL table. Categories : General SQL , MySQL , PHP , Databases Simple database class Categories : PHP , PHP Classes , MySQL , Databases This is a PHP/mySQL based Photo Album I wrote because I had too much
time on my hands and even more photographs online. Categories : PHP , MySQL , Databases , HTML and PHP Finds the median in an array of numbers - Can be used with a MySql database column read into an array Categories : PHP , Arrays , Databases , MySQL Glossword - glossary compiler Categories : Content Management , PHP , MySQL , XML AJAX Data Grid System using php and mysql. A complete login system with the ability to display data in a grid using ajax. Add , update and delete the records without reloading the page. Categories : PHP , AJAX , Databases , MySQL , Java Script Save and restore files into postgresql database (PHP SCRIPT) PHP CLASS Categories : PHP , Databases , PostgreSQL , Filesystem This program will take data from a user via a web based form, validate it, show it
to the user for re-validation, and finally insert it into the database. Plenty of
sanity checking on the fields in the form.
Categories : MySQL , HTML and PHP , PHP , Complete Programs , Databases
