Jump to content

gojakie

Members
 View Profile  See their activity

  • Posts

    16

  • Joined

  • Last visited

    Never

 Content Type 

Everything posted by gojakie

  1. gojakie
    Dear friends, I always use frontpage to create an html page and then mix it up with my dynamic content and rename the file to .php I have now made a frames page and have put 10+ html files in those frames but it seems <frameset> doesn't work with php. Can anybody comment on this? Here is my code <?php require_once ( 'settings.php' ); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Welcome</title> </head> <frameset framespacing="2" border="1" frameborder="1" cols="74%,13%,13%"> <frameset rows="80%,20%"> <frameset cols="25%,25%"> <frameset rows="20%,13%,26%,20%,20%"> <frame name="03" scrolling="no" noresize src="3.php"> <frame name="09" scrolling="no" noresize src="9.php"> <frame name="01" scrolling="no" noresize src="1.php" > <frame name="08" scrolling="no" noresize src="8.php"> <frame name="10" scrolling="no" noresize src="10.php"> </frameset> <frameset rows="50%,50%"> <frame name="06" scrolling="no" noresize src="6.php"> <frame name="07" scrolling="no" noresize src="7.php"> </frameset> </frameset> <frame name="05" scrolling="no" noresize src="5.php"> </frameset> <frame name="04" scrolling="no" noresize src="4.php"> <frame name="11" scrolling="no" noresize src="11.php"> <noframes> <body> <p>This page uses frames, but your browser doesn't support them.</p> </body> </noframes> </frameset> Thanks
  2. gojakie
    Thank you so much. Your say on #3 is beyond my reach. Can I get help on that too?
  3. gojakie
    Dear friends, Awaiting your replies. Please help. Thank you
  4. gojakie
    Dear friends, I have been helped to modify two codes out of which one is working and I need help on the other one. Working code: It connects to yahoo website and pulls required data based on the string "sl1c1p2ohgpvjk" where: s=Symbol l1=Current market price c1=Change p2=Change % o=Open h=High g=Low p=Previous Close v=Volume j=52 week low k=52 week high Attached 3 files: 1.php (working code) 2.php (need help) 3.symbols.txt Here is the working code: <?php $arr = array ('20MICRONS.NS','3IINFOTEC.NS','3MINDIA.NS','AARTIDRUG.NS','AARTIIND.NS','ABAN.NS','ABB.NS'); $url= "http://in.finance.yahoo.com/d/quotes.csv?s=".implode("+",$arr)."&f="."sl1c1p2ohgpvjk"; echo "<table>"; echo "<b><th>Symbol</th> <th>Market Price</th> <th>Change</th> <th>Change %</th> <th>Open</th> <th>High</th> <th>Low</th> <th>Previous Close</th> <th>Volume</th> <th>52 Week Low</th> <th>52 Week High</th></b>"; $handle = fopen($url, "r"); while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { echo "<tr>"; foreach($data as $d) echo "<td>$d</td>"; echo "</tr>"; } fclose($handle); echo "</table>"; ?> Another code: It does the same as above. The only difference is that, the above code gets data of only 7 companies and this one gets data of 100 companies. Changes made in this code is that the array is taken from an external "symbols.txt" file and it fetches 50 records in one go because yahoo limits to 50 companies at a time in one query. <?php $fo=fopen("symbols.txt","r"); while ($line = fgets($fo)) { $arr[] = $line; if (count($arr) >= 50) { $url= "http://in.finance.yahoo.com/d/quotes.csv?s=".implode("+", $arr)."&f="."sl1c1p2ohgpvjk"; echo "<table>"; echo "<b><th>Symbol</th> <th>Market Price</th> <th>Change</th> <th>Change %</th> <th>Open</th> <th>High</th> <th>Low</th> <th>Previous Close</th> <th>Volume</th> <th>52 Week Low</th> <th>52 Week High</th></b>"; $handle = fopen($url, "r"); while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { echo "<tr>"; foreach($data as $d) echo "<td>$d</td>"; echo "</tr>"; } fclose($handle); echo "</table>"; $arr = NULL; } } ?> I need help on the following: 1. Unable to get data from the second code. It lists the companies but doesn't get the "sl1c1p2ohgpvjk" data. 2. Creates two different tables for 100 companies whereas I want all data in one table so that an user can sort all of them based on his/her requirement. 3. symbols.txt file actually has 106 symbols. It pulls data for first 100 and the last 6 are ignored. How can I get them to show up on the table? Thank you [attachment deleted by admin]
  5. gojakie
    Would really appreciate if somebody can help this novice
  6. gojakie
    yeah regarding escaping quotes, even I thought so as the error was self explanatory. Since I am beginner to php and no knowledge of programming and syntax, I was not able to figure out which quote to change/remove. Issue is resolved. Thank you very much. One request. One of my post is still unanswered. The subject is Beginner in PHP - Need modification in a code and topic id is 230455. Mchl was helping me on that but no responses later. Can you guys help? I have posted 4 problems at the last post and looking answers for that. Thanks again.
  7. gojakie
    It gives me an error arse error: syntax error, unexpected '{', expecting ',' or ';' I tried this thrice. I then changed the string to the previous one that you gave which worked and again tried the second solution but the same error. I am also looking solution for the second question where I want to add one more column to my table at the end next to "View". The content of this column would be a small image 15x15 pixel image. There are three images. If the third column has a negative number, the last column should show n.jpg. p.jpg for positive number and z.jpg for zero. Thanks
  8. gojakie
    It works. Thanks But the word "View" doesn't look like hyperlink. It looks like a normal font. Even if I put my mouse over it, it the cursor doesn't change to finger, it looks like a arrow. The user will not understand that this is a link. I had put a <u> element to underline it, but it doesn't look like a link. It works though I want to add one more column to my table at the end next to "View". The content of this column would be a small image 15x15 pixel image. There are three images. If the third column has a negative number, the last column should show n.jpg. p.jpg for positive number and z.jpg for zero. Thanks
  9. gojakie
    echo "<table>"; $handle = fopen($url, "r"); while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { echo "<tr>"; foreach($data as $d) echo "<td>$d</td>"; echo "<td>View</td>"; echo "</tr>"; } fclose($handle); echo "</table>"; The output of the above code is a table which is a grid of 100 rows and 12 columns. The last column is the <td>View</td> on which I need to add a hyperlink after clicking on which it should open a small window-like page without toolbars/menubars that should contain an image. The name of the image will be text in the first column.jpg Example A B C D E F G H I J K View L M N O P Q R S T U V View If I click on the first View, I should get a page with an image embeded in it A.jpg If I click on the first View, I should get a page with an image embeded in it B.jpg Thanks
  10. gojakie
    The code is now running but i am still not able to figure out why is it not pulling up the data. May i request you to run the code given below and let me know what is wrong? <?php require_once ( 'settings.php' ); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Stock</title> </head> <?php $fo=fopen("symbols.txt","r"); //open file for reading while ($line = fgets($fo)) { //read the file line, by line $arr[] = $line; //add line to $array if (count($arr) >= 50) { //check if there are 50 items in $array $url= "http://in.finance.yahoo.com/d/quotes.csv?s=".implode("+", $arr)."&f="."sl1c1p2ohgpvjk"; echo "<table>"; $handle = fopen($url, "r"); while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { echo "<tr>"; foreach($data as $d) echo "<td>$d</td>"; echo "</tr>"; } fclose($handle); echo "</table>"; $arr = NULL; //empty $array } } ?> Problems with this code: 1. Not pulling up the data. May be because of: a. Stock codes shows differently in the $url variable eg. 20MICRONS.NS__ b. In the $url, there is a leading SPACE after the "+" sign c. In the $url, the stock codes are not given in quotation marks " ' " 2. In this example, I am trying to fetch data of 50 companies in one shot. In this case, different tables are created each consisting data of 50 codes I want all the data in ONE BIG TABLE so that I can use scripts to sort it. 3. It downloads 1200 records properly but doesn't download the last 25??? 4. Is it required to use fclose at the end to close the fopen? and for fgets? Besides solving above problems, I need one enhancement. If I move my mouse in any of the symbol, it should pop up a small page with the image associated with it. For example, if I move my mouse on 20MICRONS.NS, i should get a small script-like page with an image 20MICRONS.jpg Thanks
  11. gojakie
    Forgot to write one thing. In the output it shows the symbol as 20MICRONS.NS__ 3IINFOTEC.NS__ There are no trailing or leading spaces in my symbols.txt file. Why does it add two underscores after .NS? Is it because of this my data is not fetching?
  12. gojakie
    looks like it is working but not fetching data and also getting few errors $url contains fopen(http://in.finance.yahoo.com/d/quotes.csv?s=20MICRONS.NS +3IINFOTEC.NS + Is it because it adds additional SPACE after .NS? or is it because it is not getting in this format '20MICRONS.NS'+'3IINFOTEC.NS'+ of is it becuase of both?
  13. gojakie
    Thanks again for your reply Few questions: while ($line = fgets($fo)) would read the file line by line. Will it read till the end of file? If yes, it will be of no use as I want only first 200 lines in the array. Similarly $array[] = $line; adds the line to the array. Will will add all 1225 lines as it is the next statement after fgets? We will somehow have to tell that, only fetch the first 200 lines, process the rest of the code then read 201-400 and process the same code again and loop it till the end of the txt file. May be you are giving right answers and I am unable to understand. I am a novice and unable to modify the code that I posted with the logic you have provided purely because I am new to php and don't know the syntax. I started using and understanding php since only a week. Its been over 10 hours I am sitting continuously on this and running around for a solution. Its driving me crazy now. May I ask you to modify the code in my first post that gives the desired output? All I need is an output of 1225 records. A gird of 1225 rows and 11 columns. Thanks
  14. gojakie
    I am still reading the manual. I am getting the logic but unable to write it due to less knowledge of syntax. I think something like this can help. $fo=fopen(symbols.txt,r); $array=explode("\n",$fo); I open the file and put it in the array. My question is: I have 1225 entries in my symbol.txt file and yahoo accepts less than 200 items in one csv string. How can edit the code to pick only first 200 items in the array, process the table and then take the next 200 until it reaches the end of the file? The code I placed processes 7 records as it has only 7 items in the array. Somebody please help me modify the code so that it fetches all 1225 records by reading items from the symbols.txt file. Thanks
  15. gojakie
    Dear mchl, Thank you for your reply. I am going to read the manual. As I said, I am a beginner, I will try and understand how fgetcsv and fopen functions. In the meantime, I would like to attach list of all 1225 yahoo symbols which I need to refresh on my html page. Please find the attachment. Thanks [attachment deleted by admin]
  16. gojakie
    Dear friends, warm greetings of the season. This is my first post. I am a beginner in php and I am completely unaware of its syntax. I would like to have yahoo stock quotes on an html page. In the past one week, I have been googling a lot and found a working code from somewhere on the Internet. I understood it a bit and made few changes that suits my needs. However, I need some further modification and need help on this. Here is the code: <?php $arr = array ('UNITECH.NS','VIDEOIND.NS','SUZLON.NS','RPL.NS','HDFC.NS','RNRL.NS','HINDALCO.NS'); $url= "http://in.finance.yahoo.com/d/quotes.csv?s=".implode("+", $arr)."&f="."sl1c1p2ohgpvjk"; echo "<table>"; $handle = fopen($url, "r"); while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { echo "<tr>"; foreach($data as $d) echo "<td>$d</td>"; echo "</tr>"; } fclose($handle); echo "</table>"; ?> Explanation of the "&f="."sl1c1p2ohgpvjk" line s=Symbol l1=Current market price c1=Change p2=Change % o=Open h=High g=Low p=Previous Close v=Volume j=52 week low k=52 week high I have another few questions. I would really appreciate if somebody can help me. The above code only fetches results of 7 companies. I can get as many as possible but <200. Yahoo has a limit to its csv line. We can extract data of Maximum 200 companies in one csv string. Problem # 1 Instead of adding 200 company codes in the $arr array variable, is it possible to keep it in an external source? May be in a different .php file or in a notepad file? and call it somehow? Problem # 2 In the line while (($data = fgetcsv($handle, 1000, ",")) !== FALSE), what is the importance of the figure 1000? If I increase the company codes from 7 to 200, do I have to increase the $handle figure? Problem # 3 Actually I want to extract data of more than 1218 companies but yahoo limits it to 200 per csv string. How can I modify the code to get all 1218 company's data? In excel vba, to fetch more than 200, I can have a code like given below. How can I modify the php code to get data or 1218 companies in one shot? I am not aware of php syntax. For iMax = 0 To 1000 Step 200 i = 7 + iMax If Cells(i, 1) = "" Then GoTo stopHere End If . . Query to fetch the data . . Putting the first 200 records in the worksheet . . Next iMax All Stock symbols can be downloaded from in.finance.yahoo.com or http://www.traderji.com/attachments/software/2078d1153867956-ystock-realtime-charts-eod-downloads-nse-symbols.zip Thank you
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.