Jump to content

phppup

Members
  • Posts

    741
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by phppup

  1. 21 minutes ago, Psycho said:

    And, if you like your code, why are you asking?

     

    21 minutes ago, Psycho said:

    But, it is the right way to do it

    Thanks for the explanation.

    And that's why I asked. Just because I "like" my code doesn't mean it's doing everything that it should be doing as effectively as it could be doing it. And I want to learn and stride to do it the right way.

     

    Aside from instances with a unique parameter,should I be doing this (try & catch) regularly with all my INSERT statements?

    It would probably reduce the amount of code and PHP checks (ie: input length) while putting a heavier burden on the SQL database. Is that advisable? Preferable?

    Learned allot. Thanks again everyone.

  2. 16 minutes ago, mac_gyver said:

    the initial SELECT query, which can tell your code the wrong answer.

    So, if I'm comprehending this correctly, it not do much about determining whether the unique element is available (which the SELECT will accomplish) but MORE about determining whether the value is INSERTable (which is defined in absolute terms by the field being unique).

    • Like 1
  3. Thanks for the input from everyone.

    I'm trying to digest all the info, but I'm still a bit uncertain as to why this is better than my code that checks (and prevents) the acceptance of a name that already exists.

    Isn't something like

    $sql="SELECT username from table where username = $username";
    if($result = mysqli_query($link, $sql)){
        if(mysqli_num_rows($result) > 0){
            //BINGO! it already exists               //take appropriate action
         } else {
    //proceed with the insert 
      }
            

    doing the same thing?

  4. Finally found success after my last debacle.

    Now it's time to INSERT my data into a table.

    My data is $firstname, $lastname, $username

    Since the $username is UNIQUE, it seems advisable to use a try & catch statement.

    How do I isolate the $username to do this effectively?
    How is this method better than using IF statements?

  5. I have

    function xyz($var0, $var1, $var2)

    and I want to see their values visually. I want to generate  FOR-style statement to automate this process.

    Did creating a function with elements assigned inadvertently create an array?

  6. I have variables as such

    $var0 = "hello";
    $var1 = "good bye";
    $var2 = "back soon";

    I get appropriate results when I do this

    echo $var0;  echo $var1;  echo $var2;

    Now, I want to get the r same esults using a created string like this

    for($x=0; $x <3; $x++){
      $test = "\$var".$x; echo $test."<br>";
      }

    But this only provides

    $var0
    $var1
    $var2

    How can I generate the respective variable elements so that they reflect their values?

  7. I would choose my query based on a careful evaluation of the data held in the database.

    If all addresses have an accurate city and zip code and your user is searching for a nearby business you may want to prioritize the zip code search since some cities use more than one zip code to cover the geography.

    You then need to know the boundaries. If a large city has six zip codes, are they set up like a 2 column grid where, 1 and 4 are at the top of each column, or in a circle with 1 in the center?

    The USPS may not be as logical as you desire but if the user is in a specific zip code and there's a match with a business in the same zip code: BINGO.

    Otherwise, a citywide result that lets the user determine where he wants to visit may be the best route.

  8. @kicken 

    Quote

    If in the future you need to add something to doStuff that needs access to colZ, you won't have to go around your application updating all the function calls to include colZ.

    The future is NOW (because that was one of my thoughts initially)

    My data is being pulled from $my_array which is outside of the function (as opposed to inside a db).

    So what would be the correct way of addressing the function (as per your last example)?

    Ideally, I would re-populate the array with any amount of values and still be able to use the same function without having to re-work the structure.

  9. I would appreciate some clarification (as I've actually never used arguments this way in functions).

    Experimentation seems to have revealed that this portion of the code needs to include all the related variables.

    function choose($x, $z)

    And that this

    choose($x, $z);

    to call the function must match identically.

     

    However, we have taken the argument a step further, and some clarity would be helpful.

     

    In this example we are assigning the variables in the call, but the function arguments are ALL the sought results?

    Similar to giving an alias tho the variable???

  10. @Barand per reply #1 ... You'll be happy to know that I know that's a mess.  But as you realized, it was meant to demonstrate what I was trying to accomplish.

    As for reply #2, I will have to try it in my script, but I see that it should both solve the issue by calling the function differently in each case AND removed the use of forewarned globals.

    (Somewhat of a tragedy really since I already made the list. LOL  But then, better code is best!)

    Out of curiosity, of I were to attempt to group the clusters as globals, is it possible?

    Again, I see the wisdom and (assumed) success in your method, but an still curious.

    Thanks for the help.

     

     

  11. I have reduced a process to function with a minimal list of global variables that are required.

    For simplicity, I'll offer this:

    If form1 is submitted, then global $a is necessary

    If form2 is submitted, then global $x and global $z are necessary.

    Rather than "register" all three, I wanted to use an IF statement to point to the specific globals necessary for the specified form input.

    My attempts are unsuccessful.

    $a = 123;
    $x = "hello";
    $z = "there";
    
    function choose(){
    global $formSelector;
    
    if($formSelector == "form1") {
    global $a; 
    } else {
    global $x; global $z;
    }
    
    //Test for result
    echo $z;
    if ($a == 123){
    echo "bye bye";
    }
    echo "test result";
    }
    
    //Call function
    choose();

    Can I segregate the globals or is a single comprehensive list the only solution?

  12. I am trying to establish an array that will be the levels deep.

    I want to access all data, but for some reason arrays keep moving to position 1 or more.

    I want to be able to establish a value at [0], at [0][0], and also [0][0][0]

    Shouldn't those be the first values at each level?

    How do I set this up?

  13. I'm trying to build an array as follows:

    Level 1

    Level 2

    Level 3

    Examples seem to be showing similar implementation to this

    $myArr = array( 'level 1',
              array('level 2' ),
        array(
        array( 5, 6 ),
        array( 7, 8 )
      )
    );

    But this seems to move the data one section deeper than necessary.

    In other words, there is nothing at position [0][0] or [0][0][0] (except Array which pushes me down another level).

    Shouldn't my access to the first item on level 1 be $myArr[0]?

    How can I get this lined up accordingly?

     

  14. @requinix Am I understanding it  "conceptually"?

    Explanation to develop my understanding or referenced tutorial, please?

    (I've kind of got the problem solved after removing the FUNCTION() method, but would prefer to achieve my results more systemically.

  15. @Barand Then it appears that I was on the right track (sort of nesting the functions) which then actually makes the "outter" function a parent of the function within it.  Is that making sense? Correct?

    (And eliminating the problem of passing values?)

  16. In somewhat of a continuation of the previous issue:

    function first() {
    //do stuff and result $A
         }
    
    
    function two($externalArray) {
    //do stuff to $A when applicable and result $B
         }

    I have an external array that I have been able to access WITHOUT using the GLOBAL feature, but now I am having a problem passing values.


  17. I want to use elements from an array within a function.

    I had some success using global $array

    But then I read that using GLOBAL should be avoided (the explanation of why was not very clear)
    And that the same result could be achieved by attaching the array to a function (not sure how to do that)

    I was then thinking of creating an array of global variables. Is this even possible?

    What is the best way to access an array outside of a function so that its elements can be useful?

  18. @kicken Sounds reasonable.

    I was planning to have a single submittal for an individual's top 3 flavors so that I can get a broader result of flavors that are most popular, so I guess I'll need 3 more columns that I'll need to merge.

    Obviously I'll create a safeguard so that no flavor can be submitted more than once when the entire form is submitted. All flavor choices must be unique.

    @maxxd That was kinda the reason for my post. Too determine if there's a "preferred" method or more advisable choice.

    I guess it kinda comes down to personal preference.

    Maybe I'll just see who else votes and use this thread as my template. LOL

    Life imitating art.

    And meanwhile, I'll just have a bowl of vanilla caramel swirl.

  19. I want to get the results after asking 100 people to select their 3 favorite flavors of ice cream.

    As I conceptualize the methodology, I can see I'd want an array of flavors to generate a group of checkboxes or a drop-down to avoid the conflict of misspellings.

    But from the database perspective, what would be the Best Practice to implement?

    Do I want a column for every flavor that receives an X when that row is submitted? Or do I want to input a 1 and then somehow total all columns whereby a descending list would run from most favorite to least?

    Would a single column for flavor_01, flavor_02, flavor_03 be advisable? Then assess the votes for each flavor on each column and combine VANILLA from 01 and 02 and 03 etc?

    (This might offer an opportunity to see how many people choose fudge swirl as their SECOND FAVORITE selection separate from the mass of voting, but this is probably not a relevant indicator)

    Guidance, please.

     

×
×
  • 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.