Cruddiy: a no-code Bootstrap CRUD generator

Jan, you saved my life!

I have a huge collection of comics that I put in to a database (nerdy as hell). Mainly for my own use so that I could easily see if I already have that nice comic I stumbled across in a used comics store… And over the years I have been tinkering with different solutions starting with Excel, than Filemaker and moving to the old Dreamweaver MX database connectors (to have it online), over to Codeigniter when Dreamweaver stopped having a graphic interface. Sigh… all I needed was an easy way to write the basic code for listing all my comics, sort it, search, update and so on…and there you came!!! THANKS!

Now I just need to solve uploading my scanned images so I don’t have to do that manually 🙂 Any tips would be appreciated.

Just what I was looking for!

I added this code to show page numbers


echo " " . $number_of_results . " results - Page " . $pageno . " of " . $total_pages;


Thank you very much Jan van.

I use your solution for the backend of my own private finance reporting/dashboarding app. I really like it since I hope that the simple code will last a long time before I need to create the next iteration of the application. Fewer moving parts are a good thing in my book.
However I do have a little bit of a feature gap I see. Currently you are identifying foreign keys, and their values are available in the edit pages, but not in the index and view pages. It would be cool if there was an automatic join happening before the visible fields are selected. This way I ended up touching the sql you generate manually – which works, but I wish it wasn’t necessary.

Awesome work. Well done.

Thank you so much. You saved me hours of work,

FYI I did find on glitch in search. With Server version: 10.2.37-MariaDB – MariaDB Server, the CONCAT on the search pages needs to be CONCAT_WS to see records where more than one exists. Hope this helps someone else.
Cheers

Hi Jan and everybody..

As a lot of folks before me already said, cruddiy is just what I was looking for.
Great job! Very easy and direct to the task, without messing with frameworks and all that.

I have been testing it for a little project I am doing, and I liked it very much.
My PHP knowledge is a bit rusted and basic, but I am managing to advance on my project thanks to CRUDDY.

I just found a couple of problems, not sure if they related to something on my setup or is something related to cruddiy.
One of these issues I could solve touching the code, but the second one still there.

1) As somebody already reported on the comments above, on a create record form, when retrieving values from a field coming from a foreign key, it only showed the first field (the primary key of the foreing value). To retrieve the name of the associated field (description for example) I have to comment out a line of the cruddiy code:

file generate.php: removed the line “array_pop($row);” (appers only once on that file).
Not sure what it does (remember my php knowledge is no deep), but with that change it finally showed me the name of the foreign field.

2) I am not able to insert values on my tables. Only get empty values.
For example, I have a very basic table with just two fields: id (integer, autoincrement, pk), and description (varchar).
When I try to insert some value there, my description field stored on the database appears empty. The id (pk) with its autogenerated value is stored.
If someone have some tip how to solve this, I would be very thankful.

Secondly, here is table_video_address-update.php…

false, // turn off emulation mode for “real” prepared statements
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, //turn on errors in the form of exceptions
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, //make the default fetch be an associative array
];
try {
$pdo = new PDO($dsn, $db_user, $db_password, $options);
} catch (Exception $e) {
error_log($e->getMessage());
exit(‘Something weird happened’);
}

$vars = parse_columns(‘table_video_address’, $_POST);
$stmt = $pdo->prepare(“UPDATE table_video_address SET id_video_address=?,video_account_url=?,video_address=?,video_title=?,video_keywords=?,video_description=?,referred_similar_channels=?,copy_competitors_keywords=?,100_plus_likes=?,100_plus_shares=?,100_plus_subscribers=?,100_plus_comments=?,is_video_15m_long=?,keywords_in_video_text=?,keywords_in_audio_text=? WHERE id_video_address=?”);

if(!$stmt->execute([ $id_video_address,$video_account_url,$video_address,$video_title,$video_keywords,$video_description,$referred_similar_channels,$copy_competitors_keywords,$100_plus_likes,$100_plus_shares,$100_plus_subscribers,$100_plus_comments,$is_video_15m_long,$keywords_in_video_text,$keywords_in_audio_text,$id_video_address ])) {
echo “Something went wrong. Please try again later.”;
header(“location: error.php”);
} else {
$stmt = null;
header(“location: table_video_address-read.php?id_video_address=$id_video_address”);
}
} else {
// Check existence of id parameter before processing further
$_GET[“id_video_address”] = trim($_GET[“id_video_address”]);
if(isset($_GET[“id_video_address”]) && !empty($_GET[“id_video_address”])){
// Get URL parameter
$id_video_address = trim($_GET[“id_video_address”]);

// Prepare a select statement
$sql = “SELECT * FROM table_video_address WHERE id_video_address = ?”;
if($stmt = mysqli_prepare($link, $sql)){
// Set parameters
$param_id = $id_video_address;

// Bind variables to the prepared statement as parameters
if (is_int($param_id)) $__vartype = “i”;
elseif (is_string($param_id)) $__vartype = “s”;
elseif (is_numeric($param_id)) $__vartype = “d”;
else $__vartype = “b”; // blob
mysqli_stmt_bind_param($stmt, $__vartype, $param_id);

// Attempt to execute the prepared statement
if(mysqli_stmt_execute($stmt)){
$result = mysqli_stmt_get_result($stmt);

if(mysqli_num_rows($result) == 1){
/* Fetch result row as an associative array. Since the result set
contains only one row, we don’t need to use while loop */
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);

// Retrieve individual field value

$id_video_address = $row[“id_video_address”];
$video_account_url = $row[“video_account_url”];
$video_address = $row[“video_address”];
$video_title = $row[“video_title”];
$video_keywords = $row[“video_keywords”];
$video_description = $row[“video_description”];
$referred_similar_channels = $row[“referred_similar_channels”];
$copy_competitors_keywords = $row[“copy_competitors_keywords”];
$100_plus_likes = $row[“100_plus_likes”];
$100_plus_shares = $row[“100_plus_shares”];
$100_plus_subscribers = $row[“100_plus_subscribers”];
$100_plus_comments = $row[“100_plus_comments”];
$is_video_15m_long = $row[“is_video_15m_long”];
$keywords_in_video_text = $row[“keywords_in_video_text”];
$keywords_in_audio_text = $row[“keywords_in_audio_text”];

} else{
// URL doesn’t contain valid id. Redirect to error page
header(“location: error.php”);
exit();
}

} else{
echo “Oops! Something went wrong. Please try again later.”.$stmt->error;
}
}

// Close statement
mysqli_stmt_close($stmt);

} else{
// URL doesn’t contain id parameter. Redirect to error page
header(“location: error.php”);
exit();
}
}
?>

Update Record

Update Record

Please edit the input values and submit to update the record.
<form action="” method=”post”>

id_video_address
<input type="number" name="id_video_address" class="form-control" value="”>

video_account_url
<input type="text" name="video_account_url" maxlength="100"class="form-control" value="”>

video_address
<input type="text" name="video_address" maxlength="100"class="form-control" value="”>

video_title
<input type="text" name="video_title" maxlength="50"class="form-control" value="”>

video_keywords
<input type="text" name="video_keywords" maxlength="100"class="form-control" value="”>

video_description
<input type="text" name="video_description" maxlength="255"class="form-control" value="”>

referred_similar_channels
<input type="number" name="referred_similar_channels" class="form-control" value="”>

copy_competitors_keywords
<input type="number" name="copy_competitors_keywords" class="form-control" value="”>

100_plus_likes
<input type="number" name="100_plus_likes" class="form-control" value="”>

100_plus_shares
<input type="number" name="100_plus_shares" class="form-control" value="”>

100_plus_subscribers
<input type="number" name="100_plus_subscribers" class="form-control" value="”>

100_plus_comments
<input type="number" name="100_plus_comments" class="form-control" value="”>

is_video_15m_long
<input type="number" name="is_video_15m_long" class="form-control" value="”>

keywords_in_video_text
<input type="number" name="keywords_in_video_text" class="form-control" value="”>

keywords_in_audio_text
<input type="number" name="keywords_in_audio_text" class="form-control" value="”>

<input type="hidden" name="id_video_address" value="”/>

Cancel

Hi, love the script, saves having to write each script, however on my localhost, everything works fine (add/edit/delete etc), but when I serve it on a paid server, I can view the list, add, delete, but can’t view or update (the page comes up with a:
This page isn’t working
mywebsiteadd.net is currently unable to handle this request.
HTTP ERROR 500

What is going wrong and how can it be fixed?

This is the error_file:
[23-Apr-2022 05:42:55 UTC] PHP Fatal error: Uncaught Error: Call to undefined function mysqli_stmt_get_result() in /home/XXX/public_html/setup-cruddy/app/vehicle_cleaning-update.php:111
Stack trace:
#0 {main}
thrown in /home/XXX/public_html/setup-cruddy/app/vehicle_cleaning-update.php on line 111

and line 111 is this:
$result = mysqli_stmt_get_result($stmt);

Hey Jan,

Lovin’ your work, it’s a great tool!

I have a question if I may; I’m getting “Notice: Undefined index: HTTPS in D:\xampp\htdocs\cruddiy\cruddiy\app\***-index.php on line 51” it’s not causing an issue just wondering why 😉

Hi Jan,
Brilliant !
Wenn Du Lust hast, könnte ich Dir bei einigen Erweiterungen weiterhelfen.
Sag einfach Bescheid.

Beste Grüße

Nils

Here’s a bug that other users mentioned:

Warning: Undefined array key “HTTPS” (Line 51)

That said, it’s a great App for small projects. Thanks for it!

Hello Jan,
Superb work!
This will greatly help me learn and understand how this all works.
I got a little problem though, on every page I select to view, I got this message:
Warning: Undefined array key “HTTPS” in C:\wamp64\www\cruddyi\app\clients-index.php on line 51
I got 5 pages and they all have that same exact message, even though the pages display properly.
I’m running a local server and this won’t be going on the WWW. It will be a local app only. Don’t know if this makes a difference.

Thanks for any help you can provide.

Yves