Welcome to my new mobile site, built entirely by using XtGem. XtGem is a visual mobile site building tool, allowing users to create and maintain highly customizable personal mobile sites completely free of charge - and without a need to know any programming language at all!
hhhhFailed to connect to the database! >>Please check the parameters and database server<<
');
$db_name="myforum";
$result=mysql_select_db($db_name);
if(!$result){
forumsetup();
}
$tbl_name="forum_topics";
$sql="SELECT * FROM $tbl_name ORDER BY id DESC";
$result=mysql_query($sql,$link);
if (!isset($_GET['type'])) {
echo "
';
}else {
echo "Error Posting.";
}
}elseif (isset($_GET['type']) && $_GET['type'] == 'view') {
// get value of id that sent from address bar
$id=$_GET['id'];
$sql="SELECT * FROM $tbl_name WHERE id='$id'";
$result=mysql_query($sql);
$rows=mysql_fetch_array($result);
echo "
".$rows['topic']."
".$rows['detail']."
By : ".$rows['name']." Email : ".$rows['email']."
Date/time : ".$rows['datetime']."
";
$tbl_name2="forum_replies"; // Switch to replies table
$sql2="SELECT * FROM $tbl_name2 WHERE thread_id='$id'";
$result2=mysql_query($sql2);
while($rows=mysql_fetch_array($result2)){
echo "
ID
:
".$rows['a_id']."
Name
:
".$rows['a_name']."
Email
:
".$rows['a_email']."
Answer
:
".$rows['a_answer']."
Date/Time
:
".$rows['a_datetime']."
";
}
$sql3="SELECT view FROM $tbl_name WHERE id='$id'";
$result3=mysql_query($sql3);
$rows=mysql_fetch_array($result3);
$view=$rows['view'];
// if have no counter value set counter = 1
if(empty($view)){
$view=1;
$sql4="INSERT INTO $tbl_name(view) VALUES('$view') WHERE id='$id'";
$result4=mysql_query($sql4);
}
// count more value
$addview=$view+1;
$sql5="update $tbl_name set view='$addview' WHERE id='$id'";
$result5=mysql_query($sql5);
echo "
";
}elseif (isset($_GET['type']) && $_GET['type'] == "reply") {
// Get value of id that sent from hidden field
$id=$_POST['id'];
// Find highest answer number.
$sql="SELECT MAX(a_id) AS Maxa_id FROM forum_replies WHERE thread_id='$id'";
$result=mysql_query($sql);
$rows=mysql_fetch_array($result);
// add + 1 to highest answer number and keep it in variable name "$Max_id". if there no answer yet set it = 1
if ($rows) {
$Max_id = $rows['Maxa_id']+1;
}else {
$Max_id = 1;
}
// get values that sent from form
$a_name=$_POST['a_name'];
$a_email=$_POST['a_email'];
$a_answer=$_POST['a_answer'];
$datetime=date("d/m/y H:i:s"); // create date and time
// Insert answer
$sql2="INSERT INTO forum_replies(thread_id, a_id, a_name, a_email, a_answer, a_datetime)VALUES('$id', '$Max_id', '$a_name', '$a_email', '$a_answer', '$datetime')";
$result2=mysql_query($sql2);
if($result2){
echo '
';
// If added new answer, add value +1 in reply column
$tbl_name2="forum_topics";
$sql3="UPDATE $tbl_name2 SET reply='$Max_id' WHERE id='$id'";
$result3=mysql_query($sql3);
$tbl_name2="forum_question";
$sql3="UPDATE $tbl_name2 SET reply='$Max_id' WHERE id='$id'";
$result3=mysql_query($sql3);
}else {
echo "ERROR";
}
}
function forumsetup(){
echo('
-Automatic setup is started...
');
global $host,$username,$password,$link;
//$link=mysql_connect($host, $username, $password);
$sql= 'CREATE DATABASE myforum';
if (!mysql_query ($sql, $link)) die('
Failed to
create database! >>Please check the parameters and database server<<
');
$sql = "CREATE TABLE `myforum`.`forum_topics` (
`id` TEXT NOT NULL ,
`topic` TEXT NOT NULL ,
`detail` LONGTEXT NOT NULL ,
`name` TEXT NOT NULL ,
`email` TEXT NOT NULL ,
`datetime` TEXT NOT NULL ,
`view` TEXT NOT NULL ,
`reply` TEXT NOT NULL
) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;";
$sql2 = "CREATE TABLE `myforum`.`forum_replies` (
`thread_id` TEXT NOT NULL ,
`a_id` TEXT NOT NULL ,
`a_name` TEXT NOT NULL ,
`a_email` TEXT NOT NULL ,
`a_answer` LONGTEXT NOT NULL ,
`a_datetime` TEXT NOT NULL
) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;";
mysql_query($sql) or die('Setup Failed');
mysql_query($sql2)or die('Setup Failed');
echo('
-Automatic setup completed successfully. Your forum is ready!
