vai_ron

hi, thanks for replying hehe... i'll use it in an existing site that has a lot of data or records on it what i needed to do is extract those data and import it to a database

hi, can anyone help me on how to extract a text from html and saves it to a database using mysql, im just new to php so i dont have a clue on how to do it, for example i have an html named data.html containing text like:   id_no: 12345   name: hdagh   date: 00/00/00   time: 1:00 p.m. and etc... so how do i save it to mysql? thanks!!!

i think php is better if you have so many rows, here is a simple one in php hope this helps!! [code] <?php  $query = "SELECT * FROM table"; $result = $dbh->query($query); // output query into a table echo "<br><br><table border=0>\n"; // fetch rows as object    example if you only have 2 rows: printf ("%s, %s\n", $row->rowname1, $row->rowname2); while($row = $result->fetchRow(DB_FETCHMODE_OBJECT)) { // alternate table color output if($x%2): $color = "#eee"; else: $color = "#cecece"; endif; // output row values, rows are fetch as object printf("<tr><td style=\"background-color: ".$color. "\">%s</td><td style=\"background-color: ".$color."\">%s</td></tr>\n", $row->rowname1, $row->rowname2); $x++; } echo "</table>\n"; ?> [/code]

[quote] maybe this will help [url=http://www.kitebird.com/articles/peardb.html]http://www.kitebird.com/articles/peardb.html[/url] [/quote]

hi i'm new to php, can anyone help me about searching a text in a page using php thanks!

i've just found out that the SMTP service in xampp is deactivated, apache is not an FTP server

i'm new to php, i'm making an autoresponder, everytime i send a mail, i have an warning: Warning: mail() [function.mail]: Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() in C:\Program Files\xampp\htdocs\tutorials\email2.php on line 110 could someomne help me with this one, i'll really appreciate it