Stack Overflow
Stack Overflow

Questions tagged [meekro]

MeekroDB is a PHP MySQL library that lets you get more done with fewer lines of code, and prevents SQL injection.

MeekroDB is an open-source PHP MySQL library that lets you get more done with fewer lines of code.

Most web apps will only ever talk to one database. This means that passing $db objects to every function of your code just adds unnecessary clutter. The simplest approach is to use static methods such as DB::query(), and that's how MeekroDB works. Still, if you need database objects, MeekroDB can do that too.

23 questions
0
votes
1 answer

MySQL Left Join (using MeekroDB)

This is really a MeekroDB exclusive issue, just trying to wrap my head around Left_Join. I have 2 Tables: comp_checklist and comp_checklist_items I want to get all the rows from comp_checklist where the user Id matches and this worked…
Packy
  • 3,405
  • 9
  • 50
  • 87
0
votes
1 answer

Unable to get DB::query() to work with variables from simpleXML

I am reading an XML file, and using the data to create queries with MeekroDB. Everything looks good with the XML read and parsing, and I confirmed the variables doing simple echos. However, when I build the DB::query() it doesn't seem to be adding…
Dizzy49
  • 1,360
  • 24
  • 35
0
votes
0 answers

MySQL sometimes not returning the same results to php as to workbench

My project is a webapp that reads a database and sends emails. I inserted the database today and with the "example" one was working okay but did not have so many rows as the real one. My problem is that something(database side) in one of the queries…
spkkya
  • 21
  • 8
0
votes
1 answer

php error MYSQLI_OPT_CONNECT_TIMEOUT using meekrodb

I am building a PHP website using MeekroDB and PHPMailer. I don't know why, but today I got this PHP error that is only on my desktop. On my laptop everything works fine. I've tried to reinstall MySQL and delete all files and copies from my…
spkkya
  • 21
  • 8
0
votes
3 answers

improve code xml-mysql for large insert (86k entries) (PHP)

I must insert a large data to mysql from a xml every day, I do this job with cron job, but it takes about 2 hours to insert all the data to my DB, Is there anyway to decrease that time? Here is my code: I use meekroDB to insert My first code was (It…
user2854628
  • 17
  • 8
0
votes
1 answer

AJAX pagination w/ MySQL database subset

I have a page that uses mysql & meekrodb to pull info from a database. The results are limited to 15 per page & to an alphanumeric subset of the database - In this Example, 1-3 & A-B I now want to add pagination when click either #goleft or #gort,…
parti
  • 205
  • 3
  • 15
0
votes
1 answer

Query MySQL alphanumeric w/ Limit using MeekroDB

I'm trying to sort by certain alphanumeric range 1-3 & A-B for first 15 matches, but am getting nothing in output. Using MeekroDB. Not sure how to translate what I have here to their method. $results = DB::query("SELECT substr(theme, 1, 1) as…
parti
  • 205
  • 3
  • 15
-1
votes
1 answer

Changing a PHP/AJAX script to work with MeekroDB?

I'm trying to "convert" a very small project (list of data that can be re-arranged by dragging and dropping) from, well, I suppose usual PHP, mysqli and ajax to working with MeekroDB instead. It works fine in its original form (this is the small PHP…
eqr21
  • 51
  • 6
1
2