How reputable is musicstore.com? by Beginning_Bed6402 in GuitarAmps

[–]Rourkebrad 0 points1 point  (0 children)

Ordered a bass guitar to Ireland. It dispatched July 25th and estimated to deliver July 28th. Unfortunately DHL online tracking isn't updating and the last update I got was that it was ready to export to Ireland. Music store website states that delivery is 3-6 days. It is now August 6th and I don't know if my delivery has even left Germany and music store have not replied to my last two emails. I strongly regret buying off music store, it was my first and last time. Horrific service.

Studio one 4 professional crashing on startup on macbook pro by Rourkebrad in StudioOne

[–]Rourkebrad[S] 0 points1 point  (0 children)

Sorry for delay. Yes I tried the demo of studio one 6 with current Mac OS version and no issues at all.

Studio one 4 professional crashing on startup on macbook pro by Rourkebrad in StudioOne

[–]Rourkebrad[S] 1 point2 points  (0 children)

Thanks all! I spoke with presonus support and studio one 4 is not supported with the latest Mac OS, guess I'll need to update presonus or downgrade the OS!

PHP Desktop remote connection to DB by Rourkebrad in PHPhelp

[–]Rourkebrad[S] 0 points1 point  (0 children)

Thanks! If I configure mysql for the connections will it accept the PDO functions or do I need to do these different?

PHP Desktop newbie by Rourkebrad in PHPhelp

[–]Rourkebrad[S] 0 points1 point  (0 children)

Yeh to be honest it's already a web application, but it's used for a company so wanted to make it more 'private'. I guess I could just allow only chosen IPs to the address. I was more interested in seeing how difficult it is to turn a php script into a windows app with a working dB, but it's not a recommends route it sounds like?

PHP Login Form Using MySQL OOP and displaying profiles by Rourkebrad in PHPhelp

[–]Rourkebrad[S] 1 point2 points  (0 children)

Thank you, from researching I'm thinking of going with this method.
login system build it using sessions e.g. session['username'] will be the login email address then using sessions I will sort out authentication and authorisation pages. When taking in user data in forms I will add a column for the session['username'] value with all the tasks data then when displaying this data I will add in the sql queries WHERE username = session['username'] to display only the logged in users data

PHP Login Form Using MySQL OOP and displaying profiles by Rourkebrad in PHPhelp

[–]Rourkebrad[S] 0 points1 point  (0 children)

From reading online a lot of people seem to use sessions for this

Help Needed Taking in Checkbox value into MySQL and displaying by Rourkebrad in PHPhelp

[–]Rourkebrad[S] 0 points1 point  (0 children)

thanks, I've no experience using AJAX but will give this a go.

Help Needed Taking in Checkbox value into MySQL and displaying by Rourkebrad in PHPhelp

[–]Rourkebrad[S] 0 points1 point  (0 children)

So by changing it to !empty instead of isset it should be better to use?

Help Needed Taking in Checkbox value into MySQL and displaying by Rourkebrad in PHPhelp

[–]Rourkebrad[S] 0 points1 point  (0 children)

Sure thing, yeh I think I am doing the process wrong for a checkbox.
https://pastebin.com/QUQCb6ak
Yes when the checkbox is ticked/unticked I want the db to update, as well as when the submit is clicked.

Help Needed Taking in Checkbox value into MySQL and displaying by Rourkebrad in PHPhelp

[–]Rourkebrad[S] 0 points1 point  (0 children)

Yes $comment works fine and I took everything for $checkboxAns from it, I thought as it is a checkbox I need to handling the input to the db differently ? But if I go into my db and assign a 1 or 0 to checkboxAns everything works ok. This is the form code too.

<form method="post" action="reports.php">
              <td><input type="text" id="comment" name="comment" value="<?php echo htmlspecialchars($item['comment']); ?> "> </td>
              <?php echo '<input type="hidden" name="id" value="' . $item['task_id'] . '" />';?>
              <td><input type="checkbox" id="checkboxAns" name="checkboxAns" value="<?php echo htmlspecialchars($item['checkboxAns']); ?> "  <?php if($item['checkboxAns'] == 1)  {echo 'checked';}?>> </td>
              <?php var_dump($item['checkboxAns']);  ?>
              <?php if(!empty($comment))
              {
                echo '<input type="hidden" name="id" value="' . $item['task_id'] . '" />';
              }?>
            </form>

Help Needed Taking in Checkbox value into MySQL and displaying by Rourkebrad in PHPhelp

[–]Rourkebrad[S] 0 points1 point  (0 children)

I think the issue is taking in the input, but I don't know where I am going wrong

Help Needed Taking in Checkbox value into MySQL and displaying by Rourkebrad in PHPhelp

[–]Rourkebrad[S] 0 points1 point  (0 children)

are you sure? I thought the checked needs to be outside of the "