
wix100
Members-
Content Count
16 -
Joined
-
Last visited
Community Reputation
0 NeutralAbout wix100
-
Rank
Member
-
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