master123467
-
Posts
6 -
Joined
-
Last visited
Never
master123467's Achievements
Newbie (1/5)
0
Reputation
-
i cant get this writing to a table in a db thing
master123467 replied to master123467's topic in MySQL Help
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 -
i cant get this writing to a table in a db thing
master123467 replied to master123467's topic in MySQL Help
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 -
i cant get this writing to a table in a db thing
master123467 replied to master123467's topic in MySQL Help
plz i really need help -
i cant get this writing to a table in a db thing
master123467 replied to master123467's topic in MySQL Help
ok i posted my cms.php code so do u think theres a way to fix it -
i cant get this writing to a table in a db thing
master123467 replied to master123467's topic in MySQL Help
changed the code check 3 posts down for the new code -
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