Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by CosetteGirardot

  1. http://stackoverflow.com/q/26809213/4080419 GOAL: To have multiple people edit a Google Spreadsheet and have all edits display on a webpage (not Google site) where my css takes over the formatting and display of the content coming from the Spreadsheet. PROBLEM: I am brand new to PHP, as in I've been doing tutorials all week and this is my first time working with it. Likewise, I'm brand new to Google API's and don't fully understand how they work. I don't know what code to use or really how to modify it. WHAT I'VE TRIED: Google API obviously has the code for how to fetch the data to put into a page, so I've copied this, though I don't know if I put it in correctly/Dreamweaver says "There is a syntax error on line 32. Code hinting may not work until you fix this error". Additionally, I've read that perhaps Google Fusion Tables might be better because I can download it as a CSV version and then have that be what used in my actual script (though I don't fully understand how/if that would continually update itelf?): <html xmlns="http://www.w3.org/1999/xhtml"><head><title>Untitled Document</title><!--#include file="php-5.6.2.tar.bz2" --><?php include("php-5.6.2.tar.bz2"); ?><style type="text/css">#page {margin-left:auto;margin-right: auto;top: 15%;bottom: 15%;width: 1000px;}.menue {border-color:rgb(0,0,0);border-width:thick;height:300px;width: 300px;position: abosolute;margin-left: 10%;margin-right: 10%;}</style></head><body><div id="page"><div id="Skillet_Product_List_and_Price" class="menue"><?phpusing Google.GData.Client;using Google.GData.Spreadsheets;namespace MySpreadsheetIntegration{class Program{static void Main(string[] args){SpreadsheetsService service = new SpreadsheetsService("https://docs.google.com/a/emich.edu/spreadsheets/d/1OAFhMrayek9BKvO6ZI9EIPmCeY61oLL7-wfZOIg2xV8/edit#gid=724477237");// TODO: Authorize the service object for a specific user (see other sections)// Instantiate a SpreadsheetQuery object to retrieve spreadsheets.SpreadsheetQuery query = new SpreadsheetQuery();// Make a request to the API and get all spreadsheets.SpreadsheetFeed feed = service.Query(query);if (feed.Entries.Count == 0){// TODO: There were no spreadsheets, act accordingly.}// TODO: Choose a spreadsheet more intelligently based on your// app's needs.SpreadsheetEntry spreadsheet = (SpreadsheetEntry)feed.Entries[0];Console.WriteLine(spreadsheet.Title.Text);// Get the first worksheet of the first spreadsheet.// TODO: Choose a worksheet more intelligently based on your// app's needs.WorksheetFeed wsFeed = spreadsheet.Worksheets;WorksheetEntry worksheet = (WorksheetEntry)wsFeed.Entries[0];// Fetch the cell feed of the worksheet.CellQuery cellQuery = new CellQuery(worksheet.CellFeedLink);cellQuery.MinimumRow = 2;cellQuery.MinimumColumn = 1;cellQuery.MaximumColumn = 2;CellFeed cellFeed = service.Query(cellQuery);// Iterate through each cell, printing its value.foreach (CellEntry cell in cellFeed.Entries){// Print the cell's address in A1 notationConsole.WriteLine(cell.Title.Text);// Print the cell's address in R1C1 notationConsole.WriteLine(cell.Id.Uri.Content.Substring(cell.Id.Uri.Content.LastIndexOf("/") + 1));// Print the cell's formula or text valueConsole.WriteLine(cell.InputValue);// Print the cell's calculated value if the cell's value is numeric// Prints empty string if cell's value is not numericConsole.WriteLine(cell.NumericValue);// Print the cell's displayed value (useful if the cell has a formula)Console.WriteLine(cell.Value);}}}}?></div></div></body></html> But I've also tried this, which I was playing with : $file = "https://docs.google.com/a/emich.edu/spreadsheets/d/1OAFhMrayek9BKvO6ZI9EIPmCeY61oLL7-wfZOIg2xV8/edit#gid=724477237"$data = file_get_contents($file) or die('Could not read file!');echo $datafunction readRows() {var sheet = SpreadsheetApp.getActiveSheet(Eateries Menu Pricing.xlsx);var rows = sheet.getDataRange(A2:22);var numRows = rows.getNumRows(22);var values = rows.getValues();for (var i = 0; i <= numRows - 1; i++) {var row = values;Logger.log(row);}};var ss = SpreadsheetApp.getActiveSpreadsheet();var sheet = ss.getSheets()[0];// This represents ALL the datavar range = sheet.getDataRange();var values = range.getValues();//This logs the spreadsheet in CSV format with a trailing commafor (var i = 0; i < values.length; i++) {var row = "";for (var j = 0; j < values.length; j++) {if (values[j]) {row = row + values[j];}row = row + ",";}Logger.log(row);} And finally I've tried this just to try displaying a website thinking it'll work: <?php$myvar = "https://docs.google.com/a/emich.edu/spreadsheets/d/1O8-h-xmGE49K4x9sHrRL-c 97bHPXhma2eKkqrYAvog/edit#gid=1568863245";$var = fopen($myvar,"rb");echo stream_get_contents($var);?> DISCLAIMER: I understand that somewhat similar-ish questions have been asked before, but I am so new to PHP that I really need to be talked through this process. I've been looking everywhere online to try to understand this all, and I'm really trying to understand the process and how this all works
  2. In trying to make a "talkbubble" styled div- box change colors completely upon being clicked, I ran into a problem of getting the :before pseudo element that I'm using (to shape the arrow for the talkbubble) to actually change colors with the rest of the element. My script is http://jsfiddle.net/petiteco24601/3xuuq2fx/. When I couldn't get it to work, I did some research and it seems what/how to control pseudo-elements is a question that most web developers seem shaky about. For the most part, a lot of what I found was basically saying that there's no way to really force javascript on a pseudo element, since the pseudo element doesn't REALLY exist. However, with more research, I found things like http://css-tricks.com/pseudo-element-animationstransitions-bug-fixed-in-webkit/ andhttp://stackoverflow.com/questions/2610497/change-an-inputs-html5-placeholder-color-with-css/2610741#2610741 that say that those bugs were fixed and it is possible with some browsers to use javascript on pseudo elements. What's the actual deal? How extensively can a person control pseudo elements?
  3. Admittedly I'm fairly new to Javascript, but I've taken numerous tutorials, classes, and have searched for hour online and I can't seem to figure out how to make my script work, and have edited it and edited it so many times I just want to start over. What I'm trying to do is, when one of six divs is clicked, a separate div will have 3 specific divs appear in it. Each of the original six divs have three similar but different divs related to it. I have this much, but as I've said I've looked through so many tutorials that I just scrapped loads.http://jsfiddle.net/petiteco24601/hgo8eqdq/ $(document).ready(function () {$(".talkbubble").mouseout(function(){$(".sidebar").show();});$$(".talkbubble").click(function(){$ How do I make it so that when you click a "talkbubble" div, a different "sidebar" div appears with all its contained elements, and when you mouseout, the first talkbubble div automatically activates?
  • Create New...