Clan Themes, We Make Clans Look Good!

www.clan-themes.co.uk :: View topic - PHP Question

Welcome To Clan Themes
	As the board grows please remember the Search Option and we hope you find our community useful. We also monitor Private Messages to stop members from abusing our sites system. If you are asking for assistance please provide your site link and nuke version, Thanks.

PHP Question

6 Replies / 351 Views


www.clan-themes.co.uk Forum Index » General Topics	View previous topic :: View next topic

Falgern
Reputation: 0.2
Local time: 4:23 PM

Status: Offline
0.03 posts per day
Medals: 0

Joined: May 09, 2008
Last Visit: 19 May 2008
Posts: 2
Points: 45

PHP Question Posted: Fri May 09, 2008 7:19 pm

Hello Clan-Themes.co.uk
I've got a bit of PHP problem.
I'm trying to make a page that updates a row in a database. and another page reads from that row and gets its text from it.. some kind of easy posting/updating system.
But i've run into some really big problem.

Code:

<?php
$submit = $_POST['submit'];
$text = $_POST['text'];

$db = mysql_connect(localhost, ******, *****);
mysql_select_db(******);

if ($submit) {
$result = mysql_query("UPDATE pages SET lol = $_POST[text] WHERE id = '1'" );

} else{
?>
<form action="indexupdate.php" method="post">
Text <input type="text" name="text" size="30" style="width: 300px; height: 100px;">

<p><INPUT TYPE="Submit" name="submit" value="Change">

<?php
$submit = $_POST['submit'];
$lname = $_POST['text'];
} // end if
?>

Thats the code i've done so far. but it doesnt work, i cant however see anything wrong in it.

also, is there an easy way to make a page to read from database?

Thank you.

stipher
Reputation: 0.2
Local time: 4:23 PM

Status: Offline
0.03 posts per day
Medals: 0

Joined: May 09, 2008
Last Visit: 09 May 2008
Posts: 2
Points: 42

PHP Question Posted: Fri May 09, 2008 9:36 pm

EHHHH ? HMMMMMMM ? Explain more pls ?

Bayler
Reputation: 743.2
votes: 9
Local time: 4:23 PM

Status: Offline
1.16 posts per day
Medals: 1 (View more...)

Joined: Nov 01, 2007
Last Visit: 05 Jul 2008
Posts: 288
Points: 5527

PHP Question Posted: Sat May 10, 2008 2:13 am

from what i can understand of your question....

im gonna have to break your code into parts to better explain...

Lets start with submitting data to the 'next page' part....
Resource link: http://www.w3schools.com/PHP/php_get.asp

I do NOT recommend the $_GET variable as your data is submitted directly into the URL which can give away information that ultimatly opens the door for injection exploits. Use the ( $_REQUEST ) variable instead.

As for your ( else and If ) statements, i would suggest separating them by 'CASE - Breaks'
Inside of those Case/Breaks insert your function directly into the appropriate function needed.

With SQL. your on the right Track ( INSERT ) is whats needed to add data to your SQL database...
But with the limited information provided in your question..its going to be difficult to point you in the right direction

If you would like further help, your going to need to provide detailed information in your question.

You will not recieve help from me if i have to go digging for your CMS information and version, If i have to take the time to play 21 questions, then you can take the time to google! No Copyright, no support either!

Falgern
Reputation: 0.2
Local time: 4:23 PM

Status: Offline
0.03 posts per day
Medals: 0

Joined: May 09, 2008
Last Visit: 19 May 2008
Posts: 2
Points: 45

PHP Question Posted: Sat May 10, 2008 5:34 am

Thanks for the reply. I'll try to explain it a bit better

I'm trying to do a page, wich got an text are, the stuff you enter there should get posted into a row in database,
another page reads from that row and post it on the page. so it would become some kind of simple posting system/admin system for my pages. Retard

or is there any easier way to update/change the content of my pages online and not having to change the code itself

Bayler
Reputation: 743.2
votes: 9
Local time: 4:23 PM

Status: Offline
1.16 posts per day
Medals: 1 (View more...)

Joined: Nov 01, 2007
Last Visit: 05 Jul 2008
Posts: 288
Points: 5527

PHP Question Posted: Sat May 10, 2008 11:36 am

ok...

That is no more information then the original question...so i guess your going to make me ask a billion & one questions....

1) What type of CMS are you using...

2) How many Pages are we talking ? 1, 2, as many as you want to create?

3) How much Text is the database storing ? 255 characters, 500, 1000 ???

There are probably going to be more questions...

Duck
Reputation: 470.6
Local time: 7:23 AM

Status: Offline
0.09 posts per day
Medals: 0

Joined: Jan 07, 2007
Last Visit: 04 Jul 2008
Posts: 47
Points: 4869

PHP Question Posted: Sat May 10, 2008 6:44 pm

Ok there looks to be a bunch of points to make here. Since you don't wish to include the nuke DB connection class and choose to do the connection manually I would say I would change your routine to this:

Code:

<?php
$submit = $_POST['submit'];
$text = $_POST['text'];

$db = mysql_connect(localhost, ******, *****);
mysql_select_db("Your_DBNAME",$db);

if ($submit) {
$result = mysql_query("UPDATE pages SET lol = $text WHERE id = '1'", $db );

} else{
?>
<form action="indexupdate.php" method="post">
Text <input type="text" name="text" size="30" style="width: 300px; height: 100px;">

<p><INPUT TYPE="Submit" name="submit" value="Change">

<?php
$submit = $_POST['submit'];
$lname = $_POST['text'];
} // end if
?>

Of course I would not recommend your Variable names cause some of them are reserved already if you are using Nuke like $db and $lname

floppy
Reputation: 2234.9
votes: 10
Local time: 4:23 PM
Location: Jackson Mississippi

Status: Offline
3.22 posts per day
Medals: 1 (View more...)

Clan Themes Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 05 Jul 2008
Posts: 1932
Points: 23203

PHP Question Posted: Sat May 10, 2008 7:08 pm
Shop Purchases:Clan Roster 2.0

I don't have much to add, seems these guys got it covered. However I don't see where you closed your form.

Code:

</form>

Free Clan Links - Submit Yours today

www.clan-themes.co.uk Forum Index » General Topics

6 Replies / 351 Views
Page 1 of 1
All times are GMT

Display posts from previous:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

You can syndicate our news using the file backend.php or ultramode.txt

Distributed by Raven PHP Scripts

Page Generation: 1.29 Seconds