Jump to content

Archived

This topic is now archived and is closed to further replies.

master123467

i cant get this writing to a table in a db thing

Recommended Posts

heres my cms.php im making click [a href=\"http://www.freepgs.com/fireballos/\" target=\"_blank\"].php file[/a]

in the same link there should be my .html file i tried to

 

right click and save as on the cms.php

 

plz help me plz

Share this post


Link to post
Share on other sites

Paste your cms.php file here, I'll edit this and help you when you do.

Share this post


Link to post
Share on other sites

ok heres the new code

<?php
echo "<html>\n";
echo "<center>\n";
echo "<form name='CMS' method='post'  action='cms.php'>\n";
echo "<textarea cols='50' rows='4' name='CMS'></textarea>\n";
echo "<br>\n";
echo "<input type='submit' value='Submit' action=''>\n";
echo "<input type='reset'>\n";
echo "</center>\n";
echo "</form>\n";
echo "</html>";

$dbhost = 'localhost:';
$dbuser = 'root';
$dbpass = 'master';
$table ='announcements';
$column ='text';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('connection not made');

$dbname = 'rockledge';
mysql_select_db($dbname);
$query = "INSERT INTO $table ($column) VALUES ( 1,$CMS)";
mysql_query($query);
mysql_close($conn)
?>

hope u can help me fix it well i no it connects but it wont write to the announcements table and the text (LONGTEXT) column and $CMS well $CMS i want to be the text tht is in the textbox but i cant figure out how to do tht so i dont no if its working or not

Share this post


Link to post
Share on other sites

Be careful when you post scripts on here because often they will contain your password, like yours did. Now the line:

$query = "INSERT INTO $table ($column) VALUES ( 1,$CMS)";

will produce an error. You have to get rid of ($column). Next, you're inputting values (1, $CMS). I don't see anywhere in your code where $CMS is given a value. You're going to have to add this line before your query line somewhere in your code:

$CMS = $_POST['CMS'];

Now your 1 in there seems weird. I'm guessing that's a mistake too but since I can't see what your table structure is I can't be sure. Usually the first column in a table like this is your auto-increment variable, so replace 1 with '' (two single-quotes).

 

You also have a ton of unneccessary variables in there but that won't stop the script from working. Post here when you have tried this.

Share this post


Link to post
Share on other sites

nope didnt work heres my code so far and master isnt my password all tht username and pass arent the really thing

<?php
echo "<html>\n";
echo "<center>\n";
echo "<form name='insert' method='post'  action=''>\n";
echo "<textarea cols='70' rows='12' name='CMS'></textarea>\n";
echo "<br>\n";
echo "<input type='submit' value='Submit'>\n";
echo "<input type='reset'>\n";
echo "</center>\n";
echo "</form>\n";
echo "</html>";

$CMS = $_POST['CMS'];
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'master';
$table ='announcements';


$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('connection not made');

$dbname = 'rockledge';
mysql_select_db($dbname);
$query = "INSERT INTO $table VALUES ( '',$CMS)";
mysql_query($query);
mysql_close($conn)
?>

 

 

maybe if u would test out the code like make a database named rockledge with the pass of master and then a table named announcements with a column in that table named text and that column should be LONGTEXT

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.