{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 时光不老，我们不散 的问题《Use Iframe to embed csv and allow user to search f》','https://www.manongdao.com/q-741129.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I have a simple html/jscript code here which allow users to enter a keyword and return result from sample csv data (simulated as var CSV in this code) to table format in HTML, now I wish to use the iframe where the CSV is embedded instead of referring my DB to this simulated CSV, how can I do that? This code is working fine but I need to refer my search database to iframe. Thank you in advance.
<html>
<head>
<title>CSV Database</title>
<script type="text/javascript">
/* Following is a SIMULATED CSV file only.*/
var CSV = 'APRIL,RED,HAPPY,TEACHER,092236015\n';
CSV += 'BRIAN,YELLOW,SAD,ENGINEER,092236015\n';
CSV += 'JIMBOY,BLUE,CRAZY,PROGRAMMER,092236015\n';
CSV += 'JAYCEE,GREEN,MOODY,MAKE-UP_ARTIST,092236015\n';
CSV += 'GALLIE,BLACK,SERIOUS,CYCLIST,092236015\n';
</script>
</head>
<body onload="MakeDB()">
Keyword: <input type="text" value="" id="ERP">
<input type="button" value="Search" onclick="CSVsearch(document.getElementById('ERP').value)">
<p>
<div id="tblDisplay"></div>
<script type="text/javascript">
var DB = new Array();
function MakeDB() { DB = CSV.split('\n'); }
function CSVsearch(dbInfo) {
var posn = -1;
for (i=0; i<DB.length; i++) {
tmp = DB[i];
if (tmp.indexOf(dbInfo) != -1) { posn = i; break; }
}
if (posn == -1) { alert('No matching result from the file'); }
else { document.getElementById('tblDisplay').innerHTML = displayAsTable(DB[posn]); }
}
function displayAsTable(info) {
var str = '<table border="1" width="35%">';
var ary = info.split(',');
str += '<tr><th>KEYWORD</th><th>INFO1</th><th>INFO2</th><th>INFO3</th><th>INFO4</th></tr>';
str += '<tr><td>'+ary.join('</td><td>')+'</td></tr>';
str += '</table>';
return str;
}
</script>
<br>
<br>
<br>
<br>
<br>
<iframe src="file:///C:/Users/april_ibanga/Desktop/data.txt" name="data" frameborder="1" scrolling="auto" width="700" height="300" align="bottom"></iframe>
</body>
</html>
From what I can tell, you can't load just anything in an iframe and scrape it. The Javascript normally would be frameVar.contentWindow, but this is null when I attempt it with the src being a txt or csv file.
Web applications usually handle this via web service calls that return html,xml,json responses that represent the serialized file contents.
Good luck!