question about updating a page or database for an admin sect
Moderator: General Moderators
-
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
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
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
-
mikewooten
- Forum Contributor
- Posts: 169
- Joined: Wed Feb 11, 2004 12:13 pm
- Location: Duluth, Georgia
- Contact:
question???
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
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
- Saethyr
- Forum Contributor
- Posts: 182
- Joined: Thu Sep 25, 2003 9:21 am
- Location: Wichita, Kansas USA
- Contact:
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
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
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
what is a blackhole that you were talking about?
thanks
thanks
-
mikewooten
- Forum Contributor
- Posts: 169
- Joined: Wed Feb 11, 2004 12:13 pm
- Location: Duluth, Georgia
- Contact:
question???
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
thanks
Let me give you a example
NOTE: PHP.INI -> GLOBAL = On
now the retrievel of information and putting it in the database
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..
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>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>");
?>Enjoy
http://www.php.net is a nice place to start on learning some of php
and a book always welcome..
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK