I am looking to a simple news posti 1

[hisham]

I am looking to a simple news posting script written in PHP with MySQL on backend, any body can direct me to a good one?
Thanks in advance.

 

[KarveR]

Theres a nice tutorial to make one at

http://www.devshed.com/Server_Side/PHP/PHPMySQLPublishing/page1.html

and theres a link to download the code and required setup scripts at the end of the tutorial. ***************************************
Party on, dudes!

 

[hisham]

Thank you KarveR,
I downloaded the code and I found a help file named INSTALL.txt, in the Installation section I read:

3. Create the database tables using the dump file:

$ mysql -u <username> -p <password> -D <database> < news.sql

Now, by logical (as my little experience in this field) if I use:

mysql -u myname –p –D news < news.sql

This will return: news.sql: No such file or directory

My question here: how to Create the database tables using the dump file?

 

[KarveR]

Have you got the dump file onto the server running mysql?
you have to ensure that the path to the file is correct.

login to mysql and from the mysql> prompt you can use the folowing command:

\. 'path/to/file/file.sql'

easy innit ;-) ***************************************
Party on, dudes!

 

[hisham]

Thank you very much KarveR,
The file news.sql was converted into table in the news database.
I tried to administer the application by using

http://myserver/myfolder/admin/add.php

to add news but after filling all the fields and click on add button it does not take me to other page, only refresh the page. I checked the database and I found that nothing was inserted, while the username root used in the config.php has the complete privileges to insert, delete etc… :
// conf.php - configuration parameters // database configuration
$host = &quot;192.168.0.2:3306&quot;;
$user = &quot;root&quot;;
$pass = &quot;mypassword&quot;;
$db = &quot;news&quot;;
I downloaded many news posting codes and always when I try the using form to add, delete, etc… I don’t get any error but don’t change to the next page??

 

[danielhozac]

Try using &quot;localhost&quot; as the host if the mySQL server is running on the same computer. //Daniel