Search DaniWeb - image2database

Re: Using Natural Language to Query SQL Databases with Python LangChain Module 8 Hours Ago by aishamushtaq very helpful HTML Image Embedding Issue 6 Days Ago by khan zain "I'm attempting to embed an image in my HTML page, but it's not showing up. I've checked the file path, and it seems correct. Below is the code I'm using. Any insights on why the image isn't displaying as expected?"" <!DOCTYPE html> <html lang=""en""> <head> <meta… Re: Video is not the main content of the page 4 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 query database using variable and get all results not just one row 2 Weeks Ago by Mikekelvin To ensure that you're retrieving all records associated with the current user, you need to make sure that your query accurately filters the data based on the user's identifier (variable_name). Here's how you can modify your query to achieve this: // Assuming $currentUser holds the identifier of the current user // Query database to retrieve … Re: How to query database using variable and get all results not just one row 1 Week 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->… How Build Html form ? 3 Weeks Ago by Kirubel_2 <!DOCTYPE html> <html style="font-size: 16px;" lang="en"><head> <title>Comment</title> <script src="js/jquery.js"></script> <link rel="stylesheet" href="sign.css"> </head> <body … 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 … 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 … Re: Video is not the main content of the page 1 Week Ago by Dani You have the itemtype set to a VideoObject but, as you point out, only sometimes is there actually an .mp4 file. The rest of the time, it's a static image such as a png, jpg, or jpeg. Google probably doesn't trust your meta tags since they are inaccurate half the time. Paris Olympics Ticket Information Chatbot with Memory Using LangChain 4 Weeks Ago by usmanmalik57 In my previous article, I explained how I developed a simple chatbot using LangChain and Chat-GPT that can answer queries related to Paris Olympics ticket prices. However, one major drawback with that chatbot is that it can only generate a single response based on user queries. It can not answer follow-up questions. In short, the chatbot has no … VB2010- why i get a different vertical size\color on RayCasting? 3 Weeks Ago by cambalinho these is the VB6 function for RayCasting: Private Sub DrawRays() Dim StepX As Double Dim StepY As Double Dim VertX As Double Dim VertY As Double Dim HorizX As Double Dim HorizY As Double Dim MapX As Long Dim MapY As Long… How Build video-player in html And css ? 3 Weeks Ago by Kirubel_2 <head><title>navigation</title> <link rel="stylesheet" href="../css/nav.css"> <link rel="stylesheet" href="../css/tutorial.css"> <link rel="stylesheet" href="../css/vedio.css"> <link rel="stylesheet" href="… Re: ASUS Laptops - my experience 3 Weeks Ago by toneewa I wouldn't worry about not having any ASUS utilities. You can always download them later, [here](https://www.asus.com/support/download-center/). I consider them all bloatware. Having the partition as an MBR and then installing a Windows image as GPT, is like going to replace your spare tire and finding out it has a different lug nut bolt pattern… Re: ASUS Laptops - my experience 4 Weeks Ago by Reverend Jim Got my laptop back from Best Buy this afternoon. I checked the power cord connection at the store and it was fine. I wish I'd checked it further because I started having problems as soon as I got it home and powered up. First of all, they replaced the motherboard so when I got it back it had been wiped and reset. First thing I noticed was that the … Re: Do you participate in any other communities? 4 Weeks Ago by Dani I was talking to Chris (the DiC founder/owner) a little bit before he decided to shut it down. He was saying he's been so busy with his other businesses that he spent maybe 5 minutes on it over the past 5 years, so he lost interest, and it wasn't paying its server costs. At least in the case of DaniWeb, it *also* isn't even coming close to … Re: Improve HAVING BY performance 3 Weeks Ago by Dani > I know that in my experience, OR's are very bad for speed you can get away with a few but they can get very bad when they stop the whole query making use of one of the main indexes, you can actually speed it up by moving the or's into the HAVING usually. Thank you for that tip! I never thought of that, but it totally makes sense!! > … 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: ASUS Laptops - my experience 3 Weeks Ago by Reverend Jim When I got it back they had replaced both the motherboard and the power supply and I checked in the store to verify there were no power issues. I suspect you are correct about them not reconnecting the touchpad as that was not working in Linux either. As for GPT vs NTFS, I have never formatted to anything but NTFS, and when I originally got the … Re: ASUS Laptops - my experience 3 Weeks Ago by Reverend Jim >Sounds like a very bad recovery image Possibly. But why didn't this show up when they did the reset prior to returning the laptop? Imagine that you just bought a car (should be pretty easy for you). You and your wife take a drive in the countryside and at some point you drive over a nail and get a flat tire. No problem because you have a … Re: Improve HAVING BY performance 2 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 2 Weeks Ago by Dani But you're not comparing apples to apples. Your WHERE query and your HAVING query perform different calculations and do different things. In one, you're plucking out all the rows with a price greater than $4, and then calculating an average price for each product. In the other, you're plucking out *all* rows, calculating an average price for each … Re: Improve HAVING BY performance 2 Weeks Ago by Dani I think you might be missing my point. If you’re fetching different data, there’s no way of saying whether where or having is faster. You would need to write queries that use each, but retrieve the same data, to see which is faster for a use case. Even then, it totally depends on the data in the database itself. The same query can be fast for some … 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: DaniWeb Auto Answer A.I. feature 2 Weeks Ago by Dani Pardon my cluelessness here. A $300 video card can efficiently perform complex AI tasks against DaniWeb’s entire database in real time? Missed the link to the Python API. Re: How to query database using variable and get all results not just one row 2 Weeks Ago by Biiim logically, it would be because `WHERE variable_name = :variable_name` matches 1 row in your table maybe try a `var_dump(str_replace(':variable_name',"'some_value'",$sql));var_dump($records);`? run the sql on whichever way you use to access your DB directly I don't use PDO so i'm not too familiar on how it returns results, either … 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) … Re: Mariadb10.11.6 Glarea single failed node startup stuck failure 2 Weeks Ago by rproffitt From https://stackoverflow.com/questions/78269177/mariadb10-11-6-galera-single-failed-node-startup-stuck-failure where they call it out as a bug waiting for a fix. Re: Mariadb10.11.6 Glarea single failed node startup stuck failure 2 Weeks Ago by rproffitt The problem is still unresolved. Until the bug is fixed. Be sure to tell all that you don't accept this as a bug and want a fix now. Re: Mariadb10.11.6 Glarea single failed node startup stuck failure 2 Weeks Ago by rproffitt I wonder if the last other stable releases show this issue? "Stable release: 11.3.2 / 16 February 2024; 46 days ago" or the most recent release of MariaDB 10.11: MariaDB 10.11.7 Stable (GA) That is, many fixes don't get released for out of date versions. The new version is how many fixes are issued. Re: Mariadb10.11.6 Glarea single failed node startup stuck failure 2 Weeks Ago by toneewa I wonder how these IP addresses are issued. Static, dynamic, or is DHCP on? It reminds me of the time a network printer that stopped working, after the power went out. Other devices connected to the network after it's setup. Then, after rebooting, it got a different IP, but the host still thought it was on the old one. I've seen the same thing when…