wix100

Hi Guys - me again (sorry) So, now have the code of: <?php session_start(); ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); if(isset($_GET['ID'])){ //Connect to the database $mysqli = new mysqli("localhost", "jj3wg2td_wix", "BLAH BLAH", "BLAH BLAH"); $ID=mysqli_real_escape_string($mysqli, $_GET['ID']); $sql="SELECT * FROM uni2020 WHERE UniversityCourses='$ID'"; $result=mysqli_query($mysqli,$sql) or die ("Bad Query: $sql"); if($result->num_rows > 0); if(isset($_GET['ID'])){ $Website=mysqli_real_escape_st

Hi both, and thanks again! I can only apologise for my ignorance (stupidity), but am reading that I have missed the: $row=mysqli_fetch_array($result); } at the end, to fetch the data? so PHP code now being: <?php session_start(); ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); //Connect to the database $mysqli = new mysqli("localhost", "BLAHBLAH", "BLAHBLAH", "BLAHBLAH"); if(isset($_GET['post'])){ $ID=mysqli_real_escape_string($mysqli, $_GET['ID']); $sql="SELECT * FROM uni2020 WHERE UniversityCourses='$ID'"; $re

Hi NotionCommotion - thanks for getting back at lightning speed!! There's a clue in there somewhere! I thought you might have been pointing to the order that I had put the code....thinking that the $mysqli connection string needed to be lower, so that it connected to the database once the $_GET code was evident? if(isset($_GET['post'])){ //Connect to the database $mysqli = new mysqli("localhost", "BLAHBLAH", "BLAHBLAH", "BLAHBLAH"); $ID=mysqli_real_escape_string($mysqli, $_GET['ID']); //BLAHBLAHBLAHBLAH I know I'm missing something very simple!?

Hello all - am looking for help with dynamic links in PHP not returning data and coughing out "Notice: Undefined variable: row in /home/jj3wg2td/public_html/Uni More Info.php on line 200" The initial search is being fed from a mysql into table of results in another page ('ViewMore' being a column in my database and 'UniversityCourses' being the trigger to search that column): echo "<td class='result'><a href='Uni More Info.php?ID={$row['UniversityCourses']}'>{$row['ViewMore']}</a></td>"; This is working fine as I can see the various links changing when you h

Hello Psycho Apologies for the late reply! It takes me a while to get my head around these things, and didn't want to bombard you with messages! Your advice and support is second to none, and after a few tweaks (my fault in wording) it works perfectly!!! I was certainly trying to do too many things at once....that's the story of my life!! I cannot thank you enough and wish you all the best!!! Thanks a million (learned a lot) Steven

Hi all, I find myself in need again on PHP coding and the support last time was outstanding (no creeping here) so I am trying my luck again! I am trying to use a HREF link (lots of individual ones) to search a Mysql database and return the results in a PHP page. Example of HREF links on the page are here: https://flighteducation.co.uk/Create.html and in theory you click a career and it 'gets' and 'shows' the data from the database here: https://flighteducation.co.uk/Careers.php so, you click the 'Animator' link ->it goes to my database and drags back all the da

Maybe thats been the problem all along.....it has driven me mental (more mental), will contact the hosts and get them to do it as I cannot access/upgrade it from here! Thanks again Mr!!

See bel

Unsure if this is what you mean but: Versionmysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $ All I have done is turn the error reporting off in the code, and all works fine now (am sure to coding gurus, it would drive you mad knowing there was a glitch)! As I say....I cannot praise and thank you enough!!!!! Steven

gw1500se - I am sure I am annoying you and I profusely apologise....but I also think you are a genius!!!! (please see image) This is the first time I have managed to get anything from it in 6-7 weeks!! It still shows: Warning: mysqli::__construct(): Headers and client library minor version mismatch. Headers:50646 Library:50528 in /home/jj3wg2td/public_html/Careers Connect.php on line 8 which is: (<$mysqli = new mysqli("localhost", "jj3wg2td_steven", "PASSWORD", "jj3wg2td_careerslist");>) but am grinning from ear to ear currently!!

I can only apologise, I am trying very much! line 15 is: (<if($result->num_rows > 0)>) I have taken your advise on the php and mysqlnd version, as I believed that was the problem this morning, but after sorting, they seem to be running the same versions now? Images attached. Many thanks again! Steven

Thanks also Barand!!! Wrapped $search in ' ' and now receive: Warning: mysqli::__construct(): Headers and client library minor version mismatch. Headers:50646 Library:50528 in /home/jj3wg2td/public_html/Careers Connect.php on line 8 Notice: Undefined index: Job Title in /home/jj3wg2td/public_html/Careers Connect.php on line 19 Notice: Undefined index: Job Description in /home/jj3wg2td/public_html/Careers Connect.php on line 20 Notice: Undefined index: Salary Low in /home/jj3wg2td/public_html/Careers Connect.php on line 21 Notice: Undefined index: Salary High in /home/jj3w

and: Notice: Trying to get property of non-object in /home/jj3wg2td/public_html/Careers Connect.php on line 15

Thought I may have solved it then: Changed Dreamweaver PHP version to 7.1 and MyPHP version in cPanel to be 7.1...but same error reported (Grrr)

Thanks for your reply Steven...you cant imagine how grateful I am!!! Have altered the PHP code (below) on your advise, and have altered the headers in the database to be single words, like salaryLow, jobDescription to match the php: < <?php session_start(); $output=NULL; ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); //Connect to the database $mysqli = new mysqli("localhost", "jj3wg2td_steven", "PASSWORD", "jj3wg2td_careerslist"); //Query the database if((isset($_POST['submit'])) && (isset($_POST