[Redirect to installer if database is empty - Codeigniter 3]

The ORDER BY is pointless. You are only specifying a single ID in the WHERE clause.

Update the method to return false if the query fails or if there are no results. You want to fail fast with a "guard clause". In your Home method check for false and redirect to the install if the condition matches.

public function all_setting()
{
    $query = $this->db->query("SELECT * FROM tbl_settings WHERE id=1");
    if ($query === false || $query->num_rows() === 0) {
        return false;
    }
    return $query->first_row('array');
}

 

    if ($data['setting'] === false) {
        redirect('../install/');
    }

// Other code... 

 

[Php mysql user delete option. This one is tricky]

Yeah, that's not going to work. Records can still be deleted. PM me the site URL and I will show you how and why.

[PHP Version 5.4.45]

Php 7 has reached end of life. Tell them to upgrade you to Php 8.

[Ratings in database ala Amazon. How many of each?]

1 hour ago, Barand said:

That blows your signature's assumption out of the water.

It's just a signature Barand. We are just arguing at this point. Grab a pint and enjoy your day. See you on another thread. 🙂

[Ratings in database ala Amazon. How many of each?]

For starters, the OP basically lied. The OP has ABSOLUTELY NOTHING to do with "Ratings in database ala Amazon". The OP admits it later on..

"In reality, this is a quiz composed of 15 questions each of varying lengths."

And no, I didn't know it was incorrect for what the op was really trying to do. Had it really been a rating system, the query does indeed work to show ratings. Nevertheless, I won't be using AI content in future posts.

[Ratings in database ala Amazon. How many of each?]

4 hours ago, Barand said:

To save time, let's just assume that sometimes you are.

Sometimes yes, but in this case (and my other posts last night) no since it wasn't my response. Allow me to explain...

I have been experimenting with the ChatGPT AI (Artificial Intelligence). "My" post was 100% generated by the ChatGPT AI based on the full text of the OP. Obviously AI still has a ways to go and can be absolutely wrong or even provide "dangerous" code solutions. Still, it is pretty cool what it can do at this stage. You can check it out here https://openai.com/blog/chatgpt/

[Regex to start at one line and end after an IP address on another line of an array]

You can use a combination of the preg_grep() function and regular expressions to select the range of data that you want. The preg_grep() function returns all elements of an input array that match a certain regular expression pattern.

Here's an example of how you can use it to select the range of data that you want:

$start = preg_grep("/gpononu/", $array);
$start_key = key($start);
$end = preg_grep("/\b\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}\b/", $array);
$end_key = key($end);
$result = array_slice($array, $start_key, $end_key - $start_key + 1);
print_r($result);

This will give you an array containing the lines from the input array that match the pattern "gpononu" (line 9 and 13) until the first line that matches the pattern for IP addresses (line 11 and 15) You can use array_slice with 3rd parameter as $end_key - $start_key + 1 , this will give you desired result.

[Undefined array key "HTTP_ACCEPT_CHARSET" PHP8]

The @ symbol in front of the variables in this code is called an error suppression operator. It is used to suppress error messages that would be generated when trying to access an undefined array key. However, this can make it difficult to identify and fix errors in your code.

Instead of using the error suppression operator, you can check if the key exists in the array before trying to access it. You can use the isset() function to check if a variable is set, and the array_key_exists() function to check if a key exists in an array.

Here is an example of how you can update the code to check for the existence of the key before accessing it:

function CreateSignature()
{
    $sig = "";
    if (isset($_SERVER["HTTP_USER_AGENT"])) {
        $sig .= $_SERVER["HTTP_USER_AGENT"];
    }
    if (isset($_SERVER["HTTP_ACCEPT"])) {
        $sig .= $_SERVER["HTTP_ACCEPT"];
    }
    if (isset($_SERVER["HTTP_ACCEPT_LANGUAGE"])) {
        $sig .= $_SERVER["HTTP_ACCEPT_LANGUAGE"];
    }
    if (isset($_SERVER["HTTP_ACCEPT_CHARSET"])) {
        $sig .= $_SERVER["HTTP_ACCEPT_CHARSET"];
    }
    $this->Signature = md5(Communication::GetIP() . $sig);
}

You can also use the ternary operator to shorten the code

function CreateSignature()
{
    $sig = isset($_SERVER["HTTP_USER_AGENT"]) ? $_SERVER["HTTP_USER_AGENT"] : "";
    $sig .= isset($_SERVER["HTTP_ACCEPT"]) ? $_SERVER["HTTP_ACCEPT"] : "";
    $sig .= isset($_SERVER["HTTP_ACCEPT_LANGUAGE"]) ? $_SERVER["HTTP_ACCEPT_LANGUAGE"] : "";
    $sig .= isset($_SERVER["HTTP_ACCEPT_CHARSET"]) ? $_SERVER["HTTP_ACCEPT_CHARSET"] : "";
    $this->Signature = md5(Communication::GetIP() . $sig);
}

 

[Ratings in database ala Amazon. How many of each?]

You can use a subquery to get the list of all possible ratings and then left join it with your reviews table to get the count of each rating. Here's an example query that should work:

SELECT ratings.rating, COALESCE(reviews.count, 0) as count FROM (
    SELECT DISTINCT rating FROM reviews
) as ratings
LEFT JOIN (
    SELECT rating, COUNT(*) as count FROM reviews GROUP BY rating
) as reviews
ON ratings.rating = reviews.rating

This query first gets a list of all distinct ratings from the reviews table, and then left joins it with a subquery that gets the count of each rating from the reviews table. The COALESCE function is used to replace any NULL values in the count column with 0, in case a rating doesn't have any reviews.

[PHP - Determine File System Type]

This might work for you.
https://linfo.sourceforge.net/

[Php Mysql Remove from one row and add to another. I'm stuck]

This is really no different than what a banking app would do. Instead of money you have tokens. You are going to want to learn about Mysql Transactions.

https://www.mysqltutorial.org/mysql-transaction.aspx

[Get array with local vars only]

I am still not sure what you are doing with out more details, but I am sure that whatever you are attempting to do with the posted code is not the way to do it.

5 hours ago, sen5241b said:

I'm writing a lightweight  data agnostic processing engine

This should be to focus of your post.

5 hours ago, sen5241b said:

It enables user to get items from a data catalog and add to it by simply adding new catalog items.

More details or some third party example is in order at this point. This just sounds like basic database management.

[Get array with local vars only]

What is the problem you are trying to solve by doing this?

[xampp php session files and firefox browser]

Good description of the problem. Now show us your code.

[Ned help to understand this code]

The whole thing should not even be in your code at all. Error reporting setting should be set in php.ini

[db INSERT with try & catch]

@Strider64, you have been posting that insertData function in various forums for some time now. It doesn't work the way you think it does. HINT: Try passing in an array that has "id". 🙂

[How to validate if certain value is duplicate or if certain input field is not filled using PHP AJAX Javascript]

You should not be checking for duplicates. Set a unique constraint on the relevant column and then attempt the insert. Catch the duplicate error if any and handle however you want.

[Retrieve single variable from a function]

<?php

function doThis($num = 4)
{
    for ($i = 0; $i < $num; $i++) {
        $seq[] = $i;
    }
    return $seq;
}

$arr = doThis();

echo $arr[1];
echo $arr[2];
echo $arr[3];

 

[Help with mysqli_fetch_array]

Is BIN actually a Constant? I suspect it is not.
 

$owew[BIN]

 

[Hello! new here. TRying to set up Apache server on my Win11 with Mysql n PHP]

Laragon is the best WAMP currently available.
https://laragon.org/

[db INSERT with try & catch]

3 minutes ago, phppup said:

Isn't something like doing the same thing?

No. You are building in a race condition by checking availability.

[db INSERT with try & catch]

1 hour ago, mac_gyver said:

BTW - getCode() is the sqlstate, which groups together several similar errors, and is not the actual error number.

I was just going to point that out. The if should be

if ($e->getCode() == 23000) { // Duplicate user }

1062 is held in the errorInfo array

[Admin dashboard does not open dropdown to show html links]

1. Stop using the @ error suppressor.
2. Do not put variables in your query. Use Prepared Statements. Your code is vulnerable to an XSS Attack.
3. Never trust user supplied data
4. Stop changing the case of your variables. Just always use lowercase
5. You need to kill the script after a header redirect or the code will keep running that follows.

[Left empty control.]

Why are you adding another array to your post variables/form element names?

[Left empty control.]

Small bit of code but several issues with it.

1. Do not create variables for nothing. You already have the POST variables, just use them
2. You need to check the REQUEST METHOD, not the name of a button. This can completely fail in certain cases. Also, in a properly coded form, ALL form elements save for checkboxes will be submitted (true)
3. A blank space will get past your empty check. You need to trim the entire POST array all at once and THEN check for empty
4. Never ever trust user supplied data. The code is vulnerable to an XSS Attack