Search DaniWeb - mysql_fetch_array

Re: Online subission forms not sending emails of submitted info 9 Hours Ago by david.tigner My 4 domains are all through URL provider IONOS. The question is why does the sender's email address as entered on the front end of the on-line submission form have to have the same ending as the domain name of the site or one of the other 3 or else submitted info fails to send ? Re: Online subission forms not sending emails of submitted info 5 Hours Ago by david.tigner That's a problem. The email addresses issued for @RadiantNewHorizonHomes.com or 1 of the other 4 are created by me. Unknown parties that submit online forms on one of my domains would not have one of these email addresses. I would want to receive the submitted info from senders of any email address like has been since 2011 until Feb 2024. This is … Re: Online subission forms not sending emails of submitted info 3 Hours Ago by david.tigner There is no making emails "appear" to be from other than the true sender. I'll explain further. Suppose John Smith has an email address of johnsmith@gmail.com. John then goes on to one of my sites, lets say RTO-USA.net, and fills out an online submission form and enters his email address truthfully (johnsmith@gmail.com). This email … Re: Online subission forms not sending emails of submitted info 2 Hours Ago by david.tigner If John isn't the sender then who is ? Also, continuing from the John Smith example, if John Smith enters his email address as johnsmith@SubterraneanSoundStudio.com or johnsmith@RTO-USA.net (ficticious email addresses) then the submitted info would be emailed to me but if he uses his true email address then it would not. Continuing from this … Re: Using Natural Language to Query SQL Databases with Python LangChain Module 1 Day Ago by aishamushtaq very helpful Re: Online subission forms not sending emails of submitted info 5 Days Ago by david.tigner This one is becoming more perplexing. After adding in the PHPMailer coding, page would crash (e.g. blank white screen, HTML file that would display the screen doesn't even start at all, e.g. error in the 1st running PHP file). Adding the semi-colon at end of line 18 (in previously discussed code) did not work and funny thing is, the original coding… Re: Online subission forms not sending emails of submitted info 3 Days Ago by Chris_103 It seems like you're experiencing issues with PHP-based email functionality, where submissions are not triggering emails to be sent. Let's dive into the code snippet you provided and see if we can identify any potential issues or improvements. Re: Online subission forms not sending emails of submitted info 1 Day Ago by Biiim I checked my code and I only found 2 differences, the first is the 2 `use` commands before the require: use PHPMailer\PHPMailer\PHPMailer; use PHPMailer\PHPMailer\Exception; require 'includes/PHPMailer/src/Exception.php'; require 'includes/PHPMailer/src/PHPMailer.php'; require 'includes/PHPMailer/src/SMTP.php';… Re: Online subission forms not sending emails of submitted info 1 Day Ago by david.tigner I just discovered some new information on why the online submission pages weren't sending as during some testing I discovered there was a way for the submitted info to be sent. Here it is. I have online submission pages on 4 websites: RadiantNewHorizonHomes.com, RTO-USA.net, SubterraneanSoundStudio.com and RebHellionRecords.com. Each of these 4 … Re: Video is not the main content of the page 5 Days Ago by Read a Book But i am generating the JSON code dynamically. If there is no video than i hide the VideoObject tag with if statement. Should i just remove the `itemscope itemtype="http://schema.org/VideoObject"` Re: how to create a simple elevator simulation? 2 Days Ago by trueframe To make a basic elevator simulation, first, identify the floors and the elevator's capacity. Then, use loops and conditionals in programming to mimic its movement. Include buttons for users to call the elevator and select floors. Test thoroughly for accuracy. Re: Improve HAVING BY performance 2 Weeks Ago by toneewa I added your mentioned alter table index. Took 4.375 secs in MySQL Workbench. It did speed up the results. I'll have to try another method of importing to see if I can improve this. I also ommitted the overhead of converting variables for display output measurements, because they were included in the C++ times. If we were to compare the two, it as … Re: Improve HAVING BY performance 3 Weeks Ago by Biiim > I don't have experience with MariaDB, but in MySQL, something like that will work as long as I do SELECT sum(points) AS total FROM ... HAVING total > 10. Is that what you were getting at? Kind of, MariaDB is a fork of MySQL from around 2009 or something like that, MySQL 5.* and the creator continued developing MariaDB and Oracle took … Re: Improve HAVING BY performance 3 Weeks Ago by toneewa I'm a little late to the party, however, I want to share my experience learning MySQL in the past day. I setup a server, a database, and wrote a C++ program to connect to it. It measures the times for 3 SELECTs. The whole product list, using HAVING, and WHERE. I also tested reversing the orders. Query execution time: 0.0002336 seconds … Re: Improve HAVING BY performance 3 Weeks Ago by Dani > SELECT sum(points) total FROM ... HAVING points > 10 I don't have experience with MariaDB, but in MySQL, something like that will work as long as I do `SELECT sum(points) AS total FROM ... HAVING total > 10`. Is that what you were getting at? As far as what I was trying to accomplish that provoked this question, I was working on a … Re: Improve HAVING BY performance 2 Weeks Ago by toneewa I know when you don't use aggregate calculations use WHERE. Producing the same results can be done. I added another test with MAX(Price). With a database over 305K rows, 3 columns, MySQL Workbench is unstable importing. Took over 2 hours. WHERE is faster, and should be used, when no functions are needed. WHERE Query execution time: 0.… Re: Improve HAVING BY performance 2 Weeks Ago by Biiim > INSERT INTO electronics.products(ProductID, ProductName, Price) VALUES ('1','capacitors', 2.50), ('2','resistors', 4.50), ('3','rectifiers', 7.50), ('4','diodes', 10.00), ('5','ICs', 25.00), ... ('50000','...', ...); I don't see any mention of an index on it & your benchmark indicates you don't have one: ALTER TABLE `… Re: How to query database using variable and get all results not just one row 2 Weeks Ago by Chris_103 To retrieve all records associated with the current user, you can use the fetchAll() method instead of fetch(). Here's how you can modify your code: ```php // Query database to retrieve records associated with the user $sql = "SELECT * FROM table_name WHERE variable_name = :variable_name"; $stmt = $conn->prepare($sql); $stmt->… Mariadb10.11.6 Glarea single failed node startup stuck failure 3 Weeks Ago by mx_983 Basic background information Mariadb Ver 15.1 District 10.11.6 MariaDB Glarea cluster, one with three nodes: Node1:192.168.18.78 Node2: 192.168.18.79 Node3: 192.168.18.80 Among them, Node1 node was restarted after a power outage of 1 hour, and after executing the system ctl start mariadb, it was stuck for a long time (running for 6 hours) … Using Natural Language to Query SQL Databases with Python LangChain Module 2 Weeks Ago by usmanmalik57 The advent of large language models (LLM) has replaced complex scripts with natural language for automating various tasks. You can now use LLM to interact with your databases using natural language, which makes life easier for people who do not have sufficient SQL knowledge. In this article, you will learn how to retrieve information from SQL … Bouncing Balls: Creating a new ball when two balls collide 2 Weeks Ago by jprog1000 Hello, I have a program which creates multiple balls and bounces them off when they collide. This works fine. import java.awt.Rectangle; public class Ball{ private int x = 0; private int y = 0; private int radius; private int panelwidth = 500; private int panelheight = 500… Video is not the main content of the page 2 Weeks Ago by Read a Book Hello everyone, i am not able to fix this issue in the Search Console `Video is not the main content of the page` but actually it is! When you enter in my product page the first thing that appears is the video it self! (hosted on imgur platform) I even added additional Schema video tags but that seems is useless. here is the code i am … Re: Bouncing Balls: Creating a new ball when two balls collide 2 Weeks Ago by toneewa I cleaned up the code some more. Removed some things that were not being used. I ran into a couple problems which caused the freeze you mentioned. It was memory heap space and array allocating. E.g., if x or y becomes negative, and also infinite recursion. I added a x/y coordinate display for a ball, and tinkered with the placement of the … Re: Improve HAVING BY performance 3 Weeks Ago by Biiim I realise this has been marked as solved, but I wanted to make it known that the HAVING clause runs on the returned result set of your query, which as you say has no indexes on it as it is just a temporarily created result set - but has the benefit of allowing you do do some simple post-processing on the result set. (This is for MariaDB at least)… Re: Improve HAVING BY performance 3 Weeks Ago by Reverend Jim Was it worth all that for 50ms? Re: Improve HAVING BY performance 3 Weeks Ago by Dani In exchange for less than a day's worth of work? Of course!!!!! I've spent a *lot* longer to shave off a *lot* less. https://www.conductor.com/academy/page-speed-resources/faq/amazon-page-speed-study/ Re: Improve HAVING BY performance 3 Weeks Ago by Dani Now as far as whether going down that rabbit hole that day was worth the cost of losing AndreRet, then I'd have to give a resounding no. Re: Improve HAVING BY performance 3 Weeks Ago by Reverend Jim I have to admit that 95% of my work from 1995 to 2008 was back end stuff where I didn't have to worry about stuff like that. Digital plumbing and monitoring. The other 5% was single user apps. Not counting the 20% which was pointless meetings. So if you don't mind explaining, I'm curious as to why 50ms would even be noticible. I'm not asking just … Re: Improve HAVING BY performance 3 Weeks Ago by Dani I'm too exhausted for an in depth explanation right now but 90% of web development is optimizing for performance. The average DaniWeb page takes anywhere from 80ms up to 250ms to load the HTML (when dealing with low network latency), depending on the type of page, so shaving 50ms off of that is a huge win. Re: Improve HAVING BY performance 3 Weeks Ago by Dani Here are some articles that can explain it in greater depth: * https://web.dev/learn/performance/why-speed-matters * https://developer.mozilla.org/en-US/docs/Learn/Performance * https://web.dev/explore/fast The HTML page must be downloaded in its entirety before the web browser can begin loading anything else (CSS, Javascript, images, etc.)…