Php while in a function code?

Question

I am trying this function it is possible please help me.

My code sample:

# Here is my select query
$con = mysqli_connect('localhost', 'root', '', 'test_database');
$select = "SELECT * FROM test_posts";
$select_query = mysqli_query($con, $select);

# Here is my function query
function getPosts() {
    global $con;
    global $select;
    global $select_query;
    $post = mysqli_fetch_array($select_query);
}

# Here is my homepage get posts method

while (getPosts()) {

 # I am triying this method and tried define, and echo but not working

 echo $post['sample_content'];

}

I am tried define('sample', '$post = mysqli_fetch_array($sample)'); but not worked.

Where is my mistake? How I should do this?

do you specifically need this getPosts() function? you can do an easy workaround using: while($post = mysqli_fetch_array($select_query) { .... } — Mart
– Mart, Commented Jul 11, 2018 at 19:43
$post only exists within the function. Return it, then define it as $post = getPosts() — aynber
– aynber, Commented Jul 11, 2018 at 19:46

Alihossein shahabi · Accepted Answer · 2018-07-11 20:05:02Z

2

I run your code but I change some line :

this is my test_posts table :

| sample_content | id |
|:--------------:|:--:|
|      test1     |  1 |
|      test2     |  2 |

and I add return $post; in getPosts function For sending records to while.

also used ‍‍$post=getPosts() instead of getPosts() to print the values insidewhile.

return:

test1 test2 finish

my code :

<?php

# Here is my select query
$con = mysqli_connect('localhost', 'phpmyadmin', '123456', 'test');
if (mysqli_connect_errno())
{
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$select = "SELECT * FROM test_posts";
$select_query = mysqli_query($con, $select);

# Here is my function query
function getPosts() {
    global $con;
    global $select;
    global $select_query;
    $post = mysqli_fetch_array($select_query);
    return $post;
}

# Here is my homepage get posts method

$post=[];
while ($post=getPosts()) {

    # I am triying this method and tried define, and echo but not working

    echo $post['sample_content'];

}

echo 'finish';

edited Jul 11, 2018 at 20:05

answered Jul 11, 2018 at 19:50

Alihossein shahabi

4,3923 gold badges39 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

13 Comments

John Conde Over a year ago

"Try this" does not make for a good answer. You should explain how and why this solves their problem. I recommend reading, "How do I write a good answer?"

Mart Over a year ago

i agree with @JohnConde and could you also elaborate on the $post=[] ?

Ramazan Alkan Over a year ago

Thanks but this is giving nothing. :)

Alihossein shahabi Over a year ago

Sorry. I'm explaining it now @JohnConde

Alihossein shahabi Over a year ago

@RamazanAlkan test again please

|

Barmar · Accepted Answer · 2018-07-11 20:29:59Z

1

You can do this by making getPosts() a generator function.

function getPosts() {
    global $select_query;
    while ($post = mysqli_fetch_array($select_query)) {
        yield $post;
    }
}

Then you can use it in a foreach loop:

foreach (getPosts() as $post) {
    echo $post['sample_content'];
}

It would be better to make $select_query a parameter of the function rather than using a global variable.

answered Jul 11, 2018 at 20:29

Barmar

789k57 gold badges554 silver badges669 bronze badges

Comments

Mart · Accepted Answer · 2018-07-11 19:47:15Z

0

I'm not sure if you're asking to make this work using this specific getPosts() function or you need this to work anyhow. If so you can do it as such:

# Here is my select query
$con = mysqli_connect('localhost', 'root', '', 'test_database');
$select = "SELECT * FROM test_posts";
$select_query = mysqli_query($con, $select);


while ($post = mysqli_fetch_array($select_query)) {


 echo $post['sample_content'];

}

answered Jul 11, 2018 at 19:47

Mart

5446 silver badges26 bronze badges

4 Comments

Ramazan Alkan Over a year ago

I now this but I need function method I am triying new method

Mart Over a year ago

i agree with @IncredibleHat ... WHY :D

Ramazan Alkan Over a year ago

I don't now :) really I am trying this like 5 hours I want it!

IncredibleHat Over a year ago

"wordpress" ... ok, I'm out.

Collectives™ on Stack Overflow

Php while in a function code?

3 Answers 3

13 Comments

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

13 Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related