newbie to php

dwaynetaz

Hello every one i am so new and fresh to the world of php, i want to create some admin pages so that i can add stuff to my database via admin pages but i do not know where to start i have no idea what would be a good starting point help

bpat1434

Best starting point is to learn how to manipulate MySQL with PHP. From there it would be forms and sessions. After learning the basics in those areas, you should have the basic stuff to be able to create a password protected administration section which saves data to the database.

dwaynetaz

Thank you for your reply

Ok well i have been reading a little bit and keep on getting a unexpected T_VARIABLE error which is very annoying ill show you my code

<?php
session_start();
include "php/linksettings.inc.php";

echo $_POST["name"]; 
echo $_POST["price"]; 
echo $_POST["description"]; 

$query = ("INSERT INTO Item_products (name,price,description) VAULES ( '$name','$price','$description',")
$result = mysql_query($query) or die ("Could not select item details:" . mysql_error());

?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Home</title>
<link href="index.css" rel="stylesheet" type="text/css" />
</head>

<body>



<form action="products_admin.php" method="post">
add_name:

<input name="name" type="text"  />

product_price
<input name="price" type="text"/>

Product_description 
<input name="description" type="text"/>

submit

<input type="submit" value="submit"/>
</form>


<table>
	<tr>
		<th>ID</th><a href="products_admin.php">add</a>
		<th>NAME</th>
		<th>PRICE</th>
		<th>DESCRIPTION</th>
	</tr>

</table>


</body>
</html>

bpat1434

Well, for one thing, I see that in the query you insert 4 items, yet you only define 3 columns.
The other thing is that you don't terminate the $query = line. You're missing an ending semi-colon after your query.

dwaynetaz

Ok well because i do want to insert items into my data base what else would i need in addition with

$query = ("INSERT INTO Item_products (name,price,description) VAULES ( '$name','$price','$description',");

i do not see where i am 4 items things but only have 3 columns

bpat1434

Okay, so in the query it goes something like this:

"INSERT INTO tablename (column, column, column, ...) VALUES ('value', value, value, ...)"

So for every "column" you have to have a valid "value". In your query, you have 4 quoted strings:
'$name', '$price', '$description', ''

Yet you have 3 columns:
name, price, description

So the last empty set of quotes needs to be removed or you need to add a column designation.

After that, as long as you run the query using mysql_query(), you can check [man]mysql_affected_rows/man you can see if the affected number of rows is greater than 0.

dwaynetaz

Ok well i have added my id to my string and now i have added a mysql error or die command and now i get this

Could not run query:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VAULES ( '','','',' at line 1

when i go to preview it i have no idea why this is what my string looks like

$query = ("INSERT INTO Item_products ( id,name,price,description) VAULES ( '$name','$price','$description',");
$result = mysql_query($query) or die ("Could not run query:" . mysql_error());

I just want to make me be able to add and delete my products on a admin page

bpat1434

The keyword is "VALUES" not "VAULES"