How to remove query string form url and rename the url on PHP?

Question

0.00/5 (No votes)

See more:

I have this code in fliters.php:

<div class="boxed1 mb-3">
  <h5 class="text-center" style="padding-top: 15px;">Categories</h5>
  <hr>

    <?php if(substr($_SERVER["SCRIPT_NAME"],strrpos($_SERVER["SCRIPT_NAME"],"/")+1) == "all-products.php"){ ?>

    <h6 style="margin-left: 10px;">All Products</h6>

  <?php }else{ ?>

    <h6 style="margin-left: 10px;"><a href="all-products">All Products</a></h6>

  <?php }
      $sql1 = $db->prepare("SELECT * FROM categories WHERE id IN (SELECT parent FROM categories) AND parent = ? AND deleted = ?");
      $sql1->bind_param('ii', $var0, $var0);
      $sql1->execute();
      $result1 = $sql1->get_result();
      while($row1 = mysqli_fetch_assoc($result1)){
  ?>

  <h6 style="margin-left: 10px;"><a href="main-category?cat=<?=$row1['id'];?>"><?=$row1['category'];?></a></h6>

  <?php
  $sql2 = $db->prepare("SELECT * FROM categories WHERE parent IN (SELECT id FROM categories) AND parent = ? AND deleted = ?");
  $sql2->bind_param('ii', $row1['id'], $var0);
  $sql2->execute();
  $result2 = $sql2->get_result();
  while($row2 = mysqli_fetch_assoc($result2)){ ?>

    <h6 style="margin-left: 25px;"><a href="sub-category?cat=<?=$row2['id'];?>"><?=$row2['category'];?></a></h6>

  <?php }
      }
      $sql3 = $db->prepare("SELECT categories.*
                            FROM categories
                            INNER JOIN
                            products
                            WHERE categories.id
                            NOT IN (SELECT categories.parent FROM categories)
                            AND categories.parent = ?
                            AND categories.deleted = ?
                            AND products.category = categories.id");
      $sql3->bind_param('ii', $var0, $var0);
      $sql3->execute();
      $result3 = $sql3->get_result();
      while($row3 = mysqli_fetch_assoc($result3)){
      ?>

      <h6 style="margin-left: 10px;"><a href="sub-category?cat=<?=$row3['id'];?>"><?=$row3['category'];?></a></h6>

    <?php } ?>

</div>

and this code in main-category.php:

<?php
  require_once 'init.php';
  include 'includes/head.php';
  include 'includes/navigation.php';

  $arr = array();
  $sql = $db->prepare("SELECT * FROM categories WHERE parent = ? AND deleted = ?");
  $sql->bind_param('ii', $_GET['cat'], $var0);
  $sql->execute();
  $result = $sql->get_result();
  while($row = mysqli_fetch_assoc($result)){
  $arr[] = $row['id'];
 }
  $test = implode(",", $arr);
  $array = array_map('intval', explode(',', $test));
  $array = implode("','", $array);
  $query = $db->query("SELECT * FROM products WHERE category IN ('$array') AND archived = 0 ORDER BY name");
  ?>

  <!-- Main Content -->
  <div class="container-fluid" style="margin-top:45px;">
    <div class="row">
      <div class="col-lg-2">

        <?php include 'includes/filters.php'; ?>

      </div>
      <div class="col-lg-1"></div>
      <div class="col-lg-8">

        <?php
          $catSql = $db->prepare("SELECT * FROM categories WHERE id = ?");
          $catSql->bind_param('i', $_GET['cat']);
          $catSql->execute();
          $result7 = $catSql->get_result();
          $childs = mysqli_fetch_assoc($result7);
          $pSql = $db->prepare("SELECT * FROM categories WHERE id = ?");
          $pSql->bind_param('i', $childs['parent']);
          $pSql->execute();
          $result20 = $pSql->get_result();
          $parents = mysqli_fetch_assoc($result20);
          ?>
          <h6 id="backcolor2">
          <nav>
            <ol class="breadcrumb justify-content-center">
              <li class="breadcrumb-item"><a href="index">Home</a></li>
              <li class="breadcrumb-item"><a href="all-products">Products</a></li>
            <li class="breadcrumb-item"><?=$childs['category'];?></li>
          </ol>
        </nav>
      </h6>
        <br>
        <div class="row row-cols-1 row-cols-md-4 g-4">

          <?php while($row2 = mysqli_fetch_assoc($query)) : ?>

            <div class="col d-flex align-items-stretch">
              <div class="card">
                <img src="<?=explode('/', $_SERVER['PHP_SELF'])[1].'/'.$row2['image'];?>" class="card-img-top">
                <div class="card-body text-center">
                  <h6 class="card-title mb-3"><?=$row2['name'];?></h6>
                  <a href="products?details=<?=$row2['id'];?>" class="btn btn-sm btn-success button_hover stretched-link">Details</a>
                </div>
              </div>
            </div>

          <?php endwhile; ?>

    </div>
  </div>
  </div>
  </div>

Now the main categories are listed in the filters

<h6 style="margin-left: 10px;"><a href="main-category?cat=<?=$row1['id'];?>"><?=$row1['category'];?></a></h6>

and when I press on one of them the url will appear like this:
https://test.com/main-category?cat=72
I need to change the url to appear like this example:
https://test.com/hair-care-categories

What I have tried:

How can I do this? What should I edit in the code above?

Posted 16-Jun-23 22:16pm

FRS4002

Updated 17-Jun-23 1:31am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andre Oosthuizen · Answer 1 · 2023-06-17T01:31:00

Solution 1

Quote:
What should I edit in the code above?

You have shown no code that might lead to a URL rename so there is nothing to edit. Normally I will not assist with no effort shown but luckily I had a code piece on this from before...

Make use of PHP's 'parse_url()' method to achieve the desired outcome - parse_url [^] as well as the 'http_build_query()' method - http_build_query [^]

The below code allow for any changes in your 'cat' returned values, so any value will be concatenated with during the url rebuild to output the correct page and values -

// Current URL
$currentURL = 'https://test.com/main-category?cat=72';

// Remove query string
$parsedURL = parse_url($currentURL);
$baseUrl = $parsedURL['scheme'] . '://' . $parsedURL['host'] . $parsedURL['path'];

// Rename the URL
$newPath = '/hair-care-categories';
$newQuery = '';

// Get the query string parameters
if (isset($parsedURL['query'])) {
    parse_str($parsedURL['query'], $queryArray);

    // Remove the 'cat' parameter
    unset($queryArray['cat']);

    // Build the new query string
    $newQuery = http_build_query($queryArray);
}

// Combine the new path and query string
if ($newQuery) {
    $newURL = $baseUrl . $newPath . '?' . $newQuery;
} else {
    $newURL = $baseUrl . $newPath;
}

// Output the renamed URL
echo $newURL;

I ran this code in W3Schools PHP Editor [^] and the new URL returned fine.

Posted 17-Jun-23 1:31am

Andre Oosthuizen

Comments

FRS4002 17-Jun-23 8:04am

hair-care-categories is just an example... hair-care-categories is dynamic and coming from the database so it could be other than hair-care-categories.

Andre Oosthuizen 17-Jun-23 11:54am

Well, that's easy enough then -

$newPath = '/hair-care-categories'; //should become 
$newPath = '/' .$My_Value_returned_From_Database;

FRS4002 17-Jun-23 15:02pm

Thanks for the clarification. But where should I put these codes? Is it in filters.php or in main-category.php? As I said before, this code:

<h6 style="margin-left: 10px;"><a href="main-category?cat=<?=$row1['id'];?>"><?=$row1['category'];?></a></h6>

is in filters.php that leads to main-category.php page... I should add/edit some code in this line above so it leads to what you said above...

Andre Oosthuizen 18-Jun-23 5:12am

In filters.php. I suggest that you read up on the links that I have supplied, you are now just copying and pasting code without knowing how why we use it or what it's functions are. Once you understand what it does, you will also know where to use the code. By reading the code comments as well, you should be able to work out what each line is for and then where to use it.

FRS4002 18-Jun-23 8:59am

Yeah, I understand the code and I applied the code in filters.php and it changed the URL. Now how to receive the new URL in main-category.php ? In other words, how main-category.php page will receive the new URL so it opens? Because, when I click on the link it says internal error.

Andre Oosthuizen 18-Jun-23 12:58pm

You need to use redirect method -

header("Location:" .$newURL);

FRS4002 19-Jun-23 1:14am

I added header("Location:" .$newURL); at the beginning of the page of main-category.php, but I still getting Internal Server Error. Here is the code of filters.php just in case:

      $sql1 = $db->prepare("SELECT * FROM categories WHERE id IN (SELECT parent FROM categories) AND parent = ? AND deleted = ?");
      $sql1->bind_param('ii', $var0, $var0);
      $sql1->execute();
      $result1 = $sql1->get_result();
      while($row1 = mysqli_fetch_assoc($result1)){
      $currentURL = "https://test.com/main-category?cat=".$row1['id'];
      $parsedURL = parse_url($currentURL);
      $baseUrl = $parsedURL['scheme'] . '://' . $parsedURL['host'] . $parsedURL['path'];
      $newPath = "/".str_replace(' ', '-', strtolower($row1['category']));;
      $newQuery = '';
      if(isset($parsedURL['query'])){
        parse_str($parsedURL['query'], $queryArray);
        unset($queryArray['cat']);
      $newQuery = http_build_query($queryArray);
 }
if($newQuery){
    $newURL = $baseUrl . $newPath . '?' . $newQuery;
    }else{
    $newURL = $baseUrl . $newPath;
}
  ?>

  <h6 style="margin-left: 10px;"><a href="<?=$newURL;?>"><?=$row1['category'];?></a></h6>

Of course, I replaced test with my domain. In the address bar the URL has changed... But there is no content with Internal Server Error. Maybe I need to receive the query string value in main-category.php, but how this can be done?

Andre Oosthuizen 19-Jun-23 5:01am

You need to realize that I cannot see your screen, so I assume that the code in the solution I supplied is for 'filter.php' as you never specified which is which. Until then we are going to go around in circles. I can however tell you that your code is incorrect by stating "header("Location:" .$newURL); at the beginning of the page of main-category.php", it shows that you do not understand re-directing of and to pages as you are suppose to use the 'Location:" .$newURL' in your filter page, telling it to go to main-category page (If I understand your file page system now...? Read up more on redirect in php from - A PHP redirect is a server-side redirect that quickly redirects users from one web page to another.[^].

To your solution now - you cannot add $newUrl in your H6 element as you already used the element to read your 'old' URL where the catId is obtained. So, use my code sample above and at teh end of the code you add the re-direct -

// Output the renamed URL
//echo $newURL;
header("Location:" .$newURL);

FRS4002 20-Jun-23 4:43am

filters.php is a page inside another page called all-products.php. filters.php is not really a page but it is just contains a list of main categories and sub categories in a box in the left side of all-products.php page. So, user can click on a main category and it leads to a page like:

https://test.com/main-category?cat=72

this appears in the url that has the products of this main category according to the id which is here cat=72. So, header("Location:" .$newURL); didn't work there.