as u may know im making a site that has reviews, previews, screenshots and other stuff to do with games (including a forum)
problem is i dont know php ot mysql
so i need somebody to help me code it or give me places with code examples/tutorials
anyone?

or try W3schools.com.

well i learnt how 2 upload files (quite easy) but now i need to know how 2 limit the file type using php if this is possible

quote:

---

Originally posted by leejeffery
well i learnt how 2 upload files (quite easy) but now i need to know how 2 limit the file type using php if this is possible

---

code:

---

<?php

$filename = "uploaded.txt";

$extension = substr(strrchr($filename, "."), 1);

if($extension == "php" || $extension == "php3") {
    die("That file type is banned!");
}

?>

---

code:

---

if($extension != "jpg" && $extension != "gif") {
    die("Only .jpg and .gif files are allowed!");
}

---

thanx WDZ
just what i needed
but im also lookin for a way to not have 2 upload a file to the same database but to have input boxes like game name, reviewer name, review, rating etc. on a page and a button that says submit which adds all the info in the text boxes to a new row in the db
is this possibe?

Yes, this is possible, but you would need to write the input form in HTML.

What are your HTML skills like?

quote:

---

Originally posted by musicalmidget
What are your HTML skills like?

---

quote:

---

Originally posted by leejeffery
do i need to learn html or can i do it in dreamweaver?

---

here is the code i have but its not actually submitting anything to the database (ive excluded names of db and password for security reasons)
[/code]<?
//initilize PHP

if($_POST['submit']) //If submit is hit
{
   //then connect as user
   //change user and password to your mySQL name and password
   mysql_connect("localhost","******_*****","********");

   //select which database you want to edit
   mysql_select_db("******_reviews");

   //convert all the posts to variables:
   $Title = $_POST['Title'];
   $Platform = $_POST['Platform'];
   $Review = $_POST['Review'];
   $Reviewer = $_POST['Reviewer'];
   $Rating = $_POST['Rating'];
   $Date = $_POST['Date'];
   
   //Insert the values into the correct database with the right fields
   //mysql table = database
   //table columns = Title, Platform, Review, Reviewer, Rating, Date
   //post variables = $Title, $Platform, '$Review, $Reviewer, $Rating, $Date
   $result=MYSQL_QUERY("INSERT INTO database (Title,Platform,Review,Reviewer,Rating,Date)".
      "VALUES ('$Title', '$Platform', '$Review', '$Reviewer', '$Rating', '$date')");

    //confirm
   echo "Review uploaded succesfully!";
}

else
{
// close php so we can put in our code
?><title>GameSmart - Write your own game reviews!!</title>
<style type="text/css">
<!--
.style1 {color: #666666}
-->
</style>

<form action="uploadreview.php" method="post" class="style1">
<TABLE>
<TR>
   <TD align="center" valign="top">Title/TD>
   <TD><INPUT TYPE='TEXT' NAME='Title' VALUE='' size=60></TD>
</TR>
<TR>
   <TD align="center" valign="top">Platform/TD>
   <TD>
    <SELECT NAME='Platform'>
    <OPTION VALUE='PS2'>PS2
    <OPTION VALUE='Gamecube'>Gamecube
    <OPTION VALUE='XBOX'>XBOX
    <OPTION VALUE='PC'>PC
    <OPTION VALUE='GBA'>GBA
    </SELECT></TD>
</TR><br>
<TR>
   <TD align="center" valign="top">Review/TD>
   <TD><textarea name="Review" cols="60" rows="20"></textarea></TD>
</TR>
<TR>
  <TD align="center" valign="top">Rating/TD>
  <TD><input name='Rating' type='TEXT' size=3 maxlength="2">
    /10</TD>
</TR>
<TR>
  <TD align="center" valign="top">Reviewer/TD>
  <TD><INPUT NAME='Reviewer' TYPE='TEXT' size=60 maxlength="30"></TD>
</TR>
<TR>
   <TD align="center" valign="top">Date/TD>
   <TD><INPUT TYPE='text' NAME='Date' VALUE='<? echo date("M.j.y"); ?>' size=60></TD>
</TR>
<TR>
   <TD></TD><br>
   <TD><INPUT TYPE="submit" name="submit" value="submit"></TD>
</TR>
</TABLE>
</form>

<?
} //close the else statement
?>[/code]
can anybody see whats wrong with this code?

quote:

---

Originally posted by leejeffery

$Date
   $result=MYSQL_QUERY("INSERT INTO database (Title,Platform,Review,Reviewer,Rating,Date)".
      "VALUES ('$Title', '$Platform', '$Review', '$Reviewer', '$Rating', '$date')");

---

i changed that but it still dont upload anything
i dont get an error it says review uploaded successfuly like it should and then i go to phpmyadmin to check out the table "database" and theres nothing there :/

EDIT: could it be something to do with the database because i dont know what i was supposed to do with some of the settings so how do i change it so i can put text in?

SORT OF OFF TOPIC: is it possible using html to load a html page into a table?

You need to have a database table set up, with the columns that you want.

look at this for more info, and maybe

no thats not the problem
i have the database set up and have a table with all the needed things like Title, Review etc.
the problem is all the settings like attributes, null and all that sort of stuff
i dont know what they all mean