Click here to Skip to main content
15,177,966 members
Home / Discussions / Database
   

Database

 
QuestionRe: How much difference is there between SQL server 2008 and 2012 Pin
CHill602-Nov-21 1:10
mveCHill602-Nov-21 1:10 
AnswerRe: How much difference is there between SQL server 2008 and 2012 Pin
jkirkerx2-Nov-21 8:45
professionaljkirkerx2-Nov-21 8:45 
QuestionArray Issue Pin
MekaC24-Oct-21 18:59
MemberMekaC24-Oct-21 18:59 
AnswerRe: Array Issue Pin
Richard Deeming24-Oct-21 23:05
mveRichard Deeming24-Oct-21 23:05 
GeneralRe: Array Issue Pin
MekaC25-Oct-21 12:13
MemberMekaC25-Oct-21 12:13 
AnswerRe: Array Issue Pin
Richard MacCutchan24-Oct-21 23:07
mveRichard MacCutchan24-Oct-21 23:07 
GeneralRe: Array Issue Pin
MekaC25-Oct-21 12:14
MemberMekaC25-Oct-21 12:14 
AnswerRe: Array Issue Pin
jkirkerx28-Oct-21 10:04
professionaljkirkerx28-Oct-21 10:04 
Your pretty far off with your code, and I'm not sure which version of PHP your using. Plus your code is very primitive and not object oriented like for PHP versions 7 and up. You have to create a db connector as a class and call that db connector. Then create a query. Next run that query with the db connector which creates a result. The result can be false if nothing comes back, or can be a array of records in which you fetch them. Finally you call that array that was returned and convert them to rows.

I packed the rows into an object that I created, and return the object instead of an array. The code your writing is very the year 2000, and is quite old and outdated. Nobody in western democracies are writing code like that anymore.

PHP 7.4 example, what you should be learning.
Hope that helps you, and PHP Storm by Jet Brains is the preferred editor or IDE for PHP.
<br />
public static function getUsers(): Users {

        $users = new Users();

        $query = "
        SELECT 
               uid, 
               Username<br />
        FROM [user]
        WHERE User_type <> 'xxxxxxx' 
        ORDER BY Username";

        $conn = DbConnectRepository::createConn();
        $result = sqlsrv_query($conn, $query) or die(" getUsers " . LINE . " - " . $query . ' - ' . print_r(sqlsrv_errors()));
        while ($row = sqlsrv_fetch_array($result)) {

            $user = new User();
            $user->setUserId($row[0]);
            $user->setUserName($row[1]);<br />
            $users->add($user);

        }

        return $users;

    }
If it ain't broke don't fix it
Discover my world at jkirkerx.com

QuestionLooking for feedback and contributions to database project Pin Pin
Michael Sydney Balloni17-Oct-21 14:06
mvaMichael Sydney Balloni17-Oct-21 14:06 
QuestionHow to write stored procedure in mysql workbench. SELECT, INSERT, UPDATE,DELETE Pin
Member 1539388914-Oct-21 1:05
MemberMember 1539388914-Oct-21 1:05 
AnswerRe: How to write stored procedure in mysql workbench. SELECT, INSERT, UPDATE,DELETE Pin
Richard MacCutchan14-Oct-21 1:33
mveRichard MacCutchan14-Oct-21 1:33 
AnswerRe: How to write stored procedure in mysql workbench. SELECT, INSERT, UPDATE,DELETE Pin
CHill6022-Oct-21 1:08
mveCHill6022-Oct-21 1:08 
Questionremove Pin
Member 1489067811-Oct-21 21:23
MemberMember 1489067811-Oct-21 21:23 
AnswerRe: Sql Match Pin
OriginalGriff11-Oct-21 21:24
mveOriginalGriff11-Oct-21 21:24 
Question[Resolved] Need Help with this SQL Statement Pin
crmfghtr5-Oct-21 15:24
Membercrmfghtr5-Oct-21 15:24 
AnswerRe: Need Help with this SQL Statement Pin
Richard Deeming5-Oct-21 22:48
mveRichard Deeming5-Oct-21 22:48 
GeneralRe: Need Help with this SQL Statement Pin
crmfghtr6-Oct-21 3:37
Membercrmfghtr6-Oct-21 3:37 
GeneralRe: Need Help with this SQL Statement Pin
Richard Deeming6-Oct-21 4:36
mveRichard Deeming6-Oct-21 4:36 
GeneralRe: Need Help with this SQL Statement Pin
Eddy Vluggen8-Oct-21 16:23
professionalEddy Vluggen8-Oct-21 16:23 
General[Resolved] Re: Need Help with this SQL Statement Pin
crmfghtr10-Oct-21 17:18
Membercrmfghtr10-Oct-21 17:18 
QuestionImport CSV Problems Pin
Jörgen Andersson3-Oct-21 22:32
professionalJörgen Andersson3-Oct-21 22:32 
AnswerRe: Import CSV Problems Pin
Mycroft Holmes4-Oct-21 13:12
professionalMycroft Holmes4-Oct-21 13:12 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson4-Oct-21 21:24
professionalJörgen Andersson4-Oct-21 21:24 
AnswerRe: Import CSV Problems Pin
CHill604-Oct-21 22:04
mveCHill604-Oct-21 22:04 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson4-Oct-21 22:13
professionalJörgen Andersson4-Oct-21 22:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.