question about updating a page or database for an admin sect

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
mikewooten
Forum Contributor
Posts: 169
Joined: Wed Feb 11, 2004 12:13 pm
Location: Duluth, Georgia
Contact:

question about updating a page or database for an admin sect

Post by mikewooten »

need help creating an admin for an e-commerce web site,
any suggestions on how i could go about creating this?

i know what the admin side is going to do and i know how its going to be designed i just
need help with the php and mysql coding to put together this administration section.

can anyone help me through this?

i would have to update all the information in the e-commerce website.
how would you create the pages to update the information?

many suggestions about how to go about doing this would be of great help

also


i'm working on an administration area for an e-commerce website

does anyone know how to update a page with text using a form?
i need some help on how i would go about doing that.
i'm looking for an update page where the administrator can update a page with text on it. the database has to be updated in order for the products pages to be updated, i know the update has to come from the sql, and i know i have to create a form for the administrator to input text, but how would it all be laid out together is the question that i am wondering?

i know exactly what i have to do with the admin section and what pages have to go into it, i am still new with php and mysql and need help with the coding part of the admin section. i need help with updating the information on the products pages.


many suggestions about how to put all of the forms, sql statements and php code would be of great help
thanks
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

with all due respect.......

........you seem like a beginner (hey, are'nt we all?)

i would not even attempt e-commerce sites (admin sections or not) until you fully understand the code you are writing, as the slightest 'blackhole' in the script could potentially cost the company millions
mikewooten
Forum Contributor
Posts: 169
Joined: Wed Feb 11, 2004 12:13 pm
Location: Duluth, Georgia
Contact:

question???

Post by mikewooten »

well, yes i am a beginner at php and mysql, i am a college student who is creating this e-commerce website and adminstration section as a project.
this is for school learning purposes only. it is NOT for a business.
i would like to know how to create the admin, thats why i'm asking for help. i would like to know how to update text and images on the product pages of the e-commerce website
any help would be appreciated
thanks
User avatar
Saethyr
Forum Contributor
Posts: 182
Joined: Thu Sep 25, 2003 9:21 am
Location: Wichita, Kansas USA
Contact:

Post by Saethyr »

Again with all due respect, Ecommerce and Admin backends are a bit much for a beginner, My suggestion, get a book with example code or download a nifty free one off http://www.hotscripts.com rip it apart and start looking at how they did things, but, make sure when you attempt your own even for practical purpose that you spend ALOT of time looking for blackholes, this will help you later when your not doing it for a school project.
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

ah thats kool then

have a look at these
mysql_query
for retrieving information for your database for viewing etc
mysql_fetch_arraycreates array of information for later retrieval
update record updates a record in a database
insert record inserts a record into a database
delete record deletes a record from teh database

they are the main functions any CMS/Administration panel needs.

Hope that helped
mikewooten
Forum Contributor
Posts: 169
Joined: Wed Feb 11, 2004 12:13 pm
Location: Duluth, Georgia
Contact:

general question

Post by mikewooten »

what is a blackhole that you were talking about?

thanks
mikewooten
Forum Contributor
Posts: 169
Joined: Wed Feb 11, 2004 12:13 pm
Location: Duluth, Georgia
Contact:

question???

Post by mikewooten »

once i connect to the database and add the sql into the page with the update statement, what php code would i have to use with the form elements.? i would have to use the form elements to put text into it to update the informaiton.

thanks
User avatar
ol4pr0
Forum Regular
Posts: 926
Joined: Thu Jan 08, 2004 11:22 am
Location: ecuador

Post by ol4pr0 »

Let me give you a example

NOTE: PHP.INI -> GLOBAL = On

Code: Select all

// html form 
<form target='I1' action='mail/joinnewsletter.php' method='post'>
						<br>
						<br>Company:<br><input size=15 name=company>
						<br>Contactperson:<br><input size=15 name='name'>
						<br>Email Address:<br><input size=15 name=email>
						<br><input type=submit value=Subscribe!>
						</form>
<form target='I1' action='mail/removemenow.php' method='post'>
						<br>
						<br>Email Address:<br><input type=text size=15 name=email2>
						<input type = "submit" value = "Remove" name="Remove">
						<br>
						
						</form>
now the retrievel of information and putting it in the database

Code: Select all

// for this you do need to create a database called email 
// and make the tables first !!!

<?php
$hostname = "localhost"; 
$database = "email";
$username = "test";
$password = "test";
$kornelius = mysql_pconnect($hostname, $username, $password) or die(mysql_error());

//insert the values of our form into our database
$sql_query = "INSERT INTO email VALUES ("$company","$name","$email")";
$results = mysql_query($sql_query);
//display a thank you message and a link
echo ("Thank you for subscribing <br>");
echo ("<a href = '../main.php'>Continue</a>");
?>
The update statement is to update some values.. not for adding them into a database ;-)


Enjoy


http://www.php.net is a nice place to start on learning some of php

and a book always welcome..
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

ol4pr0 - please have a read of the guidelines linked to from my sig and don't post example code which requires register_globals to be on - it is no longer the default and it is deprecated.

Mac
Post Reply