[Preventing Duplicate Form Submissions]

PRG -  Post/Redirect/Get

 

https://en.wikipedia.org/wiki/Post/Redirect/Get

 

[Bootstrap Tabs on Desktop and Accordion on Mobile - how is this done?]

Tabs are tabs. From Mobile on up tabs will still act like tabs. If you want an accordion use the accordion. If you want the tabs to magically become an accordion, bootstrap doesn't do that. You would probably have to use some JavaScript to hide the tabs and replace it with an accordion. If you know of a site that behaves the way you want post it here and I may be able to help you figure out how it's done.

[Bootstrap Tabs on Desktop and Accordion on Mobile - how is this done?]

That is bootstraps default behavior. You don't need two different designs. Bootstrap is mobile-friendly,actually mobile first is the term and will scale automatically.

[populating pulldown menu from database]

Well the OP didn't ask for opinions on his db setup, and didn't post any information about his db structure,

 

Yeah, that's the thing with noobs (Don't mean it in a bad way), they don't know what to ask or provide. It the typical XY problem. http://xyproblem.info/

 

OP sees a particular problem and asks how to fix that problem not realizing it is just a symptom of the real problem.

 

My experience says there is a very high probability that the DB structure is wrong which is why I asked the OP to provide it. I am sure you would agree that the DB is the first thing to ensure is correct and if not to fix that first.

[populating pulldown menu from database]

@Zane, the if is just a quick fix band-aid for what is pretty clearly a bad database design.

 

 

@wkilc, if your wanting to get things done correctly, post your DB schema and we will help you get this right from the ground up. Your Database is the foundation on which you will write all your code. If that is not right, the code you build on it will not be right and you will continue to run into unnecessary problems.

[populating pulldown menu from database]

If you have a properly normalized database with one table with a list of car names you shouldn't have any empty rows. You would also want to be using the ID of the car name not the actual name itself for the value. Additionally, the file name does not belong in the value.

[Hiding a "Channel", but not a "Category"]

Your code is obsolete. ereg and MySQL_* have been completely removed from PHP.

[Hiding a "Channel", but not a "Category"]

I told you exactly where the problem is and what the problem is. Your first Echo doesn't close.

[Hiding a "Channel", but not a "Category"]

You are missing the closing quote and semicolon on your echo.

[Simple PHP for a Real Newbe]

<?php //do action( '' ); ?> 

Copyright © <?php echo date("Y") ?>

[check two columns to populate form variables]

Oh where to start...

 

You are using obsolete code that has been completely removed from Php.

Hiding errors with the @ is a no-no.

If you have School1 and School2 in your DB, your database is wrong and needs to be re-worked.

You are directly injecting user supplied data into your code and open for an attack

 

In short, your database and your entire code needs to be re-written.

 

Look up and learn Database Normalization and study this PDO Tutorial https://phpdelusions.net/pdo

 

What you have is junk and dangerous and should not be used whatsoever.

[Gathering Data for a Daily Report]

If you want a complete correct answer you will need to post your DB schema.

[Comment not working in email]

Get in the habit of always using lower case for names and variables and seperate_multiple_words_with_an_underscore.

[Updateing Software Apache/PHP/Mysql]

Session_register and  register_globels is obsolete. If  you checked the manual you would see big red boxes telling you so. I am quite certain your code is obsolete as well.

[Updateing Software Apache/PHP/Mysql]

I am converting code

What code? I dont see any.

[New server doesn't like my code]

5.6 minimum

[foreach wont display results on modal?]

You have an extra } in your code.

[UPDATE from SELECT]

Found the problem. In the schedule table, a lot_id can be there more than once. Mysql is using the last rows schedule_date to calculate. I will have to add one more piece of criteria to use the correct row.

 

@Kicken, thanks for your help.

[UPDATE from SELECT]

Thanks @kicken.

 

That has me on my way. It did update many records but there are many where the datediff is not correct. I even deleted all the order_by_dates and ran the UPDATE and it still creates some dates that are not the correct difference. I even hard coded the days to subtract 21 days from schedule date. I am getting dates from -67 to 432 days difference. Very confused.

 

I broke down the update query to as simple as possible and still same result. Using:

UPDATE lot AS l
LEFT JOIN `schedule` AS s ON s.lot_id = l.lot_id
SET l.order_by_date = DATE_SUB(s.schedule_date,INTERVAL 21 DAY)

[UPDATE from SELECT]

I have an order_by_date date field that is generated based on a schedule_date. The order_by_date is the schedule_date minus days_to_order.

 

Bad data got in order_by_date so I want to update order_by_date in all rows. The following query will show me what the correct order_by_date should be. How do I take the result correct_order_by_date and update order_by_date with that value?

 

*** As I was writing this, it occurred to me a calculated date does not need to be stored in the DB, nevertheless, I would still like to know the technique to do this. See Attached image

SELECT
DATE_SUB(s.schedule_date, INTERVAL d.days_to_order DAY) AS correct_order_by_date,
l.order_by_date,
s.schedule_date,
d.days_to_order
FROM
community AS c
LEFT JOIN block AS b ON b.community_id = c.community_id
LEFT JOIN lot AS l ON l.block_id = b.block_id
LEFT JOIN `schedule` AS s ON s.lot_id = l.lot_id
LEFT JOIN days_to_order AS d ON c.days_to_order_id = d.days_to_order_id
WHERE
s.reschedule_date IS NULL AND
l.order_by_date IS NOT NULL AND
l.lot_type_id > 2 AND
s.schedule_date IS NOT NULL AND
c.community_type < 3 AND
l.active = 1 AND
l.order_by_date > s.schedule_date

[Mimicking autoincrement primary key using PHP]

I for one don't understand what you're trying to do. What is the overall task at hand that you think this is the answer for??

[timeago function giving wrong value]

If you your datetime is coming from Mysql you can let the DB do the work.

SELECT DATEDIFF(NOW(),'2016-07-02 16:41:48') AS date_time

<?= "<span class='timeAgo'>{ago($row['date_time'])}</span>" ?>

[Using this famous password library gives me an error on live server. Why's that?]

 

 

 I switched it to PHP 5.4

 

You are still well over a hundred releases behind. You need to be running 5.6x minimum.

[I need your help applying a script to more databases]

Eric, I have done a quick review of the code in that script. Get your money back and don't use it. There are several serious security issues with it. One of the more glaring ones is that it uses MD5 or SHA256 for password encryption. It will also output the exact server error messages directly to the user providing valuable information to a hacker.

[activation email and password resetting]

 

 

 In fact, there are likely activities you may want to track that have no hash as part of that activity. E.g. unsuccessful logins.

Funny you should say that. I already do that. It is part if the login script that I have not posted. I log all login attempt statuses, good or bad, what the bad user and pass was and IP and datetime.

 

As I think about it, it wouldnt take much modification to track just the reset data. Table is already there, just need to remove the hash and expiration columns and put them in the users table.