-
Posts
15,229 -
Joined
-
Last visited
-
Days Won
427
Everything posted by requinix
-
Is this a one-time thing? I hope not. You're intending to write this file and then make changes over time? Add or remove things? How is this being used? Why is this being used?
-
Server segfault's when trying to PDO::rollBack() ...
requinix replied to PatRoy's topic in PHP Coding Help
Hmm, not quite complete. And getting a better backtrace will take some effort. PHP 7.1 isn't supported anymore. In fact 7.2 is old as well. Can you update to PHP 7.3? -
Server segfault's when trying to PDO::rollBack() ...
requinix replied to PatRoy's topic in PHP Coding Help
That backtrace would really be nice to see... -
$subject="Registers Info for: ".$values["classname"]." ".$values["attendance_date"].""; while ($msg = mysqli_fetch_array($result)) { $values isn't available to use until you get to the while loop. You didn't post the part of the code that shows what query is being run so I don't know whether you're doing a query that makes sense for that subject line - that is, whether it's a query for a specific class and attendance date. (Which used to be the student name in your original version...?) So if you want the classname and attendance_date, you should get those values from, presumably, the same place that the query was getting them from. Either that, or you send one email each. You'd be sending multiple emails, but only one for each classname/attendance_date combination. Again, not sure since you haven't posted the code that would help explain what's going on. Hint.
-
It's "PHP". All caps. You're calling data.addRows in the version that works and data.addRow in the version that does not.
-
Server segfault's when trying to PDO::rollBack() ...
requinix replied to PatRoy's topic in PHP Coding Help
Get rid of those references. At best you don't need them, at worst you should not have them. References are about reusing variables, so unless you actually want all those $named things to be the same variable then you don't want references. Note I said "variables", not "values". PHP will already reuse object values for you. Run it from the CLI and post a backtrace. -
With just that code? No. If it was working 2/25 and then not working 2/28 the obvious question is: what changed?
-
Look for Javascript errors, and for God's sake log that $response somewhere you can inspect it!
-
What did you try?
-
Your CSS has the animation set to happen when the icon is hovered over. Change it to animate when hover is over the <a>.
-
2) Only if you used a FOREIGN KEY clause with the table. Otherwise it's just a concept (see #5). 5) No. A "key" is not a real thing. An index is a real thing, a constraint is a real thing, a primary key and a unique key are real things, a foreign key may or may not be a real thing (see #2), but a mere "key" is just a concept. 6) No. An index can exist on a column without that column being a "key" or having a constraint.
-
If all you do is point the browser to the image, you can't control how it displays. So no, you would have to set up a page. Consider a lightbox-type feature.
-
If you want forums to have/belong to multiple categories and replies to multiple threads, yes. But that second one doesn't sound right.
-
You haven't shown the loop that must be present, but regardless Move the variable initialization to before the loop, keep inside the loop the thing that builds the body of the email message, and move the actual sending of the email to after the loop.
-
Not sure I would call a registration and login system less complex than threads and posts, but I guess it depends... I suggest you take a look at MariaDB's knowledge base section on database theory.
-
Do you have already have a concept of posts inside threads? How did you manage that?
-
How to create a self-signed certificate with OpenSSL?
requinix replied to dil_bert's topic in Miscellaneous
Reminder: these forums use Let's Encrypt certs. They last for 3+ months and we have a cronjob that automatically renews when needed. A free cert that I never have to worry about expiring and renewing by myself is amazing. -
How to create a self-signed certificate with OpenSSL?
requinix replied to dil_bert's topic in Miscellaneous
You can generate a self-signed cert just for the webserver if you want, but every browser will warn you about it (though they'll allow you to continue anyways). Let's Encrypt is for a publicly accessible website with a proper domain name and DNS setup. -
Database choices for PHP applications
requinix replied to NotionCommotion's topic in PHP Coding Help
+1 to dropping the unique on the ordering. It doesn't have to be unique. Order by it, then by something else (like the ID). It's okay. I prefer PostgreSQL over MySQL and friends. More features. Perhaps better performance. -
Do you get a 404 from the server or a 404 from MediaWiki? Are you following these instructions?
-
Forms help - Confirmation page & Sticky checkbox input
requinix replied to zhanos's topic in PHP Coding Help
Before we get to that, would you mind running your HTML through the official W3 validator? Open the page in your browser, View Source, then copy and paste it all into the "Validate by Direct Input" section. If you see any error messages, fix what they talk about. Then come on back here and post what your revised code is. -
On the common parlance side of things, typically "index" emphases that it's related to searching while "key" refers to it being an identifier for a record. Like, if your table has a user ID key then it should also have a user ID index.
-
That's so Hufflepuff.
-
different logins for different directories - one landing page
requinix replied to ajetrumpet's topic in PHP Coding Help
Apparently CPanel has something to help you out with that part.