Jump to content

nathansizemore

Members
 View Profile  See their activity

  • Posts

    16

  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

nathansizemore's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. nathansizemore
    Solved. Via @bažmegakapa from StackOverflow:
  2. nathansizemore
    Hello! I am trying to find a way to assign the JSON value Google Map's API Returns when passed an address. I would search Google, but I am only a few month deep into PHP and really don't know what keywords to use. I really don't even know what a JSON is? Anyway, I found this article that explains how to query Google Maps with an address and have it return a GPS Location. When I tested it in my browser, the text appears. I just don't know what to use to take what the browser is displaying and assign in to an Object in a PHP page. This is the Google Maps Query: http://maps.google.com/maps/geo?q="ADDRESS"&output=csv&oe=utf8 This my function where I want to use this: //Querries Google Map's API with an address and assigns the returned GPS Location //to this Object public function build_me($this_address) { //Builds the query from the address array to send to the Goole Maps API $query = $this_address["Line1"].",".$this_address["Line2"].",". $this_address["City"].",".$this_address["State"].",".$this_address["Zip"]; //Location_Array = http://maps.google.com/maps/geo?q=$query&output=csv&oe=utf8 $this->latitude = //Location_Array['Something']; $this->longitude = //Location_Array['Something']; } This is the article that I am referring to: http://martinsikora.com/how-to-get-gps-coordinates-from-an-address My question is, how would I go about doing this? Are there any good tutorials on this? Thanks in advance for anyone pointing me in the right direction!
  3. nathansizemore
    Thanks for the reply! There doesn't seem to be too much documentation of structuring your MongoDB connections out there. I see a lot of different ways, but no real 'Structure' of how it should be done. I ended up making a connection and a pointer to their collection in the __construct() function. That way, when I create a Host, or Event, they have their own connection directly to their Collection as opposed to opening them up through the code that uses the Objects. I did also create functions that utilize the adding of new Objects in my class that use the insert() function, simply for the fact that I need that assign their MongoID back as another variable and re-save after the insert() function creates an ID for them. Kinda sucks do to double entry, but I only have to do it on new User registration and then the relationship between Hosts and Events is set forever for later recalling. I made my Host and Events separate Objects, because a Host can have seven Events, and each Event has two array variables within it. Embedding each Event within the Host would be Hell with all the nesting of arrays. Also, on the user end, they will be searching for Events instead of Hosts so each Event needs a different ID. Thanks for the reference to the articles/blogs. Helpful!
  4. nathansizemore
    I am trying to get pics uploaded and stored into my database. Problem is, I am not that great with HTML and have just been Copy/Pasting tags to get forms I like and editing where I think things should go. I am pretty sure it has something to do with the html tags I am using, because by itself it works fine, but when I Copy/Paste that code to where, I think, it should be on my registration form, the if statement that checks for type and size regulations always returns false. It must have something to do with the form/post/submit button combo being pasted into, the working, registration form page. This is my working upload test code <html> <body> <form method = "post" enctype = "multipart/form-data"> <label for = "file">Filename:</label> <input type = "file" name = "file" id = "file" /> <input type = "submit" name = "Submit" value ="Submit"> </form> <?php if (!empty($_FILES['file'])) { if ((( $_FILES["file"]["type"] == "image/gif") || ($_FILES["file"]["type"] == "image/jpeg") || ($_FILES["file"]["type"] == "image/pjpeg")) && ($_FILES["file"]["size"] < 5000000)) { if ($_FILES["file"]["error"] > 0) { header("Location: http://www.drink-social.com/error.php?upload=".$_FILES["file"]["error"]); exit(); } else if (file_exists("/var/www/pics/".$_FILES["file"]["name"])) { header("Location: http://www.drink-social.com/error.php?upload=exists"); exit(); } move_uploaded_file($_FILES["file"]["tmp_name"], "/var/www/pics/".$_FILES["file"]["name"]); } } ?> </body> </html> Now, this is what my registration page, after I Copy/Paste the sections together, looks like: <html> <body> Please enter your details below: <br /> <form name = "Details" method = "post"> <br /> Username: <input type = "text" name = "Username"> <br /> Password: <input type = "text" name = "Password"> <br /> Name: <input type = "text" name = "Name"> <br /> Address: <input type = "text" name = "Line1"> <br /> Line 2: <input type = "text" name = "Line2"> <br /> City: <input type = "text" name = "City"> <br /> State: <input type = "text" name = "State"> <br /> Zip: <input type = "text" name = "Zip"> <br /> Now let's get those daily deals... <br /> Monday: <input type = "text" name = "Monday"> <br /> Tuesday: <input type = "text" name = "Tuesday"> <br /> Wednesday: <input type = "text" name = "Wednesday"> <br /> Thursday: <input type = "text" name = "Thursday"> <br /> Friday: <input type = "text" name = "Friday"> <br /> Saturday: <input type = "text" name = "Saturday"> <br /> Sunday: <input type = "text" name = "Sunday"> <br /> <form method = "post" enctype = "multipart/form-data"> <label for = "file">Filename:</label> <input type = "file" name = "file" id = "file" /> <input type = "submit" name = "Submit" value ="Submit"> </form> <?php include_once("host_class.php"); include_once("event_class.php"); if (!empty($_POST['Username'])) { $host = new Host(); $event = new Event(); if ($host->i_exist($_POST['Username'])) { header("Location: http://www.drink-social.com/error.php?login=duplicate"); exit(); } else if ((( $_FILES["file"]["type"] == "image/gif") || ($_FILES["file"]["type"] == "image/jpeg") || ($_FILES["file"]["type"] == "image/pjpeg")) && ($_FILES["file"]["size"] < 5000000)) { if ($_FILES["file"]["error"] > 0) { header("Location: http://www.drink-social.com/error.php?upload=".$_FILES["file"]["error"]); exit(); } else if (file_exists("/var/www/pics/".$_FILES["file"]["name"])) { header("Location: http://www.drink-social.com/error.php?upload=exists"); exit(); } move_uploaded_file($_FILES["file"]["tmp_name"], "/var/www/pics/".$_FILES["file"]["name"]); $host->set_username($_POST['Username']); $host->set_password($_POST['Password']); $host->set_name($_POST['Name']); $host->set_address($_POST['Line1'], $_POST['Line2'], $_POST['City'], $_POST['State'], $_POST['Zip']); $host->set_pic($_FILES['file']['name']); $id = new MongoID($host->add_me()); $host->build_me($id); $host->set_mondayID($event->add_me($_POST['Monday'], $host->get_id())); $host->set_tuesdayID($event->add_me($_POST['Tuesday'], $host->get_id())); $host->set_wednesdayID($event->add_me($_POST['Wednesday'], $host->get_id())); $host->set_thursdayID($event->add_me($_POST['Thursday'], $host->get_id())); $host->set_fridayID($event->add_me($_POST['Friday'], $host->get_id())); $host->set_saturdayID($event->add_me($_POST['Saturday'], $host->get_id())); $host->set_sundayID($event->add_me($_POST['Sunday'], $host->get_id())); $host->update_me(); header("Location: http://www.drink-social.com/member.php?ID=".$id); exit(); } else { header("Location: http://www.drink-social.com/error?upload=empty"); exit(); } } ?> </body> </html> It gets past checking to see if post is empty, but when it gets to see if there is a file, it returns false and brings me to my error page and says there was no file selected...? I am clueless, please advise Thanks in advance, and sorry so long!
  5. nathansizemore
    Found it. I didn't have the code below wrapped in an else statement, so it directed to that page, but then continued to execute to another page.
  6. nathansizemore
    Doh! Aside from that slip-up, any idea why it isn't working in the current state of simply, return true;?
  7. nathansizemore
    Returns an object.
  8. nathansizemore
    Hello, I am trying to implement error proofing to a log in script. But, I cannot get it to work? I have no idea what is going on, or why it doesn't work like I expect it to. I have tried everything, please advise. This is the method I am calling: public function i_exist($this_username) { //$host_array = null; //$host_array = $this->collection->findOne(array("Username" => $this_username)); //if ($host_array['Username'] = $this_username) //{ return true; //} //return false; } This is where I am calling it: if (!empty($_POST['Username'])) { $host = new Host(); $event = new Event(); if ($host->i_exist($_POST['Username'])) { header("Location: http://www.drink-social.com/error.php?login=duplicate"); } It is supposed to check the database and see if that username is already in use. But it never directs to the error page? I have even tried commenting everything out and returning true, and returning 1. Nothing? Any advice?
  9. nathansizemore
    Hello all! I have a couple questions regarding designing a backend with PHP and Mongo. How should I handle connections and database edits/queries/etc...? I see three possible options: Should I make a database and collection pointer a variable for each Object? Or Should I make those when certain functions are called by the Object? Or Should I keep all database pointers separate from my class structure? I have two main Objects: a Host and an Event. A Host is basically, a member. An Event is created and owned by the Host. I need the Host to be able to Login and add/edit their Events.
  10. nathansizemore
    Thanks for the response. I will play around with that and see what I can get going.
  11. nathansizemore
    Hello all! I cannot seem to figure out a way to pass an object from one page to another. Now, my flow may be way off, and if it is, please do advise. I want to have a form for username/password log in. When the submit button is hit, it takes those values, finds the matching user in the database, and returns the user object. We'll call him user_object Now, I want to bring up another page, that allows user_object to enter in additional information (Event details). After it does this, it writes those Event Objects into the database. My problem is: I need the ID Object attached to user_object while inserting the Event Objects into the database. The user_object and Event Objects values are assigned from two separate forms and two separate submit buttons. How do I pass this information? I don't want to use session because I have a lot of objects and do not want to serialize and unserialize all the time. I also read that $_GET is a security risk. Thanks in advance for any help! This is the basic logic of the code I am trying: <html form whatevs post> <php object_one if (creds_match) { build_object from db } else "Wrong info, dude" ?></endhtml stuffs> <html form whatevs post> <php object_two if (post!empty) { object_two = poststuff } assign object_two object_one's _id insert object_two into db ?></endhtml stuff> How do I keep the values assigned in section one, and send them or be able to use that same variable in section 2?
  12. nathansizemore
    Wow. That is ridiculous . Thanks man.
  13. nathansizemore
    Hello, all! I am trying to learn PHP and MySQL on my own, and need some debugging help. What exactly is going wrong here? I am following a tutorial and trying to write the code as it says, but am still having trouble with syntax. Running a WAMP, PHP5.3, and MySQL5.5. This is my code: <html> <body> <form name = "newVenue" method = "post"> Establishment name: <input type = "text" name = "name"> <br> Street Address: <input type = "text" name = "streetAddress"> <br> City: <input type = "text" name = "city"> <br> State: <select name="state"> <option value="AL">AL</option> <option value="AK">AK</option> <option value="AZ">AZ</option> <option value="AR">AR</option> <option value="CA">CA</option> <option value="CO">CO</option> <option value="CT">CT</option> <option value="DE">DE</option> <option value="DC">DC</option> <option value="FL">FL</option> <option value="GA">GA</option> <option value="HI">HI</option> <option value="ID">ID</option> <option value="IL">IL</option> <option value="IN">IN</option> <option value="IA">IA</option> <option value="KS">KS</option> <option value="KY">KY</option> <option value="LA">LA</option> <option value="ME">ME</option> <option value="MD">MD</option> <option value="MA">MA</option> <option value="MI">MI</option> <option value="MN">MN</option> <option value="MS">MS</option> <option value="MO">MO</option> <option value="MT">MT</option> <option value="NE">NE</option> <option value="NV">NV</option> <option value="NH">NH</option> <option value="NJ">NJ</option> <option value="NM">NM</option> <option value="NY">NY</option> <option value="NC">NC</option> <option value="ND">ND</option> <option value="OH">OH</option> <option value="OK">OK</option> <option value="OR">OR</option> <option value="PA">PA</option> <option value="RI">RI</option> <option value="SC">SC</option> <option value="SD">SD</option> <option value="TN">TN</option> <option value="TX">TX</option> <option value="UT">UT</option> <option value="VT">VT</option> <option value="VA">VA</option> <option value="WA">WA</option> <option value="WV">WV</option> <option value="WI">WI</option> <option value="WY">WY</option> </select> <br> Zip: <input type = "text" name = "zip"> <br> email: <input type = "text" name = "email"> <br> password: <input type = "text" name = "password"> <br> <input type="submit" name="Submit" value="Submit"> </form> <?php //If the form isn't empty, assign the value to a variable if (!empty($_POST['name'])) { $name = $_POST['name']; $address = $_POST['streetAddress']; $city = $_POST['city']; $state = $_POST['state']; $zip = $_POST['zip']; $email = $_POST['email']; $password = $_POST['password']; //Connect to the 'Users' database and store the new bar into the 'Venue' table... mysql_connect ("localhost", "newbar", "Jpr5HJ2K5fWvPLXq") or die ('Oh, fuck: '.mysql_error()); mysql_select_db ("users"); $query = "INSTERT INTO venues VALUES ('NULL', 'testPic.jpg', '".$name."', '".$address."', '".$city."', '".$state."', '".$zip."', '".$email."', '".$password."', 0)"; mysql_query($query) or die ('Oh, fuck: '.mysql_error()); echo "Damn, Nathan. This shit actually worked..."; } ?> </body> </html> This is the error I receive: Oh, fuck: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSTERT INTO venues VALUES ('NULL', 'testPic.jpg', 'Nathan's house', '666', 'DAY' at line 1 This is my table: id INT PRIMARY KEY pic_location VARCHAR name VARCHAR address VARCHAR city VARCHAR state VARCHAR zip VARCHAR email VARCHAR password VARCHAR event_name INT Any thoughts as to what is causing this error? Thanks in advance...
  14. nathansizemore
    Also, does name = Just create a pointer?
  15. nathansizemore
    Thanks for all the help guys! Few questions... If I wanted to accept the value written into the fields into an array, would I do something like this: Establishment name: <input type = "text" name = "details[]"> <br> Street Address: <input type = "text" name = "details[]"> <br> City: <input type = "text" name = "details[]"> <br> State: <input type = "text" name = "[details[]"> <br> To display it, I would like to make it a loop... $x = 0; while ($x < $details.endofarray()) { print $details[$x]; echo "<br/>"; $x++; } What exactly do I need in the name = field to be able to call that value with a variable key? Also, is there an 'End of Array' function in PHP?
×
×
  • 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.