Search DaniWeb - database

Keep an eye out for database errors 6 Days Ago by Dani … today to not connect to the database unless required. Previously, it automatically connected on every page.…, especially on pages that just pull from the cache, database connections aren’t necessary. Hopefully this should provide some incremental…. In the meantime, please keep an eye out for database errors because I coded half-asleep today. P.S.… Re: MySQL Packets out of order 5 Days Ago by Haseeb_12 Thanks for sharing this insight! Disabling persistent connections when using transactions is a great tip and saved me a lot of debugging time. Re: Things I hate about TV shows 3 Days Ago by Reverend Jim Why is it that when people in shows light a fire (like when setting a vehicle on fire) with a lighter, they always throw the lighter into the puddle of gasoline? Do they not realize that a lighter is reusable? On a related note, researchers tried hundreds of times to ignite a puddle of gasoline by throwing a burning cigarette into it. They were … Re: Things I hate about TV shows 3 Days Ago by Dani > Do they not realize that a lighter is reusable? They do it to show how they live life on the edge by proving to the world (and the television audience) they won't have any more use for a lighter. > They were successful exactly zero times. Researchers, schmearchers. But has Myth Busters had a go of it? Re: Things I hate about TV shows 2 Days Ago by Reverend Jim Actually, I think they did with the same results. Supposedly the temperature of the cigarette is below the flash point of gasoline. Did anyone else suffer through the final season of Star Trek: Discovery? Re: Database wrapper for Codeigniter 3 1 Week Ago by pyeri … myself use CI3 for most of my freelance projects. For database interaction, I usually don't use the CI models, I… Re: Database wrapper for Codeigniter 3 2 Weeks Ago by Dani Wow, this is old. I just stumbled upon it and it’s so crazy looking back at old code you wrote once upon a time. Especially since we are still working off the same framework so it’s just interesting to see how much it’s morphed and evolved over the years. Re: Database wrapper for Codeigniter 3 1 Week Ago by Dani I started with CI3 probably like a decade ago, and that’s what I’m continuing to use, albeit with a bunch of security updates and so forth. It’s not worth it to me to upgrade to CI4 right now since that would pretty much be a complete rewrite of the entire app for not much upside. Do you have any experience with CI4? Re: Database wrapper for Codeigniter 3 1 Week Ago by pyeri I have never bothered to check CI4 as CI3 fulfilled all my web development needs. It required some modifications when PHP 8 came (PHP 8 didn't allow dynamic properties which are used in CI3). But otherwise, it works fine for most small to medium sized projects. One of the best things about CI3 is that it works out of the box with minimum initial … Dead Internet Theory: Is the Web Dying? 4 Weeks Ago by Johannes C. … them could have been lifted straight from a spambot's database. So, are we now stuck in a cycle where **bots… Unpopular Opinion: Bootstrap+jquery+CI is the best thing since sliced bread 1 Week Ago by pyeri … core framework code). 2. Bells and Whistles included (Routing, MVC, Database interaction, form building, etc.) 3. Integration with Composer/Packagist. 4… Re: MySQL Packets out of order 1 Week Ago by wwwalker If PHP locks the database connection in a persistent connection and the packets from the transaction are incomplete then the packets would be out of order. Hence asynchronous PHP connection would be OK for transactions and not have the locks that persistent connection would create. Re: How can I log in? 2 Weeks Ago by Dani … not retroactively remove your email address from the hacker's database. > Thank you for your continued trust. Re: How can I log in? 2 Weeks Ago by Dani … in 2015 and a list of email addresses in our database were leaked. Passwords were not compromised. Logins were not compromised… Re: Dead Internet Theory: Is the Web Dying? 3 Weeks Ago by m_624 "Dead Internet Theory" is an idea that says the internet is becoming less genuine and less alive. Here's a simple explanation: The theory suggests that: Bots and Fake Content: A lot of what we see online is created by bots or automated programs, not real people. This includes social media posts, comments, and even articles. … Re: Dead Internet Theory: Is the Web Dying? 3 Weeks Ago by Reverend Jim Seems like an extension of Sturgeon's Law which states "90% of everything is crap". Re: Dead Internet Theory: Is the Web Dying? 2 Weeks Ago by Nina0X So, what can we do to prevent the web from dying? I guess web3 is the answer! If the technology enables then the internet should not only be used for connecting and sharing some kitties! The whole of humanity's wealth will be held on the Internet.. Re: Dead Internet Theory: Is the Web Dying? 1 Week Ago by pcbugfixer I believe it is. With AI involved and the misleading and duplicate information tells me that the WWW is corrupt and becoming useless. And it is the Spammers, Hackers and the like that did it. Time will tell Re: Dead Internet Theory: Is the Web Dying? 1 Week Ago by m_624 The Dead Internet Theory suggests that the internet is dying or already dead due to the prevalence of bots and automated content. However, the internet continues to grow and evolve, remaining a vital part of modern life. Re: Unpopular Opinion: Bootstrap+jquery+CI is the best thing since sliced bread 1 Week Ago by Dani I've posted my story many times before, but here it is again :) I've been programming the majority of my life, first in Apple BASIC, then QBasic, then Visual Basic, then C++. PHP was my first foray into web development, and DaniWeb was my first project. DaniWeb started 22 years ago with phpBB, and then evolved to vBulletin. I knew the phpBB code… Re: Unpopular Opinion: Bootstrap+jquery+CI is the best thing since sliced bread 1 Week Ago by pyeri That's a very fascinating journey, Dani. The early era of the Internet was very different, bulletin boards and IRC were phenomenal, especially when it came to quality of interaction. It's a great achievement that you not only used to be a part but also helped build parts of that Internet. As the PHP creator himself once said, CodeIgniter is a … Re: Dead Internet Theory: Is the Web Dying? 1 Week Ago by stuwer12 This theme needs development, but I'm connected with a blockchain group who have what we call web 4.0, totally independent ,totally peer to peer with no outside interference or involvement Don't know if it would bring back relevancy to search, but connections are true blckcerts (or blockcertsai anyone interested ,;et me know and I'll send you a … Re: Dead Internet Theory: Is the Web Dying? 1 Week Ago by wwwalker About 40% of hits to my site are bots with some trying to find exploits on my site to hack it and use it to propagate spam. Very few humans are surfing the Web any more. iptables firewall has to be used to block the hackers. Re: Dead Internet Theory: Is the Web Dying? 1 Week Ago by Reverend Jim >Very few humans are surfing the Web any more I disagree. Just because the number of bots has grown exponentially relative to the number of meat-based surfers does not mean that very few humans are still surfing. Consider how much spam e-mail is sent every minute. That does not mean e-mail is dying. Re: MySQL Packets out of order 1 Week Ago by Dani Sorry, I’m not quite sure I understand what you’re saying? Re: How to query database using variable and get all results not just one row 1 Month Ago by Mikekelvin … Assuming $currentUser holds the identifier of the current user // Query database to retrieve records associated with the current user $sql = "…This identifier should uniquely identify the current user in your database. By binding this value to the :variable_name parameter in … records associated with the current user in your database. Re: How to query database using variable and get all results not just one row 1 Month Ago by Chris_103 …(). Here's how you can modify your code: ```php // Query database to retrieve records associated with the user $sql = "SELECT… Re: How to query database using variable and get all results not just one row 1 Month 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 … Using Natural Language to Query SQL Databases with Python LangChain Module 2 Months Ago by usmanmalik57 …) response = agent_executor.invoke(query) return response ``` ## Generating Response from PostgreSQL Database Generating a response from the LangChain SQL agent is straightforward… top 5 products with the least sales from the Northwind database in a MySQL server. ``` mysql_uri = 'mysql+mysqlconnector://root:mani123@… Paris Olympics Chatbot- Get Ticket Information Using Chat-GPT and LangChain 2 Months Ago by usmanmalik57 …most accurate. The following script creates a vector database storing the vector embeddings for all the pages in…along with the context information retrieved from the vector database. The context information contains the answer to our …to provide the context information by searching the vector database containing the knowledge base. Then, we pass the…