Jump to content

ICEcoffee

Members
  • Posts

    19
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

ICEcoffee's Achievements

Member

Member (2/5)

0

Reputation

  1. I've spent many hours building my project with Drupal, without digging in deep to the API. As I said I don't require massive CMS functionality, the standard Drupal blog and forum modules are lacking (common knowledge), I've uninstalled CCK and views modules because there were massive behemoths. I started with Drupal because I thought it would save me loads of man hours/coding, but some of the problems I have experienced.... I'm starting to question my initial decision.
  2. CORRECTION: should be: Drupal is know for horrendous amounts of db calls just to serve up even a SIMPLE page.
  3. @Anti-Moronic: thanks very much for the fullness of your reply. I was thinking the same. I don't need nor desire my fixed content pages to be served up by a database. Other data - fine, because they would be input from users ie submitting comments. Drupal is know for horrendous amounts of db calls just to serve up even a page. The most complicated thing on the site would be a simple e-commerce section which interfaces with PayPal IPN, and that I'm sure I can hook in with a class from PHPclasses. I thought it would be sensible to get some feedback from others, perhaps more experienced than myself, before making a a decision. Coding my own would mean I am very familiar with the code and there would be more satisfaction at the end result.
  4. Hi all I have run into several critical issues with Druapl. I have spent months (I'm a sole, inexperienced developer) working on a project for myself, but have been vexed at the following: white screen of death: result - my app just stops working, displaying only a white screen. This is a PHP memory issue (I'm on shared hosting - though with generous settings ie 128MB PHP_memory available). I also find I can't search for PHP code within nodes Drupal is slow as a dog - the built in caching helps. Now, I have toyed with the idea of coding my own app. I have limited knowledge in PHP, HTML, CSS etc though I have been developing for over five years. I thought of doing my own site from scratch, as I don't really need a full on CMS/community app. I mainly need to serve pages (probably includes), with minimal MySQL for user / authentication. I don't mind starting off with less functionality and thought that I could simply 'bolt-on' classes/functions from scripting sites, till I get up and running. Can I please have your opinion. I know I've given limited background info, but can supply more if required. I just want to see if I'm being arrogant and stupid.
  5. Hi, I am in the early stages of developing a web app in PHP/MySQL. It is predominantly procedural (with type of MVC approach)in coding style though I do have some classes included(). ATM, I have my navigation links going straight to a bare-bones file that sets up variables for that page, such as: $pageAuthLevel, $metaPageTitle, $metaPageContent, $metaPageKeywords. Also defined in this page is the include paths for the actual html content file, the pages controller and lastly the pages view. I know I could include all this data in a MySQL db table and the include files from within the controller. The advantage of doing it the way I have it currently, is that the links are already written in an SEO friendly manner eg: /about-this-site.php and saves me from having to learn and setup mod_rewite in an .htaccess file. The disadvantage is that I have an additional file for every 'content' file, but the filesize is small and disk space is cheap. My question is though, which method is more efficient in terms of performance, scalability and security?
  6. Hi Orio Thanks for that, it is only one table in fact AND yes, all the data in the fields are surrounded by quotation marks, ie "this is data". I will try and adapt what you have kindly written. Thanks
  7. Hi all I have imported a table from an ODBC database into MySQL, but all the data in all the columns are surrounded by quotation marks. Can anyone tell me how to write a query I can execute, to update all fields, to delete said quotation marks. Thanks for any help, it will save me hours of work.
  8. Hi all I have imported a table from an ODBC database into MySQL, but all the data in all the columns are surounded by quotation marks. Can anyone tell me how to write a query I can execute, to update all fields, to delete said quotation marks. Thanks for any help, it will save me hours of work.
  9. Thanks mainewoods, that looks like what I need, I will give it a go.
  10. Hi all I have a table of 2 cols, 1 for names and 1 for points. I currently have a select that fetches all rows and sorts them in descending order of points. I want to colour code on screen, each row depending on its position to the 1st row eg row1 = red if row number is between 0 & 30% of max rows then yelllow if row number is between 31 & 60% of max rows then orange.... You get the idea. I just dont know the best way to get the row number of the returned data. Any help would be greatful, I'm stuck.
  11. Hi all I am learning PHP slowly (all the code below is handwritten by me, cool eh?), but I can't work out why my leaderboard table is not being updated properly. I am trying to match driver names from the race results from table "t_qualy_results", with driver names in a users team tables "ff1_teams" and update previously created rows within the leaderboard table "ff1_leaderboard". I think it is the actual update statment for updating the leaderboard table that is wrong, but it may also be the logical stucture is wrong too. Please help, It's driving me nuts. Cheers [code]             <?php                 // insert rows into Leaderboard table                 //                 echo "race variables";                 mysql_select_db($database_FF1, $FF1);                 $raceq = ('SELECT RaceID FROM races WHERE CurrentRace = 1');                 $raceresult = mysql_query($raceq) or die(mysql_error());                 $row = mysql_fetch_array($raceresult);                                 $rownum = mysql_numrows($raceresult);                 //                 $ff1q = ('SELECT TeamName, id FROM ff1_teams WHERE Active = 1') or die(mysql_error());                 $ff1qresult = mysql_query($ff1q) or die(mysql_error());;                 while($teamrow = mysql_fetch_array( $ff1qresult )) {                     $leaderq = "INSERT INTO ff1_leaderboard (RaceID, TeamID, TeamName) VALUES ('$row[RaceID]', '$teamrow[id]', '$teamrow[TeamName]')";                     mysql_query($leaderq) or die(mysql_error());                 }                 //                 // Update Leaderboard with Qualifier results                 //                                  echo "raceID = ", $row['RaceID'];                                              // now look through qualy points                                                   $qualyq = ("SELECT * FROM t_qualy_results WHERE t_qualy_results.RaceID = '".$row['RaceID']."'") or die(mysql_error());                 $qualyr = mysql_query($qualyq) or die(mysql_error());                                  while($qualyrow = mysql_fetch_array($qualyr)) {                                               $ff1q = ('SELECT * FROM ff1_teams WHERE ff1_teams.Active = 1')or die(mysql_error());                         $ff1r = mysql_query($ff1q) or die(mysql_error());                                                       while($ff1row = mysql_fetch_array($ff1r)){                                  echo " - inner loop ", $iloop;                                 if ($qualyrow['Driver'] == $ff1row['Driver1']){                                                                          $query = "UPDATE ff1_leaderboard WHERE ff1_leaderboard.RaceID = ".$row['RaceID']." AND  ff1_leaderboard.TeamID =  ". teamrow['TeamID']." SET Driver1= '$qualyrow[Driver]'" or die(mysql_error());                                     $result = mysql_query($query) or die(mysql_error());                                                                      }                                                              }                                      }             ?>[/code] [b]EDIT BY OBER: PLEASE USE CODE TAGS WHEN POSTING CODE[/b]
  12. Thanks Guru, it worked - but can you tell my why your code worked and mine didn't
  13. Hi all I am having a problem with the following statement - ie it doesn't work. $qualyq = ('SELECT * FROM t_qualy_results WHERE t_qualy_results.RaceID = "$row[RaceID]"') or die(mysql_error()); $qualyr = mysql_query($qualyq) or die(mysql_error()); echo "<br> Driver and Points <br>"; while($qualyrow = mysql_fetch_array($qualyr)) { echo $qualyrow['Driver']; } If I substitute "$row[RaceID]" for the number 1, I get expected results, which also veryfies faild names and data are all intact, so I think it has something to do with the accepting of the variable, which I test with an echo statement a few lines before this one and it returns the value of 1, as expected. Any ideas? it's driving me nuts. Cheers
  14. Hi all I can't get this INSERT command to work using a variable? I want to take the value from querying 1 table and INSERT that data into another table. <?php echo "race variables"; mysql_select_db($database_FF1, $FF1); $raceq = ('SELECT RaceID FROM races WHERE CurrentRace = 1'); $raceresult = mysql_query($raceq) or die(mysql_error()); $row = mysql_fetch_array($raceresult); // mysql_select_db($database_FF1, $FF1); $leaderq = "INSERT INTO ff1_leaderboard (RaceID, TeamID) VALUES ($row['RaceID'],'9')"; mysql_query($leaderq) or die(mysql_error()); ?> Thanks for any help
  15. Hi all I am using dreamweaver 8 to build an Fantasy Formula 1, data driven website, but this is not a dreamweaver specific question. I have data that has been entered into various tables depending on results of a race, and want to update a leaderboard table with the results. I have a users team table, which includes fields for: user team name, driver1, driver2, chassis etc What I want to do is create a page, so that the end of the race, when data has been entered into the various tabes: qualify_results, Race_results, retirment_results etc to check the entered data and if a user a chosen has chosen a driver that has been awarded points, those points are entered into a new row in the leaderboard table, with any other points/penalties as appropriate. Is anyone clever enough to guide me through the PHP logic? I am a newbie (still) and any help would be appreciated. Thanks
×
×
  • 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.