CTphpnwb's Profile User Rating: *****

Reputation: 2911 Guru
Group:
Mentors
Active Posts:
10,086 (4.58 per day)
Joined:
08-August 08
Profile Views:
58,758
Last Active:
User is offline Today, 07:18 PM
Currently:
Offline

Previous Fields

Country:
US
OS Preference:
Mac
Favorite Browser:
Safari
Favorite Processor:
Who Cares
Favorite Gaming Platform:
Who Cares
Your Car:
Toyota
Dream Kudos:
350
Expert In:
PHP

Latest Visitors

Icon   CTphpnwb has not set their status

Posts I've Made

  1. In Topic: Combining Select and Update

    Posted 20 Aug 2014

    I was going to offer some suggestions and then I saw that your class uses deprecated mysql functions.
  2. In Topic: help with php and mysql databases with mysqli

    Posted 20 Aug 2014

    Why the single quotes?

    And why are you binding 7 values to 6 fields?
  3. In Topic: help with php and mysql databases with mysqli

    Posted 20 Aug 2014

    See the first single quote here? 's Markets Inc, San Mateo, CA 94401, USA', That was entered by the user and got treated as if it were part of the query. It's a perfect demonstration of why you NEED TO USE PREPARED STATEMENTS.
  4. In Topic: Combining Select and Update

    Posted 20 Aug 2014

    There are many other ways you could write this. You might look up MVC, for example, or you could separate your languages to make the each more readable and easier to debug. You could do both!

    Either way would make it easier to write one php file that only updates the desired link based on the data it receives.
  5. In Topic: help with php and mysql databases with mysqli

    Posted 19 Aug 2014

    //MySqli Insert Query
    $fsql = $con->query("INSERT INTO markers (name, address, lat,lng , type, city) VALUES('$bizname', '$formadd', '$lat', '$lng', '$type' ,'$mycity')");
    
    

    If you manage to get that to work then the next problem you're likely to be posting about is how to get your data back after having your site hacked. Read about and use prepared statements.

My Information

Member Title:
D.I.C Lover
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:
Interests:
Looking for php programming work.
Years Programming:
34
Programming Languages:
Experience is important, yet at the same time it's over-rated.

Contact Information

E-mail:
Click here to e-mail me
Website URL:
Website URL  http://

Comments

Page 1 of 1
  1. Photo

    CTphpnwb Icon

    31 Mar 2010 - 18:50
    Please post programming questions in the appropriate forums.
Page 1 of 1