Printable View
in SELECT * FROM content
content is an column of an table -or- an table of the database ? Help !
And if i want view the content of the column "bloc1" of the table "pages_main" of database "habbsitecms" ? I don't say what modify for make this...
What is the code of "config.php" please ?
Thanks !
Is my code good (see above).
THANKS !!!!!!!!Quote:
Originally Posted by syed1994
I test !
and how to insert some text on a row via PHPMy Admin ? I'm lose...
Ooops I forget you need the config file!
PHP Code:<?php
/*
MySQL Connextion
*/
$host = "localhost"
$user = "USERNAME FOR DB HERE"
$pass = "password"
$db = "database name"
?>
Okay, i test, but result :Quote:
Originally Posted by syed1994
And after erasingQuote:
Parse error: syntax error, unexpected T_LOGICAL_OR in C:\xampp\xampplite\htdocs\habbsitecms\20beta\view.php on line 4
I have this :Quote:
or
die('Error Message: ' . mysql_error());
tested with XAMPP (Apache and MySQL server)Quote:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\xampplite\htdocs\habbsitecms\20beta\view.php on line 9
Ok, you make a table named contentPHP Code:<?php
include("config.php");
$connect = mysql_connect($host,$user,$pass);
if (!$connect)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db($db, $connect);
$data = mysql_query("SELECT * FROM content"); //select * from (table)
while($row = mysql_fetch_array($data))
{
echo $row['News'] .; //row of table
echo "<br />";
}
mysql_close($connect);
?>
then you make it with 2 fields named News and Test
Then put some data in!
Okay but in what field i need to enter the data i want ?Quote:
Originally Posted by syed1994
FieldTypeLength/Values1CollationAttributesNullDefault2ExtraCommentsMIME typeBrowser transformationTransformation options3
It's fields of phpMyAdmin
http://img153.imageshack.us/img153/1107/mysqlnn4.png
And for insert, for exemple, this data : "<p>helloworld</p>" on a row (here "bloc1") what is the type i need to have ? TEXT ? LONGTEXT ? BINARY ? I try to insert data in the "Lenght/Values" field but don't save...
Help meeeee Thanks a lot !
Ermmm.... you don't know how to use it.
Aw man!
Yes i don't know how to use it.Quote:
Originally Posted by syed1994
Anybody knows how to ?
Dude u know more rofl >.>Quote:
Originally Posted by jetgod
Config.php for mysql
functions.php is for ?redirect= or ?go=
i dont have added the code because its a previeuw its dont a steal if you to lazy to make one just say
-------------------------------------------------------------------------------------------------------
http://www.habbocs.nl/userbar.png
Yes, you do know that 'require' requires mroe than just thta! Thsi sin't c++, you know. Config and fucntions .php must exist ahnd have the variables defiend, etc.Quote:
Originally Posted by Xellios
Dude, Listen if you are to noob to understand this >.>Quote:
Originally Posted by jetgod
Stupid noob sinds when we put mysql rows IN a .php file ;l ? ..
Lol if you want beat me add me on msn you can see in one of the posts
AND WHO SAYD THIS IS C++ :) ? .. C++ IS A REALLY ANOTHER CODELANGUAGE THAN PHP >.> nooblet your to stupid to stop YOUR PWNED >.>
I did nto once say this was c++.Quote:
Originally Posted by Xellios
I was saying that you are confusing php with c++. Php's 'requrie' functin is completely different, you're basically thinking that it's a similiar to c++ header file, which is wrong.
And 'sinds when we put mysql rows IN a .php file '
that makes no sense. explain?
There wasn't even a war.......Quote:
you're pwned!
Looks really good.
Like it, nice! :D