PHP help - please help!

[calthephenom]

i am trying to track scores for rock band, like www.scorehero.com
i want it to be viewable like this




just using a mysql DB/php 5
please help, i have spent 60+ hours on this

[carsey]

Explain what you want to do with the data.

Do you want to echo all the data from the database into the table?

[calthephenom]

Originally Posted by carsey

Explain what you want to do with the data.

Do you want to echo all the data from the database into the table?

yes, you can submit it in a form, to a database, and it will echo what you posted into a table

[Redcore]

This is real basic stuff...how many tutorials did you look at/try in those 60 hours?

My favorite PHP/MySQL tutorial:
http://www.freewebmasterhelp.com/tutorials/phpmysql

[calthephenom]

Originally Posted by Redcore

This is real basic stuff...how many tutorials did you look at/try in those 60 hours?

My favorite PHP/MySQL tutorial:
http://www.freewebmasterhelp.com/tutorials/phpmysql

will u please write me the script i would need
i am begging you, i am a complete noob at php
PLEEEEZE!!!!!!!!!!!!!

[carsey]

What have you got at the minute?

its a very simple case of connecting to the database, querying the data you want to show and sticking it in a echoed row on the table.

[Redcore]

This is a support forum, not a free labor forum :P I get paid to do that stuff, why would I do it for free? Anyways you'll never learn anything from it and you can't always get people to do free work on your site. You need to be able to fix and update it on your own, unless you plan on paying someone to help or know someone that is willing to do it for free quite frequently (I guarantee that kind of offer runs thin when they're doing your site for you all the time).

Take a look at the article and take an honest try at making the script and then we'll take a look at it for you and help you along.

[calthephenom]

Originally Posted by carsey

What have you got at the minute?

its a very simple case of connecting to the database, querying the data you want to show and sticking it in a echoed row on the table.

i have the form
<form action="scores.php" method="post">
Song: <input type="text" name="first"><br>
Score: <input type="text" name="last"><br>
Player Name: <input type="text" name="phone"><br>
Percent: <input type="text" name="mobile"><br>
<input type="Submit">
</form>

[Redcore]

Okay, and how does scores.php look?

[calthephenom]

Originally Posted by Redcore

Okay, and how does scores.php look?

<?
$Song=$_POST['Song'];
$Score=$_POST['Score'];
$Player Name=$_POST['Player Name'];
$Percent=$_POST['Percent'];


mysql_connect(XXXXXXXX,$XXXXXXXXx,$XXXXXXXXX);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO contacts VALUES ('','$Song','$Score','$Player Name','$'Percent')";
mysql_query($query);

mysql_close();
?>

[calthephenom]

Originally Posted by Redcore

Okay, and how does scores.php look?

it says there is an error

Parse error: syntax error, unexpected T_STRING in /www/uuuq.com/c/a/l/calthephenom/htdocs/scores/scores.php on line 4

[carsey]

You going to need to add a 'id' tag to your form.

<form action="scores.php" method="post">
Song: <input type="text" name="first" [b]id="name"[/b]><br>
Score: <input type="text" name="last" [b]id="last"[/b]><br>
Player Name: <input type="text" name="phone" [b]id="phone"[/b]><br>
Percent: <input type="text" name="mobile" [b]id="mobile"[/b]><br>
<input type="Submit">
</form>

In scores.php you are going to need to grab the posted data with PHP.

This is done by:

PHP Code:

<?

$name = $_POST['name'];
$last = $_POST['last'];
$phone = $_POST['phone'];
$mobile = $_POST['mobile'];

?>

That will get the values from the form and make them usable in PHP.


You also need to connect to the database:

PHP Code:

$mysql_server = "";
$mysql_user = "";
$mysql_password = "";
$mysql_database = "";
$timeoutseconds = 300000; 


$connection = mysql_connect("$mysql_server","$mysql_user","$mysql_password") or die ("<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0; URL=../\">");

$db = mysql_select_db("$mysql_database") or die ("<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0; URL=../\">"); 


You will need to add your database credentials in there.

Then insert data into the DB

PHP Code:

mysql_query("INSERT INTO [b]1[/b] 
(name, last, phone, mobile) VALUES('$name', '$last', '$phone', '$mobile' ) ") 
or die(mysql_error());  

echo "Data Inserted!";

?> 


You then need to make a query to select the data.

PHP Code:

$fetch=mysql_fetch_object(mysql_query("SELECT * FROM `1`")); 


Replace 1 with your table name.

Then to echo the data you need to use the $fetch and the name of the row you want to display.

PHP Code:

<? echo "$fetch->name"; ?>
<? echo "$fetch->author"; ?>
<? echo "$fetch->article"; ?>

They are just a example and the above is a VERY BASIC script for adding data to forms and is probably liable to SQL injections and exploit. You should ideally strip all HTML and other invalid characters from forms before they are inserted into the database.

[carsey]

You going to need to add a 'id' tag to your form.

<form action="scores.php" method="post">
Song: <input type="text" name="first" id="name"><br>
Score: <input type="text" name="last" id="last"><br>
Player Name: <input type="text" name="phone" id="phone"><br>
Percent: <input type="text" name="mobile" id="mobile"><br>
<input type="Submit">
</form>

In scores.php you are going to need to grab the posted data with PHP.

This is done by:

PHP Code:

<?

$name = $_POST['name'];
$last = $_POST['last'];
$phone = $_POST['phone'];
$mobile = $_POST['mobile'];

?>

That will get the values from the form and make them usable in PHP.


You also need to connect to the database:

PHP Code:

$mysql_server = "";
$mysql_user = "";
$mysql_password = "";
$mysql_database = "";
$timeoutseconds = 300000; 


$connection = mysql_connect("$mysql_server","$mysql_user","$mysql_password") or die ("<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0; URL=../\">");

$db = mysql_select_db("$mysql_database") or die ("<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0; URL=../\">"); 


You will need to add your database credentials in there.

Then insert data into the DB

PHP Code:

mysql_query("INSERT INTO 1 
(name, last, phone, mobile) VALUES('$name', '$last', '$phone', '$mobile' ) ") 
or die(mysql_error());  

echo "Data Inserted!";

?> 


You then need to make a query to select the data.

PHP Code:

$fetch=mysql_fetch_object(mysql_query("SELECT * FROM `1`")); 


Replace 1 with your table name.

Then to echo the data you need to use the $fetch and the name of the row you want to display.

PHP Code:

<? echo "$fetch->name"; ?>
<? echo "$fetch->author"; ?>
<? echo "$fetch->article"; ?>

They are just a example and the above is a VERY BASIC script for adding data to forms and is probably liable to SQL injections and exploit. You should ideally strip all HTML and other invalid characters from forms before they are inserted into the database.

[calthephenom]

Originally Posted by carsey

You going to need to add a 'id' tag to your form.

<form action="scores.php" method="post">
Song: <input type="text" name="first" id="name"><br>
Score: <input type="text" name="last" id="last"><br>
Player Name: <input type="text" name="phone" id="phone"><br>
Percent: <input type="text" name="mobile" id="mobile"><br>
<input type="Submit">
</form>

In scores.php you are going to need to grab the posted data with PHP.

This is done by:

PHP Code:

<?

$name = $_POST['name'];
$last = $_POST['last'];
$phone = $_POST['phone'];
$mobile = $_POST['mobile'];

?>

That will get the values from the form and make them usable in PHP.


You also need to connect to the database:

PHP Code:

$mysql_server = "";
$mysql_user = "";
$mysql_password = "";
$mysql_database = "";
$timeoutseconds = 300000; 


$connection = mysql_connect("$mysql_server","$mysql_user","$mysql_password") or die ("<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0; URL=../\">");

$db = mysql_select_db("$mysql_database") or die ("<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0; URL=../\">"); 


You will need to add your database credentials in there.

Then insert data into the DB

PHP Code:

mysql_query("INSERT INTO 1 
(name, last, phone, mobile) VALUES('$name', '$last', '$phone', '$mobile' ) ") 
or die(mysql_error());  

echo "Data Inserted!";

?> 


You then need to make a query to select the data.

PHP Code:

$fetch=mysql_fetch_object(mysql_query("SELECT * FROM `1`")); 


Replace 1 with your table name.

Then to echo the data you need to use the $fetch and the name of the row you want to display.

PHP Code:

<? echo "$fetch->name"; ?>
<? echo "$fetch->author"; ?>
<? echo "$fetch->article"; ?>

They are just a example and the above is a VERY BASIC script for adding data to forms and is probably liable to SQL injections and exploit. You should ideally strip all HTML and other invalid characters from forms before they are inserted into the database.

i could handle it all the way up until the MYSQL End
could you help me write the actual php script
html is easy, i just need help w/ mysql/php end
so do i goto my mysql datbase
create a table named " scores" - insert song, score, player name, and percent as a table's contents -and what do i enter for a value

[carsey]

You will need to set the database up and make all the columns or fields you are going to need.

Its always best to make a id field which is set to auto increment when a new record is added.

There are many good guides out there which will help you.

Ive given you a very good idea of how the script will need to be produced so you should be albe to google or use the link Redcore gave you.

[calthephenom]

Originally Posted by carsey

You will need to set the database up and make all the columns or fields you are going to need.

Its always best to make a id field which is set to auto increment when a new record is added.

There are many good guides out there which will help you.

Ive given you a very good idea of how the script will need to be produced so you should be albe to google or use the link Redcore gave you.

please help, i am only 12

[Redcore]

Then you're old enough to search for topics with Google

How to make an auto incrementing ID column:
http://trebleclick.blogspot.com/2009...hpmyadmin.html


In basic database design, you want every row to be unique in some way so you can manipulate each row without affecting other rows. This is typically done through a row ID column that is unique.