Lloyd_4

I have a url that contains variables - For Example: reset/password.php?var1=12345&?var2=abcde I would like to know how I can remove (hide) the variables from the url, So no one knows with the values are - But still use them on my page? I am creating a password reset for a …

Hi everyone, Iam trying to figure out how to display the correct time and date format in the following piece of code $stmt = $conn->prepare("SELECT * FROM tbl ORDER BY id DESC"); $stmt->execute(); $total = $stmt->rowCount(); while ($row = $stmt->fetchObject()) { //$opvar = $row['mchq_date']; echo " <tr> <td>{$row->mchq_date}</td> </tr> "; …

Hi Everyone, I have the following script / select that is displaying all fields from my database - But only if i use {$row->field_name} in the output while loop - $stmt = $conn->prepare("SELECT * FROM tbl ORDER BY id DESC"); $stmt->execute(); $total = $stmt->rowCount(); while ($row = $stmt->fetchObject()) { //$opvar …

Hi Everyone, I have a real noob question please, I am trying to update a mysql database using the code below, I know the invoice number variable is correct, But for some reason the database is not updating, Can someone point me in the right direction please, I have tried …

Hi Everyone, I am having a bit of a mare trying to get my htaccess file working the way I would like it too. I am trying to redirect the index.php from websitename/directory/index.php to websitename/directory/ I have tried the following rewrites but nothing seems to be working, Hope someone can …

Hi Everyone, I have a very strange issue with Posting a variable to a new page and reading the variable through GET - I have used the same code many many times on different pages but for some reason, I am unable to GET the Post variable to use and …

Hi Everyone - I keep getting the following error messages in my log file [19-Jan-2017 22:16:46 UTC] PHP Notice: Use of undefined constant CURLOPT_httpsHEADER - assumed 'CURLOPT_httpsHEADER' on line 22 [19-Jan-2017 22:16:46 UTC] PHP Warning: curl_setopt() expects parameter 2 to be long, string given on line 22 This is the …

Hi Everyone - I have recently upgraded my hosting enviroment and the php version has changed to Current PHP version: 5.6.27 Now a number of queries do not work as they did before. The below query has stopped working, Any ideas how I can update the query so it works …

Hi everyone, I am trying to run a select query using the results from an earlier successfull query. See below - $stmt = $conn->prepare("SELECT * FROM tab1 ORDER BY id DESC"); $stmt->execute(); $total = $stmt->rowCount(); $cstmt = $conn->prepare("SELECT * FROM tab2 WHERE otdc_ref='$stmt->otdq_ordernum'"); $cstmt->execute(); $total = $cstmt->rowCount(); while ($row = …

Hi everyone, I have a submit form on my website that display's to the user once is has been submitted, The problem I have is the text is being displayed as Chris &amp; Amy\&amp;#39;s 30th It should be displayed as Chris & Amy's 30th What is the best way to …

Hi Everton one, I have the following search statement that works great, But what I would like to do is expand this to include multiple LIKE '%$search%' $STM = $dbh->prepare('SELECT * FROM tblname WHERE col=:lsecure'); $STM->bindParam(':lsecure', $search); $STM->execute(); $count = $STM->rowCount(); $results = $STM->fetchAll(PDO::FETCH_ASSOC); What I would like to do …

Hi, Everyone, I am trying to add a php variable to my form input action. When I click the button to submit the form, the php var is not being added to the action url. I have tried using ".." / '..' to try to add the php var to …