paging is not happening

[maviyazilim]

Strider64

thank you.

i don't know pdo

[maviyazilim]

ginerjm

I got all the codes. this error pops up.

Parse error: syntax error, unexpected token "{" in C:\xampp\htdocs\blog\orta.php on line 42

line 42 : {

line41: elseif(isset($_POST['sayfa'])

 

This is the first time I see the use of input tag in pagination construction. Is this how it should be used?

[Barand]

16 minutes ago, maviyazilim said:

barand.

I got the above below. I deleted the query.

this is the result.

 

Fatal error: Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, string given in C:\xampp\htdocs\blog\orta.php:40 Stack trace: #0 C:\xampp\htdocs\blog\orta.php(40): mysqli_fetch_assoc('SELECT * FROM i...') #1 C:\xampp\htdocs\blog\index.php(4): include('C:\\xampp\\htdocs...') #2 {main} thrown in C:\xampp\htdocs\blog\orta.php on line 40

 

line 40 : while($goster=mysqli_fetch_assoc($sorgu)) {

 

You old query stored its results in $sorgu. Your new paginated query stores its results in $result. You need to adjust the code accordingly.

[maviyazilim]

Barand.

problem solved. but I added content for trial purposes. to see if there will be 3 in storage. Substr does not work in the content I added recently. does not shorten. what could cause this?

[Barand]

17 minutes ago, maviyazilim said:

This is the first time I see the use of input tag in pagination construction. Is this how it should be used?

It's one way. IMO< Your original use of <a>...</a> links is probably more common. You can always style the links to resemble buttons. Also, as all you are doing is GETting a new page of data, the convention is to use GET and not POST method. Use POST when the form action causes change - such as logging in or updating a database.

[Barand]

1 minute ago, maviyazilim said:

what could cause this?

I haven't a clue. Imagine I am not psychic and cannot see your screen or your current code.

[maviyazilim]

Barand.

 

 

[maviyazilim]

when I add it later, the substr doesn't work.

[Barand]

3 minutes ago, maviyazilim said:

when I add it later, the substr doesn't work.

What substr? How does that image show your current code? I gave it a second try... enough is enough. Good luck.

[maviyazilim]

Barand.

 

echo substr($goster['yazi'],0,300);

 

shortens the old 16 content. it does not make abbreviations for the 5 contents I added later. it needs to publish the first 300 characters of the post.

[ginerjm]

I left out a trailing parentheses

[maviyazilim]

ginerjm.

thanks. problem solved.

Barand and ginerjm.

thank you both so much

 

 

[ginerjm]

I hope you read thru each of our examples and learn from them.  You have a long ways to go, so here's a good start.

 

PS - you should learn how to use PDO instead of MysqlI

[maviyazilim]

ginerjm

If I manage to learn mysqli, I will learn pdo. thanks for advice. I've read over 20 video lessons for the simplest pagination at the moment. I've been dealing with it for a week or more. I just now solved it. I'm just trying to learn because I have interest and curiosity. I did not receive any school or training related to software. The fact that it was so difficult and challenging for a pagination made me very hard. If I manage to learn php, I try to learn pdo.

[ginerjm]

For someone just starting out you chose a difficult task.  Learning about how php works and the many functions to use is quite enough.  As for learning Mysqli first - IMHO you are better off stopping that and moving to PDO.  A much better interface and IMO a much simpler one.

[maviyazilim]

ginerjm

google translate did not translate.

google translate did not translate. What is IMHO What is IMO

[Barand]

In my (humble) opinion.

I agree wholeheartedly with the above opinions on PDO

Edited September 29, 2021 by Barand

[ginerjm]

"In My Humble Opinion"   and "In My Opinion"

Sorry

[maviyazilim]

ginerjm

thank you.

 

[ginerjm]

Hope you learn a lot from our efforts to help you.  Good luck!