Jump to content

Zane

Administrators
  • Posts

    4,362
  • Joined

  • Last visited

  • Days Won

    11

Everything posted by Zane

  1. I have been using Centos for the past few months and I really like it.
  2. I don't know about getting the money earned, but to get the sum, you just GROUP BY soldby and make sure you are using an aggregate function like SUM(*) in your SELECT statement
  3. Well the first step is to figure out how to output such data i.e the coordinates? If you already know how to retrieve them, then how do they look? To what kind of format do the coordinates output? I tried googling for it, but I gave up when I found a v3 demo http://nettique.free.fr/gmap/toolbar.html Still, the author does not allow you to grab the coordinates. Example answers could be JSON, CSV, etc... Posting the coordinates (actual or modified) would be more preferred though. EDIT Looking at your other thread, I see that you have the coordinates in an array http://forums.phpfreaks.com/topic/281402-google-maps-add-click-listener-to-each-polygon/ A quick and dirty way to store an array in a database is to serialize it and then base64_encode it, then insert it. Storing it this way will keep you from being able to query the database using geospatial algorithms in the select; doing so would allow you to perform unthought of queries like, list all cities within 100 miles of a certain polygon's specific coordinate.
  4. //Page load echo "Page loaded in "; echo microtime() . " ms "; //Perform stress on the server for($i=0; $i echo "Loop finished in "; echo microtime() . "ms"; ?>
  5. The only convenience and iPad will give you for web development testing is the fact that it has Safari on it. If you get a regular Android tablet, you have several options for browsers to use, including Safari. Then again, you can do the same with an iPad.. download chrome, firefox, whatever. The one thing that you will not get with an iPad is the ability to use Internet Explorer. IMO, and android tablet is the most economical choice as well as the most versatile. If you didn't know by now, Apple prides itself in proprietary software and hardware, so unless you plan to cater to Apple only visitors, go with the Samsung.
  6. Zane

    Newbie Q

    I suppose I shouldn't have been so aggressive in my response. There are a lot of people who ask the same types of questions every day, but yours grabbed my attention because you actually had a logical order of things you wanted to happen. If no budget means that you are excluding books on this subject then I would turn to Google. You have already been answered as far as what kind of web-based technologies can accomplish your described goal. IPN. IPN (Instant Payment Notification) would be the right direction. You can google those three letters alone and get more than enough helpful results, not to mention the very first one, that is not an advertisement, brings you directly to Paypals IPN information page. You're also seeking tutelage on that technology, so append tutorial to IPN. IPN is the only way you will achieve such things. As jcbones pointed out, Paypal allows you to have data sent to three different scripts (or pages as jcbones put it). There lies your answer. Then of course is the handicap of "complete newb." That is a tough handicap to deal with when it comes to answering your questions effectively or with any integrity whatsoever. My advice is to take those three letters and dive head first into tutorials on the matter. Hello World examples and a lot of copying a pasting will get you started. I suggest you read this so you can wrap you head more around the idea. http://www.geekality.net/2011/05/28/php-tutorial-paypal-instant-payment-notification-ipn/ I've never been called lofty until now. If that is the case, I didn't intend to come off as lofty. A small blue rectangle doesn't make me any different or special in any way. In my opinion it just expresses that I have been here for quite a while and have seen my fair share of questioning patterns all the while. Dig into all the IPN tutorials and examples you can find. Do not expect Paypal themselves to help you at all. It is not their job to do so and I doubt that any Paypal personnel that you do manage to communicate with will even know about development and logic. Paypal has their own personal IT team and they are not going to share it. P.S. Frontpage was also my weapon of choice back in the day. I was a table making maniac.
  7. Zane

    Newbie Q

    I remember doing that exact thing (listing out processes) before I ever learned PHP. I had just reached a firm enough grasp on HTML, but still relied on WYSIWYGs. What I am getting at is that even though you claim Just as an aside, I'm not a developer and... doesn't mean you cannot learn it. Visualizing the processes like you have done in your OP is a good indicator that you have an analytic and systematic mindset Nevertheless, you still admit to not knowing anything about PHP nor programming nor HTML but rather only Dreamweaver. Listing out a set of processes like that... ?? Imagine you were an engineer and someone randomly came to you because they noticed you were not busy and asked you "How would I construct a machine that wakes me up in the morning, brushes my teeth, wipes my ass, and drives me to work?" I'll be honest, it's hard to "be gentle" with you about such a question. If you're looking for a kick in the right direction then just say so. Don't be that person that uses someone as a paintbrush for their ideas and doesn't pay the person. My only answer to you is to either create a post in the Freelancing section or buy a decent book on PHP and follow along with it, asking questions along the way as you need to. I recommend any PHP book by Julie Meloni, but then again, that's only PHP book I ever had...if you don't count this community/forum
  8. Were you going for a time record when you wrote this question? I suggest you devote more time than just 30 seconds to describing your problem. Effective questions yield effective answers.
  9. Try GROUP BY Venue.VenueName WITH ROLLUP
  10. Hell yeah.. I'll take two Guiness right now... fo free'
  11. [ignorant response removed ] Nevermind, I read that wrong kicken has the answer. ^^^^
  12. The guru badge has found you, jazzman1. Welcome aboard.
  13. We welcome to the guru club, jcbones!
  14. You know, spacing is everything when you want people to pay attention. I have taken the time here to indent your mess and make it easier for someone to look at. EDIT: I searched using Google for Strict Standards: Declaration of should be compatible with and low and behold , this came up right away http://stackoverflow.com/a/3115398/401299
  15. I took the post away seeing as it did have nothing to do with anything. What strikes me as more odd than post #4's existence is the fact that you felt the need to quote it as if to reminisce its irrelevance??
  16. Congratulations to our newly promoted guru, mac_gyver! Welcome aboard
  17. $x + 1 I mean, d'oh
  18. w3schools is not the place to learn programming languages effectively. Try tutorials or books elsewhere. http://www.w3fools.com/
  19. $x++ is the same thing as $x = $x + $x
  20. Zane

    Alo!

    Bienvenidas, Esperamos que te disfrutes nuestra comunidad más contribuir ayudas, y aprender nuevas estrategías.
  21. elseif extends the beginning IF statement so that you can have more conditions... Otherwise, you would end up checking any and all conditions one by one which means that more than one can be true.. With an elseif chain.... only one will be true.
  22. I would put the image filenames into a multi-dimensional array <?php if($dirHandler = opendir($images_dir)){ while(false !== ($file = readdir($dirHandler))){ $files[] = $file; } } natcasesort($files); $images = array(); foreach($files as $myFile){ if($myFile == "." || $myFile == "..") continue; $name = explode(".", $myFile); $name[1] = strtolower($name[1]); if($name[1] == "jpg" || $name[1] == "jpeg"){ echo "<div class='thumb'><a href='" . $images_dir . "/" . $myFile . "'><img src='" . $images_dir."/thumb/" . $myFile . "'></a></div>\n"; //Grab year and place filename into multi-dim. list($y) = explode("-", $name[0]); $images[$y][] = $myFile; } } ?> Then loop through images foreach($images as $newDiv) { echo '<div>'; foreach($newDiv as $imgDiv) echo "<div><img src='{$imgDiv}' /></div>"; echo '</div>'; }
  23. I would concat all the relevant fields into one string and use LIKE to match... For instance searchTerm = "something cheap and awesome" SELECT itemID, itemName FROM items WHERE CONCAT('#', itemName, itemDesc, itemField, itemField2, itemField3) LIKE '%searchTerm%' it also wouldn't hurt to replace all your spaces and other non-alphanum charaacters with a percent sign %. Then replace duplicate % signs with one single % sign This way your query will look like this SELECT itemID, itemName FROM items WHERE CONCAT('#', itemName, itemDesc, itemField, itemField2, itemField3) LIKE '%something%cheap%and%awesome%' The biggest drawback is that the longer the searchTerm is, the harder it will be to find a perfect match. You may have to reorganize your CONCAT to have the most relevant fields appear first...
  24. It should just be $row['prod_price'], tablenames are not needed when accessing the result of fetch_array()
  25. put the article id number within the rewrite as well. In other words, RewriteRule /articles/(.*)_article_name /view.php?article_id=$1 [L] The rule of thumb is that unless you are searching for rows that are similar and alike, never search using a string. The purpose of indices is to keep an index. If you know the index number there is not point in searching by the name of the article. It would be like searching through a literal library for a book by its name and not its ISBN.
×
×
  • 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.