i am stuck mysql

arunsuriindia Peon

Messages:: 61

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#1

I need to convert table in html file into mysql.

how can i do this

arunsuriindia, Mar 23, 2007 IP

tandac Active Member

Messages:: 337

Likes Received:: 11

Best Answers:: 0

Trophy Points:: 58

#2

I would probably try opening the html table in excel and saving it as a CSV which could be easily imported.

If that wouldn't work, a little perl scripting should take care of it.

tandac, Mar 24, 2007 IP

aredhelrim likes this.

arunsuriindia Peon

Messages:: 61

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#3

thats what i thought but then the fields need to be demerded and dewrap.
how do i do this from php.

csv still contains merged cells .

if i copy the csv to txt then i get the html code.

arunsuriindia, Mar 24, 2007 IP

mysqlavid Peon

Messages:: 1

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#4

Thats What I Have Been Facing

Tandac Can U Show A Script

mysqlavid, Mar 24, 2007 IP

aredhelrim Peon

Messages:: 7

Likes Received:: 1

Best Answers:: 0

Trophy Points:: 0

#5

You can do it by using a php script which parsing html file and then you can export the data to csv or into mysql.

Take a look hotscripts.com for script.

aredhelrim, Mar 24, 2007 IP

tandac Active Member

Messages:: 337

Likes Received:: 11

Best Answers:: 0

Trophy Points:: 58

#6

Put the HTML file up somewhere and I'll see what I can do. No promises though.

tandac, Mar 24, 2007 IP

hamidof Peon

Messages:: 619

Likes Received:: 44

Best Answers:: 0

Trophy Points:: 0

#7

You need to use regular expressions to do this, post a sample of the table.

hamidof, Mar 24, 2007 IP

weknowtheworld Guest

Messages:: 306

Likes Received:: 2

Best Answers:: 0

Trophy Points:: 0

#8

Please paste a sample table here...

weknowtheworld, Mar 25, 2007 IP

arunsuriindia Peon

Messages:: 61

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#9

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 3.0//EN"><html><head><title>NSE - Equities - Market Watch</title><LINK href="/nse.css" rel=STYLESHEET type=text/css><script language="javascript" src="/js/commonfuncs.js"></script><script language="javascript" src="/js/tablesort.js"></script><script language="javascript">var isIE=(document.all)?1:0;var isNS4=(document.layers)?1:0;var isNS6=((document.getElementById)&&(navigator.appName=='Netscape'))?1:0;var isNS=((isNS4)||(isNS6))?1:0;var DHTML=(isIE||isNS4||isNS6)?1:0;function handleError() { return true; }window.onerror = handleError;capEvents();</script></head><BODY bgcolor=#ffffff leftmargin=0 topmargin=0 marginheight=0 marginwidth=0><div name=menulayer id=menulayer style= 'visibility:hidden; position:absolute; width:1px; height:1px; z-index:1; left:1; top:1'></div><form name=paginate method =GET action=niftywatch.jsp >  <TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 width=800 <tr height=50> <td rowspan=6 width=10> </td> <td class=smalllinks><a name=top></a><BR><a href="/homepage.htm">Home</a> > <a href=/content/equities/eq_introduction.htm>Equities</a> > <a href=/content/equities/eq_mktinfo.htm>Market Information</a> &gt <a href=/content/equities/eq_markettoday.htm>Market Today</a> > BANK NIFTY Stock Watch <img src=/images/trans.gif height=1 width=210><a href=javascript:location.reload() class=specialhead2> REFRESH PAGE </a><br><br></td></tr> <tr><td class=header>BANK NIFTY Stock Watch <img src=/images/trans.gif height=1 width=450><font class=smallwt align=right><a href=/marketinfo/indices/indexwatch_banknifty.jsp>BankNifty Watch</a></font></td></tr> <tr><td class=smalllinks>(Click headers to sort)</td></tr> <tr><td class=smalllinks align=right>As on 23-MAR-2007 16:00:05 Hours IST</td></tr> <tr> <td> <TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 bgcolor=#969696 width=100%> <TR><TD> <TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1 width=100% name=ResultSetTable id=ResultSetTable cols=11><tr><td class=tablehead><A href="javascript:sortTable(0, ResultSetTable);">Symbol</A></td><td class=tablehead >Open</td><td class=tablehead >High</td><td class=tablehead >Low</td><td class=tablehead >Prev.<BR>Close</td><td class=tablehead >LTP</td><td class=tablehead ><A href="javascript:sortTable(6, ResultSetTable);">% Change</A></td><td class=tablehead ><A href="javascript:sortTable(7, ResultSetTable);">Total<BR>trd qty</A></td><td class=tablehead ><A href="javascript:sortTable(8, ResultSetTable);">Turnover <BR>(Rs.Lakhs)</A></td><td class=tablehead >Last<BR>Ex Date</td><td class=tablehead >Last<BR>Corporate Action</td></tr><tr><td class=t0><a href=/marketinfo/equities/cmquote.jsp?key=ICICIBANKEQN&symbol=ICICIBANK&flag=0>ICICIBANK</a></td><td class=t1>870.00</td><td class=t1>917.00</td><td class=t1>870.00</td><td class=t1>899.60</td><td class=t1>891.60</td><td class=t1>-0.89</td><td class=t1>2255056</td><td class=t1>20255.14</td><td class=t2 width=63>06-JUL-06</td><td class=t0>AGM/DIV-RS.8.50/- PER SH</td></tr><tr><td class=t0><a href=/marketinfo/equities/cmquote.jsp?key=SBINEQN&symbol=SBIN&flag=0>SBIN</a></td><td class=t1>1034.00</td><td class=t1>1042.85</td><td class=t1>1013.00</td><td class=t1>1029.40</td><td class=t1>1026.20</td><td class=t1>-0.31</td><td class=t1>1326828</td><td class=t1>13635.12</td><td class=t2 width=63>19-JUN-06</td><td class=t0>DIVIDEND-RS.14 PER SHARE</td></tr><tr><td class=t0><a href=/marketinfo/equities/cmquote.jsp?key=BANKINDIAEQN&symbol=BANKINDIA&flag=0>BANKINDIA</a></td><td class=t1>175.80</td><td class=t1>178.00</td><td class=t1>171.20</td><td class=t1>176.50</td><td class=t1>173.80</td><td class=t1>-1.53</td><td class=t1>5292403</td><td class=t1>9194.49</td><td class=t2 width=63>19-DEC-06</td><td class=t0>DIVIDEND -20%</td></tr><tr><td class=t0><a href=/marketinfo/equities/cmquote.jsp?key=HDFCBANKEQN&symbol=HDFCBANK&flag=0>HDFCBANK</a></td><td class=t1>1030.00</td><td class=t1>1030.00</td><td class=t1>996.00</td><td class=t1>1025.90</td><td class=t1>1011.15</td><td class=t1>-1.44</td><td class=t1>577582</td><td class=t1>5822.14</td><td class=t2 width=63>11-MAY-06</td><td class=t0>AGM/DIV-RS.5.50 PER SHARE</td></tr><tr><td class=t0><a href=/marketinfo/equities/cmquote.jsp?key=UTIBANKEQN&symbol=UTIBANK&flag=0>UTIBANK</a></td><td class=t1>504.90</td><td class=t1>530.00</td><td class=t1>491.55</td><td class=t1>503.90</td><td class=t1>524.65</td><td class=t1>4.12</td><td class=t1>995365</td><td class=t1>5130.81</td><td class=t2 width=63>16-MAY-06</td><td class=t0>AGM/DIVIDEND-35%</td></tr><tr><td class=t0><a href=/marketinfo/equities/cmquote.jsp?key=PNBEQN&symbol=PNB&flag=0>PNB</a></td><td class=t1>464.00</td><td class=t1>488.00</td><td class=t1>464.00</td><td class=t1>482.95</td><td class=t1>480.40</td><td class=t1>-0.53</td><td class=t1>746211</td><td class=t1>3591.36</td><td class=t2 width=63>14-FEB-07</td><td class=t0>INTERIM DIVIDEND-40%</td></tr><tr><td class=t0><a href=/marketinfo/equities/cmquote.jsp?key=CANBKEQN&symbol=CANBK&flag=0>CANBK</a></td><td class=t1>210.00</td><td class=t1>211.85</td><td class=t1>200.30</td><td class=t1>208.10</td><td class=t1>202.05</td><td class=t1>-2.91</td><td class=t1>1227397</td><td class=t1>2505.61</td><td class=t2 width=63>14-JUN-06</td><td class=t0>AGM/DIVIDEND-66%</td></tr><tr><td class=t0><a href=/marketinfo/equities/cmquote.jsp?key=CORPBANKEQN&symbol=CORPBANK&flag=0>CORPBANK</a></td><td class=t1>275.00</td><td class=t1>298.50</td><td class=t1>265.00</td><td class=t1>274.40</td><td class=t1>292.00</td><td class=t1>6.41</td><td class=t1>694432</td><td class=t1>1983.23</td><td class=t2 width=63>15-JUN-06</td><td class=t0>AGM</td></tr><tr><td class=t0><a href=/marketinfo/equities/cmquote.jsp?key=BANKBARODAEQN&symbol=BANKBARODA&flag=0>BANKBARODA</a></td><td class=t1>224.00</td><td class=t1>227.90</td><td class=t1>219.15</td><td class=t1>226.75</td><td class=t1>220.55</td><td class=t1>-2.73</td><td class=t1>605828</td><td class=t1>1347.30</td><td class=t2 width=63>22-MAR-07</td><td class=t0>INTERIM DIVIDEND-30% PURPOSE REVISED</td></tr><tr><td class=t0><a href=/marketinfo/equities/cmquote.jsp?key=SYNDIBANKEQN&symbol=SYNDIBANK&flag=0>SYNDIBANK</a></td><td class=t1>72.50</td><td class=t1>72.50</td><td class=t1>68.55</td><td class=t1>71.90</td><td class=t1>68.90</td><td class=t1>-4.17</td><td class=t1>954188</td><td class=t1>665.16</td><td class=t2 width=63>06-DEC-06</td><td class=t0>INTERIM DIVIDEND-15%</td></tr><tr><td class=t0><a href=/marketinfo/equities/cmquote.jsp?key=ORIENTBANKEQN&symbol=ORIENTBANK&flag=0>ORIENTBANK</a></td><td class=t1>189.90</td><td class=t1>189.90</td><td class=t1>183.00</td><td class=t1>189.00</td><td class=t1>183.65</td><td class=t1>-2.83</td><td class=t1>356370</td><td class=t1>657.36</td><td class=t2 width=63>07-MAR-07</td><td class=t0>INTERIM DIVIDEND-20%</td></tr><tr><td class=t0><a href=/marketinfo/equities/cmquote.jsp?key=UNIONBANKEQN&symbol=UNIONBANK&flag=0>UNIONBANK</a></td><td class=t1>101.00</td><td class=t1>107.90</td><td class=t1>101.00</td><td class=t1>105.70</td><td class=t1>104.55</td><td class=t1>-1.09</td><td class=t1>608432</td><td class=t1>635.87</td><td class=t2 width=63>11-JAN-07</td><td class=t0>INTERIM DIVIDEND-15%</td></tr></TABLE></td></tr></table></center></p></td></tr><tr><td><font class=smallwt align=left><a href=/marketinfo/indices/indexwatch_banknifty.jsp>BANK Nifty Watch</a><br><br></font></td></tr><tr><td><font class=smallwt align=left><br></font></td></tr></table><table BORDER=0 CELLPADDING=0 CELLSPACING=0 width=800><tr><td class=smalllinks><img src=/images/trans.gif width=20>Note:</td></tr> <tr><td class=smalllinks> <ul><li>% change is w.r.t. Prev. Close</li><li>On ex-date % change is w.r.t. open price</li></ul></td></tr><tr><td><center class=smalllinks><a href=/content/equities/cmquote.htm>Get Quote</a> | <a href=/marketinfo/indices/indexwatch.jsp>Index Watch</a> | <a href=/content/equities/TopGainers.htm>Top Gainers</a> | <a href=/content/equities/TopLosers.htm>Top Losers</a> | <a href=/content/equities/MostActiveSecurities.htm>Most Active Securities</a></center></td></tr><tr><td> </td></tr><tr><td><center class=smalllinks>Stock Watch : <a href=/content/equities/niftywatch.htm>Nifty</a> | <a href=/content/equities/jrniftywatch.htm>Junior Nifty</a> | <a href=/content/equities/cnxitwatch.htm>CNX IT</a></center><br></td></tr><tr><td><center class=smalllinks>Watch : <a href=/marketinfo/indices/indexwatch_nifty.jsp>Nifty</a> | <a href=/marketinfo/indices/indexwatch_jrnifty.jsp>Junior Nifty</a> | <a href=/marketinfo/indices/indexwatch_cnxit.jsp>CNX IT</a> | <a href=/marketinfo/indices/indexwatch_banknifty.jsp>Bank Nifty</a><br><br><a href=#top>Top</a></center></td></tr></table><br><br></body></html>

arunsuriindia, Mar 25, 2007 IP

arunsuriindia Peon

Messages:: 61

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#10

i want to read every thing in the grey colour

arunsuriindia, Mar 25, 2007 IP

Log in or Sign up

i am stuck mysql

arunsuriindia Peon

tandac Active Member

arunsuriindia Peon

mysqlavid Peon

aredhelrim Peon

tandac Active Member

hamidof Peon

weknowtheworld Guest

arunsuriindia Peon

arunsuriindia Peon

Useful Searches