Project import generated by Copybara.
GitOrigin-RevId: 63746295f1a5ab5a619056791995793d65529e62
diff --git a/src/inc/db.php b/src/inc/db.php
new file mode 100644
index 0000000..293707a
--- /dev/null
+++ b/src/inc/db.php
@@ -0,0 +1,38 @@
+<?php
+class db {
+ const EXPORT_DB_FORMAT_SQL = 0;
+
+ public static function sanitize($string) {
+ global $con;
+ return mysqli_real_escape_string($con, $string);
+ }
+
+ public static function needsSetUp() {
+ global $con;
+
+ $checkquery = mysqli_query($con, "SELECT 1 FROM people LIMIT 1");
+
+ return ($checkquery === false);
+ }
+
+ public static function numRows($table) {
+ global $con;
+
+ $stable = preg_replace("/[^A-Za-z0-9 ]/", '', $table);
+
+ $query = mysqli_query($con, "SELECT 1 FROM $stable");
+
+ if ($query === false) return -1;
+
+ return mysqli_num_rows($query);
+ }
+
+ public static function limitPagination($start, $limit) {
+ $slimit = (int)$limit;
+ $sstart = $slimit*(int)$start;
+ if ($slimit > 100 || $slimit < 0) return false;
+ if ($sstart < 0) return false;
+
+ return ($slimit == 0 ? "" : " LIMIT $sstart,$slimit");
+ }
+}