Search found 62 matches

by ianhaney
Sun May 20, 2018 4:43 am
Forum: PHP coding => General
Topic: auto increment value inserted to two db tables
Replies: 6
Views: 287

Re: auto increment value inserted to two db tables

I managed to sort the issue by redoing the coding again by a script I found that I did for another project and is all ok now and a lot more simpler
by ianhaney
Sat May 19, 2018 12:40 pm
Forum: PHP coding => General
Topic: auto increment value inserted to two db tables
Replies: 6
Views: 287

Re: auto increment value inserted to two db tables

I have created the database and the two tables, the structure of each db table is below members table memberID, customer_ref, username, password repairs table memberID, customer_ref, customer_name, customer_email, customer_phone, computer_make, computer_model, technician, status, exrdate, exrtime, e...
by ianhaney
Sat May 19, 2018 10:41 am
Forum: PHP coding => General
Topic: auto increment value inserted to two db tables
Replies: 6
Views: 287

Re: auto increment value inserted to two db tables

I have not tried it yet as not sure what to add in the coding, below is what I have if ($stmt = $mysqli->prepare("INSERT repairs (customer_ref, customer_name, customer_email, customer_phone, computer_make, computer_model, technician, status, exrdate, exrtime, exstdate, exstime, deltype, comments, jo...
by ianhaney
Sat May 19, 2018 10:32 am
Forum: PHP coding => General
Topic: auto increment value inserted to two db tables
Replies: 6
Views: 287

auto increment value inserted to two db tables

I was just wondering if it is possible to have a auto increment id number added to two db tables instead of just one as this will be how I link the data together from two tables after logging in so the user can just see their data and no other users
by ianhaney
Fri May 18, 2018 7:31 am
Forum: PHP coding => General
Topic: no data outputted after login
Replies: 3
Views: 261

no data outputted after login

I need some help with no data being outputted after logging in, I don't get any errors showing, it's just not showing any data for the specific user. My code is below <?php ini_set('display_startup_errors',1); ini_set('display_errors',1); error_reporting(-1); $connect = mysqli_connect("localhost", "...
by ianhaney
Fri May 18, 2018 7:29 am
Forum: PHP coding => General
Topic: php pdo mysql id to two different tables help
Replies: 3
Views: 217

Re: php pdo mysql id to two different tables help

Thank you for the reply, got that side of it sorted
by ianhaney
Thu May 17, 2018 3:57 am
Forum: PHP coding => General
Topic: login script not working with password_hash
Replies: 1
Views: 152

Re: login script not working with password_hash

I got is sorted and sussed now
by ianhaney
Thu May 17, 2018 2:51 am
Forum: PHP coding => General
Topic: login script not working with password_hash
Replies: 1
Views: 152

login script not working with password_hash

I need some help with a login script that can login and work with password_hash. I am using

Code: Select all

$password = password_hash($password, PASSWORD_DEFAULT);
Does anyone have a sample login script that works with that password_hash coding?

Thank you in advance
by ianhaney
Thu May 17, 2018 2:48 am
Forum: PHP coding => General
Topic: php pdo mysql id to two different tables help
Replies: 3
Views: 217

Re: php pdo mysql id to two different tables help

I have sorted this issue but doing it another way by adding customer_ref into the two tables
by ianhaney
Thu May 17, 2018 12:09 am
Forum: PHP coding => General
Topic: php pdo mysql id to two different tables help
Replies: 3
Views: 217

php pdo mysql id to two different tables help

I am building a admin page where I can create a repair job and it also creates a username and password. I have that side all working ok, the issue I am facing is in the first db table called repairs it has memberID and id, the id is the repair job id which is auto increment and memberID is not auto ...
by ianhaney
Thu Aug 04, 2016 1:29 am
Forum: PHP coding => General
Topic: timezone in mysql database php
Replies: 3
Views: 771

Re: timezone in mysql database php

So sorry just sussed it

I used the following line at the top of my php file before any other coding

Code: Select all

ini_set("date.timezone", "Europe/London");
by ianhaney
Thu Aug 04, 2016 1:22 am
Forum: PHP coding => General
Topic: timezone in mysql database php
Replies: 3
Views: 771

Re: timezone in mysql database php

Sorry didn't really understand the content on that link you sent, is there a way it can be done in php?
by ianhaney
Thu Aug 04, 2016 1:08 am
Forum: PHP coding => General
Topic: timezone in mysql database php
Replies: 3
Views: 771

timezone in mysql database php

Hi I am trying to get the timezone set to Europe/London so the time is UK time in the database as it currently is a hour behind I have tried define the timezone but don't seem to work so was just seeing if anyone has a code snippet I can use to put in to make the time show the UK time rather than a ...
by ianhaney
Wed May 25, 2016 2:30 am
Forum: PHP General
Topic: blog system requirements
Replies: 2
Views: 738

Re: blog system requirements

Sorry just a update, I went with Wordpress in the end as does everything the client requires
by ianhaney
Wed May 25, 2016 1:15 am
Forum: PHP General
Topic: blog system requirements
Replies: 2
Views: 738

blog system requirements

Hi I have a new client who requires the following 1) Allow users to post as guests or anonymous comment posting as well as using their real name to comment 2) Have a like and unlike system for a blog article with icons such as a crown if they like a post or comment 3) approve/disapprove comments 4) ...
by ianhaney
Tue Dec 08, 2015 4:43 am
Forum: PHP General
Topic: check if logged in php issue
Replies: 1
Views: 664

check if logged in php issue

Hi I have managed to get the page checking if logged in already and redirect to the profile page but the url outputs as http://it-doneright.co.uk/affiliate-profile.php?id=$id I need to get the userid after = instead of $id Below is my code from the login page, I am unsure of what I am doing wrong or...
by ianhaney
Mon Nov 23, 2015 1:18 pm
Forum: PHP General
Topic: update a mysql record php issue
Replies: 3
Views: 1072

Re: update a mysql record php issue

Hi Sorry been at this for a while, I got a update, I now have no errors and got the employee who the task is assigned to but I can't work out why the description and status is not being pulled from the database, my code is below <?php ini_set('display_startup_errors',1); ini_set('display_errors',1);...
by ianhaney
Mon Nov 23, 2015 3:30 am
Forum: PHP General
Topic: update a mysql record php issue
Replies: 3
Views: 1072

Re: update a mysql record php issue

Hi I have a update, I have managed to get the form displaying but got a error in the description input field The error is below <br /><b>Notice</b>: Undefined variable: row in <b>/home/sites/it-doneright.co.uk/public_html/admin/staff-tasks/update-staff-task.php</b> on line <b>76</b><br /> The code I...
by ianhaney
Mon Nov 23, 2015 1:59 am
Forum: PHP General
Topic: update a mysql record php issue
Replies: 3
Views: 1072

update a mysql record php issue

Hi I have managed to get the record inserted successfully to the database but am stuck with updating the record using a php form, the data is stored across multiple tables, my database looks like the following assignment table has the following columns assign_id emp_id task_id employee table has the...
by ianhaney
Tue Jun 30, 2015 3:18 am
Forum: PHP coding => General
Topic: INNER JOIN MySQL PHP issue
Replies: 2
Views: 660

Re: INNER JOIN MySQL PHP issue

sorry got is sorted and sussed now
by ianhaney
Tue Jun 30, 2015 1:48 am
Forum: PHP coding => General
Topic: INNER JOIN MySQL PHP issue
Replies: 2
Views: 660

Re: INNER JOIN MySQL PHP issue

Hi Sorry just a update, I have altered the coding to below, it is displaying the description for each item and it's date but is still repeating the name and email address where as I only want the name and email address to be displayed once [PHP] $sql = "SELECT v.visitor_id , visitor_name , visitor_e...
by ianhaney
Tue Jun 30, 2015 1:24 am
Forum: PHP coding => General
Topic: INNER JOIN MySQL PHP issue
Replies: 2
Views: 660

INNER JOIN MySQL PHP issue

Hi I am trying to make a profile page that displays the following data from the database like below Name Email Address Tel Number Mobile Number Car Insurance expiry date: 30 June 2015 Car MOT expiry date: 30 July 2015 Car TAX expiry date; 30 August 2015 At the mo it just seems to be duplicating the ...
by ianhaney
Sat Jun 27, 2015 3:27 pm
Forum: PHP coding => General
Topic: JOIN mysql php
Replies: 0
Views: 607

JOIN mysql php

Sorry on my userinfo.php page it currently retrieves and displays the username and email address but now I want to retrieve and display the Full name of the visitor from the visitors table I know it can be done using JOIN but not 100% sure how to code it in I did try from another php file that uses ...
by ianhaney
Sat Jun 27, 2015 2:03 pm
Forum: PHP coding => General
Topic: part of form not adding to database
Replies: 1
Views: 525

Re: part of form not adding to database

sorry sussed it, I missed out the call query after the first query
by ianhaney
Sat Jun 27, 2015 1:39 pm
Forum: PHP coding => General
Topic: part of form not adding to database
Replies: 1
Views: 525

part of form not adding to database

Hi I just thought I would test the info form again to make sure it still works and I fill it out and it comes up added to database so I check the database and the only data it has added is the dates into the renewal table, it has not added any data to the visitors table The php page is not displayin...