PHP Simple Program with ADD, UPDATE and DELETE

Question

1.00/5 (1 vote)

See more:

Dear Experts,

Could you please provide sample PHP coding for following url? It will be a great help. Thanks!

http://power.arc.losrios.edu/~leeverc/php/booksassignment/books.php?choice=genre[^]

Posted 9-Nov-13 17:40pm

abdulsafran

Add a Solution

Comments

enhzflep 9-Nov-13 23:54pm

At CodeProject this question is unlikely to be considered reasonable.
What have you tried, where are you stuck?

Break the problem down into manageable chunks and solve them one by one.
There are many chunks or pieces involved in this question, there are also many tutorials that will address some if not all of them.

abdulsafran 10-Nov-13 9:39am

Thanks enhzflep, I'll check this and if there any problem. I'll get back to you.

enhzflep 10-Nov-13 11:55am

You're welcome abdulsafran.

I don't hand-out fish when asked, though I do try to teach people to fish. If someone asks to be taught how to fish, it's not uncommon that I'll give them a fish while I'm at it.

Networking with people is important. As a software developer, the ability to research is paramount. You can get answers by asking people, but understanding and true mastery comes from an inquiring mind.

Seek and you shall find. When faced with a specific problem, come back and ask - most here will really try hard to help you overcome a hurdle. But they wont carry your through the whole race.

I hope you understand there are no hard feelings.

Best regards. :)

abdulsafran 10-Nov-13 14:37pm

Hi enhzflep, Below is my code. Once click the Title, Address bar of the browser will be changed to books.php?choice=title. My problem is I need to run sort this table from title, so I want to add sort title php code inside this single php file. I need like header = books.php?choice=title then run the code else below code. Please help me.

abdulsafran 10-Nov-13 14:38pm

if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$result = mysqli_query($con,"SELECT * FROM authors a, books b, publish p where p.authorid=a.authorid and p.bookid=b.bookid");

echo "<table border='1'>
<tr><th colspan='7'>Add Book |
Add Author</td></tr>
<tr>
<th>Title</th>
<th>Author Name</th>
<th>Genre</th>
<th>Country</th>
</tr>";

while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['title'] . "</td>";
echo "<td>" . $row['fname'] . "</td>";
echo "<td>" . $row['genre'] . "</td>";
echo "<td>" . $row['country'] . "</td>";
echo "</tr>";
}
echo "</table>";

mysqli_close($con);
?>

enhzflep 10-Nov-13 14:56pm

Hi abdulsafran.
I'd actually already written you a reply when I realized you'd deleted both of the comments. I'll just re-post mine. The key-point is <ode>ORDER BY title ASC is added to the SQL. (ASC = ascending, DESC = descending)

---Original comment follows-----------------------------------------------------
Ah, that's looking better. :)

Lets see then. As far as I can tell from your small snippet of code, you can actually achieve what you want by changing your SQL a little bit.

I suppose that your current SQL resembles this:

$sqlStr = "select * from books";

While you'd like it sorted, based on the 'title' field. In that case, you could use the following:

$sqlStr = "select * from books ORDER BY title ASC"

Of course, using mySqli, you may have parameterized your query (got mySqli to make certain the input isn't a SQL injection risk.)

Now then, I imagine that you'd like to be able to sort by any column.
You could do something like the following:

$sortField = $_GET['choice'];
$sqlStr = "select * from books";

if (isset($sortField))
{
$sqlStr += " ORDER BY $sortField ASC";
}

This assumes that the value of 'choice' is the exact name of one of your columns. You'd be better-off checking the passed value with a switch block - it's just easier for me to type out this way and describe the necessary changes.

abdulsafran 10-Nov-13 15:08pm

Thanks for your prompt response, can you do the modification in my code please? It will help me a lot to get the exact idea. I open new question in following url, it will clear what I'm exactly asking, please click PHP codes in one page to display

enhzflep 10-Nov-13 15:28pm

You're welcome. To repeat what I said earlier

"I don't hand-out fish when asked, though I do try to teach people to fish."

Earlier, you asked for help to achieve a part of it, showed your efforts. I tried to answer this question and discussed 2 methods to do the sorting, based on user input. A lesson and a tuna sandwich, you might say. However this request I view as a direct request for fish (which I wont supply or support) I will however, help if I am able when you demonstrate a little more work.

I'm going to bed now and will have another look at your question after I wake.
You can always open myPhpAdmin in a browser and run some queries manually to ensure your SQL returns the result-set you want. After that's returning the result set you like, you can look at responding to data retrieved via $_GET

Regards.

abdulsafran 10-Nov-13 23:29pm

Brother, I know how to sort it, but I need once title click my sort code should run like in the following link: http://power.arc.losrios.edu/~leeverc/php/booksassignment/books.php?choice=genre, I can do it like set another php page in a href, but I need to do it in single php. The whole should be in one php.

enhzflep 11-Nov-13 0:34am

Ah well in that case, PHP alone may not be enough. If you want to sort the data without requesting a new (the same, but with a different argument) PHP page, you'll have to sort the table using javascript OR request the data again from the PHP page using AJAX, before overwriting the old data with the new.

So, which would you like assistance with?

(a) Clicking header causes PHP page to be requested again, with a different value of choice. (address bar changes to reflect new choice)
(b) Clicking header causes AJAX request for PHP page, again with a different value of choice. (address bar remains the same)
(c) Sort the existing table on the client machine, using Javascript. (address bar stays unchanged)

I'm just not sure which way you'd like to go! Let me know and I'll try to guide you. :)

abdulsafran 11-Nov-13 2:54am

I'm going with option (a), but I need to do it in single php file like this: If header = this, this code, else that code. That's all.

Peter Leow 10-Nov-13 0:27am

The answer to your question will require more than just sample code. It is a small-scale web development project by itself. Minimally, you will need a database, SQL, client-side scripting (HTML, JavaScript, etc), and server-side scripting (PHP, ASP.NET, or JSP). All these are to be integrated and work as a whole. Nevertheless, that gives me some ideas for my future article.

abdulsafran 10-Nov-13 9:39am

Thanks Peter, I'll check this and if there any problem, I'll get back to you.

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)

enhzflep · Answer 1 · 2013-11-10T22:34:00

Alright then. Since I seem to be doing more work on this than you do, I'll pass you this code and leave it at that. You can adapt it from now on to suit your own needs.

There's all kinds of ways you could do it. I just realized the most obvious way as I was about to paste a much larger snippet. Oh well, :sighs: mental gymnastics are good for us! Naturally, you could remove each instance of "\t\t\t\t" - you could also un-indent the other html tags too. I just prefer nice indentation (although it does make the page a little larger - for no benefit unless you view-source)

Any-who..

XML

<!DOCTYPE html>
<html>
    <head>
        <style>
            tr.sortStuff th:hover{background-color: rgb(200,200,200);}
            tr.addStuff th:hover{background-color: rgb(200,255,200);}
        </style>
        <script>
        </script>
    </head>
    <body>
    <table>
        <thead>
            <tr class='addStuff'>
                <th colspan='7'>Add Book | Add Author</th>
            </tr>

            <tr class='sortStuff'>
                <th><a href='<?php echo $_SERVER["PHP_SELF"]?>?order=title'>Title</th>
                <th><a href='<?php echo $_SERVER["PHP_SELF"]?>?order=author'>Author Name</th>
                <th><a href='<?php echo $_SERVER["PHP_SELF"]?>?order=genre'>Genre</th>
                <th><a href='<?php echo $_SERVER["PHP_SELF"]?>?order=country'>Country</th>
            </tr>
        </thead>
        <tbody>
<?php
/*
$sortField = $_GET['order'];
if (mysqli_connect_errno())
  {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
  $sqlStr = "SELECT * FROM authors a, books b, publish p where p.authorid=a.authorid and p.bookid=b.bookid";
  if (isset($sortField))
    $sqlStr += " ORDER BY $sortField ASC";
  $result = mysqli_query($con, $sqlStr);

while($row = mysqli_fetch_array($result))
  {
  echo "\t\t\t\t<tr>";
  echo "\t\t\t\t<td>" . $row['title'] . "</td>";
  echo "\t\t\t\t<td>" . $row['fname'] . "</td>";
  echo "\t\t\t\t<td>" . $row['genre'] . "</td>";
  echo "\t\t\t\t<td>" . $row['country'] . "</td>";
  echo "\t\t\t\t</tr>";
  }
mysqli_close($con);
*/
?>      </tbody>
    </table>
    </body>
</html>