GregRickshaw
-
Posts
17 -
Joined
-
Last visited
Everything posted by GregRickshaw
-
Repeat a drop down list on each row of a HTML table
GregRickshaw replied to GregRickshaw's topic in PHP Coding Help
Yes I have been using that since your suggestion, it's truly amazing! Small things and all that! -
Repeat a drop down list on each row of a HTML table
GregRickshaw replied to GregRickshaw's topic in PHP Coding Help
Sorted. -
Repeat a drop down list on each row of a HTML table
GregRickshaw replied to GregRickshaw's topic in PHP Coding Help
Hi Danish @Danishhafeez Anyway I can get the refer button on the same line? I have followed your code now
-
Repeat a drop down list on each row of a HTML table
GregRickshaw replied to GregRickshaw's topic in PHP Coding Help
Thanks @Danishhafeez got there just as you posted your reply, but thank you so much! -
Repeat a drop down list on each row of a HTML table
GregRickshaw replied to GregRickshaw's topic in PHP Coding Help
Wow @Barand what an amazing script you have given me. I will certainly be using the code again. However I finally went with @dodgeitorelse3 solution of adding the foreach into the table (below). I knew it needed to be in there somewhere just couldn't figure it out. Thanks to all who replied it now works a treat. It's messy but it works I will look to refine it the way @Barand suggests as that seems way more controllable and repeatable. Thanks all Greg if($details) { foreach ($details as $detail) { echo "<td><left>" . $detail['fullname'] . "</td>"; echo "<td><left>" . $detail['connectionemail'] . "</td>"; echo "<td><left>" . $detail['skill'] . "</td>"; echo "<td><left>" . $detail['phonenumber'] . "</td>"; echo "<td><left>" . $detail['region'] . "</td>"; echo "<td><left>" . $detail['daysremaining'] . "</td>"; echo "<form action=LogReferal.php?email=referto>"; echo "<td><select name=referto id= referto>" ; foreach($agencies as $agencylist) { echo "<option><name=referto type=email>" . $agencylist['email'] . "</option>"; } echo "<input type=hidden name=referred value=$detail[connectionemail]>"; echo "<td><left><input type=submit value=refer></td></tr>"; } }
-
Repeat a drop down list on each row of a HTML table
GregRickshaw replied to GregRickshaw's topic in PHP Coding Help
Thanks guys for the recommendations. I agree with you both, it's my HTML which is too messy, I'll rebuild the table on your suggestions and see where I get. Many thanks for your guidance and advice. -
Hi all I want to display the same drop down list (selection) in every row of my table but I can't seem to work out how to do it, the drop down always seems to come at the end of the table and not on each row. The drop down list is a SQL query (a stored procedure) which is called. I managed to get the dropdown to appear in the correct place when it's just one row in a table. <?php $statement = db()->prepare("EXEC fe_uspAdminUserShowRegisteredAgencies"); $statement->execute(); $agencies= $statement->fetchAll(PDO::FETCH_ASSOC); ?> <p> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> </head> <body> <table> <thead> <tr bgcolor="#FFF8DC"></b> <th><center><i>inviter</th> <th><center><i>inviter email</th> <th><center><i>inviter contact</th> <th><center><i>inviter region</th> <th><center><i>inviter skill</th> <th>refer to</th> <th></th> </i> </center> </tr> </thead> <p> </p> <?php if($inviterdetails) { foreach ($inviterdetails as $inviterdetail) { echo "<tr bgcolor=#FFF8DC>"; echo "<td><center>" . $inviterdetail['fullname'] . "</td>"; echo "<td><center>" . $inviterdetail['inviteremail'] . "</td>"; echo "<td><center>" . $inviterdetail['invitercontact'] . "</td>"; echo "<td><center>" . $inviterdetail['inviterregion'] . "</td>"; echo "<td><center>" . $inviterdetail['inviterskill'] . "</td>"; echo "<form action=LogReferal.php?email=referto>"; // echo "<td><left><input type=email id=referto name=referto></td>"; echo "<input type=hidden name=referred value=$inviterdetail[inviteremail]>"; echo "<td><left><input type=submit value=refer></td>"; } } ?> <td><select name="referto" id ="referto"> <?php foreach($agencies as $agencylist) { echo "<option><name=referto type=email>" . $agencylist['email'] . "</option>"; } Produces the desired result However when I try to repeat the process in a separate table which has multiple rows, I get the selection drop down all over the place in this case at the end of the row and not applicable to any particular row. I have managed to get it everywhere except on the row it should be and it doesn't repeat and be relevant to the row. <?php //Connection details section.. $email = current_user(); $statement = db()->prepare("EXEC fe_uspConnectionDetails ?;"); $statement->bindParam(1, $email, PDO::PARAM_STR); $statement->execute(); $details = $statement->fetchAll(PDO::FETCH_ASSOC); ?> <p> <p> <table> <thead> <tr> <th><i>name</th> <th><i>email</th> <th><i>skill</th> <th><i>mobile</th> <th><i>region</th> <th><i>days</th> <th><i><center>refer to</center></th> </tr> </thead> <hr color="#c7c34c" size="4" width="50%"> <p><i>my connections (below)</i></p> <?php if($details) { foreach ($details as $detail) { echo "<td><left>" . $detail['fullname'] . "</td>"; echo "<td><left>" . $detail['connectionemail'] . "</td>"; echo "<td><left>" . $detail['skill'] . "</td>"; echo "<td><left>" . $detail['phonenumber'] . "</td>"; echo "<td><left>" . $detail['region'] . "</td>"; echo "<td><left>" . $detail['daysremaining'] . "</td>"; echo "<form action=LogReferal.php?email=referto>"; // echo "<td><left><input type=email id=referto name=referto></td>"; echo "<input type=hidden name=referred value=$detail[connectionemail]>"; echo "<td><left><input type=submit value=refer></td>"; // echo "<form action=LogReferal.php?email=referto>"; // // echo "<td><left><input type=email id=referto name=referto></td>"; // echo "<input type=hidden name=referred value=$inviterdetail[inviteremail]>"; // echo "<td><left><input type=submit value=refer></td></tr></form>"; } } ?> <td><select name="referto" id ="referto"> <?php foreach($agencies as $agencylist) { echo "<option><name=referto type=email>" . $agencylist['email'] . "</option>"; } ?> </td> I kind of realise the repeating code (for each) has to be somewhere in the main table and not outside the table but I have just got stuck... Any help greatly received Cheers Greg
-
The login code just does that I just built it into a function to call exactly as you said. function current_user() { if (is_user_logged_in()) { return $_SESSION['email']; } return null; } I went this route because I just couldn't work it out how to use the key. Ironically of course my noddy testing and coding took way longer than probably revisiting that properly. The db function is this? Is this not good way of doing things? function db(): PDO { static $pdo; if (!$pdo) { $pdo = new PDO( sprintf("sqlsrv:server=%s;Database=%s",DB_HOST, DB_NAME), DB_USER, DB_PASSWORD, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION] ); } return $pdo; } Thanks for all your help. Always learning, always looking for better ways. I'm a MSSQL/BI developer/data architect by day, so all of this is new to me
-
I will do thank you for the guidance. Thank you yes it's a bit messy I have a lot to learn particularly etiquette Will do, I'm trying my best to bumble along, I'm not looking to become a PHP developer when I get the POC complete I will be handing it over to the pros. Thanks again - take care
-
Brilliant I got it now works a treat, onwards and upwards Thank you again for your patience, time and effort. <?php $User = current_user(); $sql = 'SELECT fk_usertypes_id FROM users WHERE email=:User'; $statement = db()->prepare($sql); $parms = array('User'=>$User); if (!$statement->execute($parms)) { echo "Query did not run"; exit(); } while($row = $statement->fetch(PDO::FETCH_ASSOC)) { echo "UserType " . $row['fk_usertypes_id'] . '</br>'; if ($row['fk_usertypes_id'] ==1) { echo "Hello 1";} else { echo "Hello 2"; } } ?> <p><a href="index.php">Home</a></p> <?php view('footer') ?>
-
Ok that works very nicely. I don't need to echo the value out really, that was just for me to see what was going on. It works each time. Yes current_user() is a function and gets the email from the login page to know who I am dealing with. Yes the $bob makes now sense I've removed it now, again it was just my way of finding out what was going on. Which is why I was trying to test the value in the first place How would I then achieve a test of the value? Rather than showing it on screeen. So now I have the UserType being set correctly I wanted to do something like if UserType = 1 then do this (go to a page for instance) if UserType = 2 then do this (go to a different page for example) Many thanks for your time, effort and help.
-
Making no sense is correct, I am just dabbling around I'm not trying to do or be anything so apologies as I just don't really know I'm just finding my way. I have tried testing it as you say but it always the same. I have tried not used the fetchAll() it's always the same I only looped over the data because I was testing for more than one value but I can remove that. I will try the things you mention and come back to you. I have also tried in_array function still always ignores it.
-
print_r($bob); if ($bob==1) {echo "Hello 1";} else { echo "Hello 2"; } Made the change suggested, which did work when the user was type 2 but when the user is type 1 the output is always the else statement Hello 2 Thanks I will add those to my code will come in handy with errors. Great tip
-
Thanks again Barand. I was sure had tried that I actually had === in there for a while as I read that too. Anyway just doing == has fixed the problem however when the user is 1 it now goes automatically to 2 Anything to say if you are 1 echo 1 if you are 2 echo 2
-
Hi all I have value passed into an array using a SQL query which appears to work fine. The value I want is passed into $usertype However I then want to test the $usertype for the value in the array. I know the value is in position [0] in the array but specifying this seems to make no difference anyway The output from the code below is the screenshot It recognises I am User Type 2 ($bob) However if I test $bob which according to the array is 2 and correctly output as 2. The test always thinks bob is 1 Anyone got any help on how to test a value in an array? Code is below <?php $User = current_user(); $sql = 'SELECT fk_usertypes_id FROM users WHERE email=:User'; $statement = db()->prepare($sql); $statement->bindValue(':User', $User, PDO::PARAM_STR); $statement->execute(); $usertype = $statement->fetchAll(PDO::FETCH_ASSOC); if ($usertype) { foreach ($usertype as $bob) { echo '<left>' . "UserType " . $bob['fk_usertypes_id'] . '</br>'; } } print_r($bob); if ($bob=1) {echo "Hello 1";} else { echo "Hello 2"; } ?> <p><a href="index.php">Home</a></p> <?php view('footer') ?>
-
WOW works a treat thank you so much I don't think I would ever have done that. A lot to learn but it's every exciting and enjoyable.
-
Hi All Absolute newbie here, been using PHP for about three months, yes this is a homework project, yes there are a ton of mistakes, yes I may be open to SQL Injection but this is a total homework project on my laptop and destined never to go anywhere. I have written two custom functions to check a login via a html form. All works well but now I have decided I want to check what type of user is logging in to direct the users to a different page, eg: Standard user goes to one page Admin user to a different. So this code works just fine: Finds the users email and logs the user in with the correct email so I get a different user for each email. However, what I want to do now is pass the type of user FK_UserTypes_Id which will be a 1, 2 or 3 etc., I thought I would just be able to add a variable of usertype and the SQL would pull that value into my new variable I can then use this further down the coding However as soon as I introduced another parameter I get this error message: Fatal error: Uncaught ArgumentCountError: Too few arguments to function find_user_by_username(), 1 passed in C:\laragon\www\auth\src\auth.php on line 160 and exactly 2 expected in C:\laragon\www\auth\src\auth.php:1 I have run the SQL many times and the fk_User_Id does return for the email provided. I'm learning so I'll continue to delve and try stuff but this has had me more stumped than any problem in PHP I have encountered so far. Many thanks for looking G
