<div>
 &nbsp;Hi PredatorGR ; already most of the php scripts are free ,you may try to make a search from ; 
&nbsp; &nbsp;<a href="http://www.hotscripts.com" rel="ugc">www.hotscripts.com</a> 
&nbsp; &nbsp;To get what you need..
</div>

<div>
Thanks for your reply, i've been searching in hotscripts.com but it's a mess plus most of them are commercial...
</div>

<div>
Hi, PredatorGR. &nbsp;This sounds more like an application development request than a question. &nbsp;We're pretty good at answering questions or correcting coding issues, but you need direct, hands-on technical support. &nbsp;I would suggest that you hire a developer. &nbsp;You are not likely to find a free script collection that will do all these things in just the way you require. 
 
If you want to try to tackle this job yourself, you need to be aware that you will have to deal with A LOT OF MOVING PARTS in an application like this. &nbsp;A good place to start would be with the excellent SitePoint books, especially the ones about Building with PHP and Data Base. <a href="http://www.sitepoint.com/books/phpmysql1/" rel="ugc">http://www.sitepoint.com/books/phpmysql1/</a> 
 
Once you have your data base set up and your PHP scripts working, you can easily export the contents of the data base in RSS. &nbsp;An RSS feed looks like the code snippet. &nbsp;It is just a matter of selecting the DB fields and placing them into the correct places in the RSS XML file, in the correct formats. 
 
As you can see from the various fields in the RSS feed below, you have got to have a little bit more than just &quot;news1, news2, etc.&quot; &nbsp;Some of this can be generated programatically (pubDate is an example) and some of it must come from client input - titles, links, descriptions, etc. 
 
For an experienced developer with unfettered access to &nbsp;your staff and machines, I would guess the task could be complete and running in a day or two. &nbsp;If you add in the time to learn PHP, MySQL, RSS and internet security, you're looking at considerably more time from start to deployment (perhaps a semester of college). 
 
Good luck, It would be a fun project! &nbsp;~Ray 

<pre><code class="code-10 nolinks" id="code-120663">&lt;?xml version=&quot;1.0&quot; encoding=&quot;ISO-8859-1&quot;?&gt;
&lt;rss version=&quot;2.0&quot; xmlns:media=&quot;http://search.yahoo.com/mrss&quot;&gt;
&lt;!-- --&gt;
&lt;!-- --&gt;
&lt;!-- IF YOU CAN SEE THIS, YOU NEED AN RSS READER! --&gt;
&lt;!-- --&gt;
&lt;!-- --&gt;
&lt;channel&gt;
&lt;title&gt;National Trust Community Investment Corporation News&lt;/title&gt;
&lt;link&gt;http://www.NTCICFunds.com/&lt;/link&gt;
&lt;description&gt;NTCIC makes equity investments in real estate projects that qualify for historic tax credits.&lt;/description&gt;
&lt;language&gt;en-us&lt;/language&gt;
&lt;pubDate&gt;Fri, 17 Aug 2007 09:25:38 CDT&lt;/pubDate&gt;
&lt;image&gt;
&lt;url&gt;http://NTCICFunds.com/images/ntcic_rss_logo.png&lt;/url&gt;
&lt;title&gt;NTCIC Web Site&lt;/title&gt;
&lt;link&gt;http://www.NTCICFunds.com/&lt;/link&gt;
&lt;/image&gt;
&lt;item&gt;
&lt;title&gt;NTCIC News Updated on Fri, 17 Aug 2007 09:25:38 CDT!&lt;/title&gt;
&lt;link&gt;http://www.NTCICFunds.com/news/&lt;/link&gt;
&lt;description&gt;The RSS Feed from www.NTCICFunds.com has been updated.&lt;/description&gt;
&lt;pubDate&gt;Fri, 17 Aug 2007 09:25:38 CDT&lt;/pubDate&gt;
&lt;/item&gt;
&lt;/channel&gt;
&lt;/rss&gt;
</code></pre>
</div>

<div>
 &nbsp; &nbsp; Hi again PredatorGR: It took me a while to compile a basic script that you ask for. Its just a basic core build with some missing properties :) ,that you can easily re-form or expand as you wish... 
&nbsp; &nbsp; 

<pre><code class="code-100 nolinks" id="code-120690">###################rss_news########################################
CREATE TABLE `news` (
 `id` int(11) NOT NULL auto_increment,
 `topic` text,
 `news` text,
 `date` text,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
 
################NEWS.php################################################
&lt;style&gt;
#main{width:100%;height:100%;}
#main #box{text-align:center}
.pan{width:300px;}
.form{background:#FDF4B5}
.row{background:#FFF0F0}
p.type_1{font-family:Verdana, Arial, Helvetica, sans-serif;font-size:12px;color:#333}
a {text-decoration:none}
a:hover{color:#990000}
a:active{color:#333333}
a:visited{color:#666666}
h1{font-family:Verdana, Arial, Helvetica, sans-serif;color:#990000;font-size:14px}
&lt;/style&gt;
&lt;p class=&quot;type_1&quot;&gt;
&lt;?php
	$NEW = &quot;5&quot; ; //Set the numbers of news you want to publish..
	mysql_connect(&quot;localhost&quot;,&quot;root&quot;,&quot;&quot;) or die(&quot;Unable to connect Database Server&quot;.mysql_error()) ;
	mysql_select_db(&quot;rss_news&quot;) or die(&quot;Wrong database name or unable to select..!&quot;.mysql_error()) ;
	$page = $_POST['page'] ;
	switch($page) {
	case(&quot;add&quot;) :
	$topic = htmlspecialchars($_POST['topic']) ;
	$news = htmlspecialchars($_POST['news']) ;
	$date = time() ;
		if(mysql_query(&quot;INSERT INTO news(topic,news,date) VALUES('$topic','$news','$date')&quot;)) {
			echo &quot;News added successfully...&lt;a href='#' onclick='history.back()'&gt;Back&lt;/a&gt;&quot; ;
		}
			else {
			echo &quot;Unable to add News , please try again later...&lt;a href='#' onclick='history.back()'&gt;Back&lt;/a&gt;&quot; ;
		}
	break;
	case(&quot;delete&quot;) :
	$del = $_POST['del'] ;
		foreach($del as $val) {
			mysql_query(&quot;DELETE FROM news WHERE id='$val'&quot;) ;
		}
	echo &quot;Selected news deleted successfully...&lt;a href='#' onclick='history.back()'&gt;Back&lt;/a&gt;&quot; ;
	break;
	case(&quot;xml&quot;) :
	$xml = $_POST['xml'] ;
	print_r($xml) ;
	break;
		default :
?&gt;
&lt;div class=&quot;pan&quot;&gt;
	&lt;form action=&quot;&lt;?php $_SERVER['PHP_SELF'] ?&gt;&quot; method=&quot;post&quot;&gt;
 &lt;input type=&quot;hidden&quot; name=&quot;page&quot; value=&quot;add&quot; /&gt;
 Topic : &lt;input type=&quot;text&quot; name=&quot;topic&quot; class=&quot;form&quot; /&gt;&lt;br /&gt;
 News Goes Here : &lt;textarea name=&quot;news&quot; cols=&quot;40&quot; rows=&quot;12&quot; class=&quot;form&quot;&gt;&lt;/textarea&gt;&lt;br /&gt;
 &lt;input type=&quot;submit&quot; value=&quot; Add &quot; class=&quot;form&quot; /&gt;&amp;nbsp;&lt;input type=&quot;reset&quot; value=&quot;Clear&quot; class=&quot;form&quot; /&gt;
 &lt;/form&gt;
&lt;/div&gt;
&lt;hr /&gt;
&lt;div class=&quot;pan&quot;&gt;
	&lt;h1&gt;News Written Recently &lt;/h1&gt;
 &lt;?php
	$qry = &quot;SELECT * FROM news ORDER BY id DESC limit $NEW&quot; ;
	$rslt = mysql_query($qry) ;
	echo &quot;&lt;form action='&quot;.$_SERVER['PHP_SELF'].&quot;' method='post'&gt;&quot; ;
	echo &quot;&lt;input type='hidden' name='page' value='delete'&gt;&quot;;
		while($row = mysql_fetch_assoc($rslt)) {
		$id = $row['id'] ;
			echo &quot;&lt;div class='row'&gt;&quot; ;
			echo $row['topic'].&quot;&lt;input type='checkbox' name='del[]' class='chk' value='$id'&gt;&quot; ;
			echo &quot;&lt;/div&gt;&quot; ;
			$topics .= &quot;|&quot;.$row['topic'];
			$news .= &quot;|&quot;.$row['news'] ;
			$date .= &quot;|&quot;.date(&quot;d/m/Y H:i:s&quot;,$row['date']) ;
		}	
	echo &quot;&lt;input type='submit' value=' Delete Selected' class='form'&gt;&quot; ;
	echo &quot;&lt;/form&gt;&quot; ;
	$topics = explode(&quot;|&quot;,$topics) ;
	$news = explode(&quot;|&quot;,$news) ;
	$date = explode(&quot;|&quot;,$date) ;
		$xml = new DOMDocument('1.0','UTF-8') ;
		$Xnews = $xml-&gt;createElement('News','') ;
		$Xnews = $xml-&gt;appendChild($Xnews) ;
			for($i=1;$i &lt; count($topics);$i++) {
			$new = $xml-&gt;createElement('New') ;
			$new-&gt;setAttribute('Date',$date[$i]) ;
			$new = $Xnews-&gt;appendChild($new);
			$topic = $xml-&gt;createElement('Topic',$topics[$i]) ;
			$topic = $new-&gt;appendChild($topic);
			$inf = $xml-&gt;createElement('Detail',$news[$i]) ;
			$inf = $new-&gt;appendChild($inf) ;	
			}
		$xml-&gt;save(&quot;news.xml&quot;);
	?&gt;
&lt;/div&gt;
&lt;?php
		break;	
	}
?&gt;
&lt;/p&gt;
</code></pre>
</div>

<div>
Hi, thanks for the script, i get those errors though: 
 
Warning: domdocument::domdocument() expects parameter 2 to be long, string given in C:\xampp\htdocs\xampp\test\rss.php on line 76 
 
Fatal error: Call to undefined method domdocument::createElement() in C:\xampp\htdocs\xampp\test\rss.php on line 77 
 
Any suggestions?
</div>

<div>
It works fine for me ,and i am using PHP version 5.2.5 ,it should work fine for v5 +
</div>

<div>
I am using the latest xampp, i didn't touched anything, is a clean install...
</div>

<div>
Can you please try to replace line 76 with ; 
$Xnews = $xml-&gt;createElement('News') ;
</div>

<div>
Now the news written recenlty works, i get below it: 
 
Fatal error: Call to a member function createElement() on a non-object in C:\xampp\htdocs\xampp\test\rss.php on line 75 
 
also, my data in the database is displayed messed up, i am using greek language and the db is in utf8. This also occurs under the &quot;News Written Recently&quot; (i've added some test news written in greek lang)
</div>

<div>
 &nbsp; Drop database and re-create by modifying the given line ,like below; 
&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB &nbsp;DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; 
&nbsp; &nbsp; &nbsp; &nbsp;And can you please send line 75 ,
</div>

<div>
That's how i instered the query, with utf8 charset but no luck 
 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 75 &nbsp; &nbsp; $Xnews = $xml-&gt;createElement('News') ; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;76 &nbsp; &nbsp; $Xnews = $xml-&gt;createElement('News','') ; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;77 &nbsp; &nbsp; &nbsp; $Xnews = $xml-&gt;appendChild($Xnews) ;
</div>

<div>
you should remove line 76 ,
</div>

<div>
again, i get an error in line 75!! the same error!
</div>

<div>
I've managed to fix the utf issue in the db, i added the 
 
&quot;mysql_query(&quot;SET NAMES 'UTF8'&quot;);&quot; 
 
right after the db connection and it works just fine. 
 
The only issue is line 75....
</div>

<div>
ok i recompiled the xml side , it seems that there is something wrong with your DOMDocument creation can you please try ; 

<pre><code class="code-10 nolinks" id="code-120797">&lt;style&gt;
#main{width:100%;height:100%;}
#main #box{text-align:center}
.pan{width:300px;}
.form{background:#FDF4B5}
.row{background:#FFF0F0}
p.type_1{font-family:Verdana, Arial, Helvetica, sans-serif;font-size:12px;color:#333}
a {text-decoration:none}
a:hover{color:#990000}
a:active{color:#333333}
a:visited{color:#666666}
h1{font-family:Verdana, Arial, Helvetica, sans-serif;color:#990000;font-size:14px}
&lt;/style&gt;
&lt;p class=&quot;type_1&quot;&gt;
&lt;?php
	$NEW = &quot;5&quot; ; //Set the numbers of news you want to publish..
	mysql_connect(&quot;localhost&quot;,&quot;root&quot;,&quot;&quot;) or die(&quot;Unable to connect Database Server&quot;.mysql_error()) ;
	mysql_select_db(&quot;rss_news&quot;) or die(&quot;Wrong database name or unable to select..!&quot;.mysql_error()) ;
	$page = $_POST['page'] ;
	switch($page) {
	case(&quot;add&quot;) :
	$topic = htmlspecialchars($_POST['topic']) ;
	$news = htmlspecialchars($_POST['news']) ;
	$date = time() ;
		if(mysql_query(&quot;INSERT INTO news(topic,news,date) VALUES('$topic','$news','$date')&quot;)) {
			echo &quot;News added successfully...&lt;a href='#' onclick='history.back()'&gt;Back&lt;/a&gt;&quot; ;
		}
			else {
			echo &quot;Unable to add News , please try again later...&lt;a href='#' onclick='history.back()'&gt;Back&lt;/a&gt;&quot; ;
		}
	break;
	case(&quot;delete&quot;) :
	$del = $_POST['del'] ;
		foreach($del as $val) {
			mysql_query(&quot;DELETE FROM news WHERE id='$val'&quot;) ;
		}
	echo &quot;Selected news deleted successfully...&lt;a href='#' onclick='history.back()'&gt;Back&lt;/a&gt;&quot; ;
	break;
	case(&quot;xml&quot;) :
	$xml = $_POST['xml'] ;
	print_r($xml) ;
	break;
		default :
?&gt;
&lt;div class=&quot;pan&quot;&gt;
	&lt;form action=&quot;&lt;?php $_SERVER['PHP_SELF'] ?&gt;&quot; method=&quot;post&quot;&gt;
 &lt;input type=&quot;hidden&quot; name=&quot;page&quot; value=&quot;add&quot; /&gt;
 Topic : &lt;input type=&quot;text&quot; name=&quot;topic&quot; class=&quot;form&quot; /&gt;&lt;br /&gt;
 News Goes Here : &lt;textarea name=&quot;news&quot; cols=&quot;40&quot; rows=&quot;12&quot; class=&quot;form&quot;&gt;&lt;/textarea&gt;&lt;br /&gt;
 &lt;input type=&quot;submit&quot; value=&quot; Add &quot; class=&quot;form&quot; /&gt;&amp;nbsp;&lt;input type=&quot;reset&quot; value=&quot;Clear&quot; class=&quot;form&quot; /&gt;
 &lt;/form&gt;
&lt;/div&gt;
&lt;hr /&gt;
&lt;div class=&quot;pan&quot;&gt;
	&lt;h1&gt;News Written Recently &lt;/h1&gt;
 &lt;?php
	$qry = &quot;SELECT * FROM news ORDER BY id DESC limit $NEW&quot; ;
	$rslt = mysql_query($qry) ;
	echo &quot;&lt;form action='&quot;.$_SERVER['PHP_SELF'].&quot;' method='post'&gt;&quot; ;
	echo &quot;&lt;input type='hidden' name='page' value='delete'&gt;&quot;;
		while($row = mysql_fetch_assoc($rslt)) {
		$id = $row['id'] ;
			echo &quot;&lt;div class='row'&gt;&quot; ;
			echo $row['topic'].&quot;&lt;input type='checkbox' name='del[]' class='chk' value='$id'&gt;&quot; ;
			echo &quot;&lt;/div&gt;&quot; ;
			$id .= &quot;|&quot;.$row['id'] ;
			$topics .= &quot;|&quot;.$row['topic'];
			$news .= &quot;|&quot;.$row['news'] ;
			$date .= &quot;|&quot;.date(&quot;d/m/Y H:i:s&quot;,$row['date']) ;
		}	
	echo &quot;&lt;input type='submit' value=' Delete Selected' class='form'&gt;&quot; ;
	echo &quot;&lt;/form&gt;&quot; ;
	$topics = explode(&quot;|&quot;,$topics) ;
	$news = explode(&quot;|&quot;,$news) ;
	$date = explode(&quot;|&quot;,$date) ;
	$id = explode(&quot;|&quot;,$id);
		$xml = fopen(&quot;news.xml&quot;,&quot;w+&quot;) ;
$cont = &quot;&lt;?xml version=\&quot;1.0\&quot; encoding=\&quot;UTF-8\&quot; ?&gt;&quot; ;
$cont .=&quot;&lt;news&gt;&quot; ;
	for($i=1;$i&lt;count($topics);$i++) {
	$cont .=&quot;&lt;item date=\&quot;$date[$i]\&quot;&gt;&quot; ;
	$cont .=&quot;&lt;title&gt;$topics[$i]&lt;/title&gt;&quot; ;
	$cont .=&quot;&lt;detail&gt;$news[$i]&lt;/detail&gt;&quot; ;
	$cont .=&quot;&lt;link&gt;http://www.mypage.com/?news_id=$id[$i]&lt;/link&gt;&quot; ;	
	$cont .=&quot;&lt;/item&gt;&quot; ;
	}
$cont .=&quot;&lt;/news&gt;&quot;;	
		fwrite($xml,$cont) ;
		fclose($xml) ;		
	?&gt;
&lt;/div&gt;
&lt;?php
		break;	
	}
?&gt;
&lt;/p&gt;
</code></pre>
</div>

<div>
 &nbsp;And there is a little bug about ids given on link , you should remove 
&nbsp; &nbsp; &nbsp;$id = $row['id'] ; 
&nbsp;Which is line 62 for me..
</div>

<div>
Now i don't have any issues at all, utf fixed, works like a charm!! 
 
is there a way to refresh the main page after clicking the &quot;Back&quot; ? 
 
Every time i add something it needs refresh to be shown!
</div>

<div>
I cannot delete the recent news, i check the box, pressed delete but nothing happens. ( i also checked the db, they are still there!)
</div>

<div>
a trillion thanks my friend, is there a way to add style information to the xml? right now it displays like plain text!
</div>

<div>
Hi Ali, 
 
i am currently at home, i will try this first thing in the morning when i go to the office! 
 
sorry for this!
</div>

<div>
thanks for your support m8!! i avoided lot of hassle with this script!!
</div>

<div>
It worked like a charm, thanks my friend!!!!!!! 
 
What code i must put in the php so it can have UTF-8 character encoding by default? Every time i open the page is has iso-8859 and my language cannot be displayed properly. I must set the encoding to utf-8 manually!
</div>

<div>
<div class="content wysiwyg-content">
Hi experts, 
 
Where i can find a PHP form to MySQL script for free (commercial is the last option)? 
 
All i want to do is to host a php script in my local server so the users can fill out specific form fields like: 
 
News 1 
News 2 
News 3 
etc 
 
Then click a submit button and insert all these data to a MySQL database. 
 
After this, i want a PHP script that can fetch those fields and export them to XML RSS 2.0. 
 
Every morning those fields will be updated so the RSS will be updated daily. 
 
Please note that this is for a newspaper company that wants to display those News fields in big screen around my country so for example today they have only 5 headlines, tommorow they may be 10 so the RSS must be updated accordingly. 
 
Any Suggestions?
</div>
</div>

Hi experts,

Where i can find a PHP form to MySQL script for free (commercial is the last option)?

All i want to do is to host a php script in my local server so the users can fill out specific form fields like:

News 1
News 2
News 3
etc

Then click a submit button and insert all these data to a MySQL database.

After this, i want a PHP script that can fetch those fields and export them to XML RSS 2.0.

Every morning those fields will be updated so the RSS will be updated daily.

Please note that this is for a newspaper company that wants to display those News fields in big screen around my country so for example today they have only 5 headlines, tommorow they may be 10 so the RSS must be updated accordingly.

Any Suggestions?

Where i can find a PHP form to MySQL script for free?

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.

Web Languages and Standards

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).