PHP Mga IT Gods Need your help

M H I N Y E · Jun 26, 2022

IT Gods Need your help on how to solve this

My problem is that only the Administrator and staff lng ang ma didisplay sa user type. gusto ko lang po sana na kung alin ang senilect kng user type ay yung din sana ma display sa usertype. yun lng po mga mster sana matulungan THANKS IN ADVANCE

PHP:

ito po ung code nya kaya admin and staff lng ang display
feel ko dito lng ata galawin pero kahit anong try ko hindi ko makuha

<td ><p class="m-0"><?php echo ($row['type'] == 1 )? "Adminstrator" : "Staff" ?></p></td>

PHP:

Ito naman po ung code for selecting user type

<div class="form-group col-6">
                    <label for="type">User Type</label>
                    <select name="type" id="type" class="custom-select"  required>
                        <option value="1" <?php echo isset($meta['type']) && $meta['type'] == 1 ? 'selected': '' ?>>Administrator</option>
                        <option value="2" <?php echo isset($meta['type']) && $meta['type'] == 2 ? 'selected': '' ?>>Staff</option>
                        <option value="3" <?php echo isset($meta['type']) && $meta['type'] == 3 ? 'selected': '' ?>>Process Owner</option>
                        <option value="4" <?php echo isset($meta['type']) && $meta['type'] == 4 ? 'selected': '' ?>>Auditor</option>
                        <option value="5" <?php echo isset($meta['type']) && $meta['type'] == 5 ? 'selected': '' ?>>Auditor Lead</option>
                        <option value="6" <?php echo isset($meta['type']) && $meta['type'] == 6 ? 'selected': '' ?>>QAH</option>
                        <option value="7" <?php echo isset($meta['type']) && $meta['type'] == 7 ? 'selected': '' ?>>Team Management</option>
                        <option value="8" <?php echo isset($meta['type']) && $meta['type'] == 8 ? 'selected': '' ?>>Human Resource</option>
                    </select>
                </div>

ito pala user type attribute

mrhero05 · Jun 26, 2022

use jquery boss para sa no refresh page na pag geget ng data sa database

M H I N Y E · Jun 26, 2022

mrhero05 said:
use jquery boss para sa no refresh page na pag geget ng data sa database

pano yan hahah

Misanthropy · Jun 26, 2022

magkaiba po ba ng file yan o nasa iisang php file lang po

M H I N Y E · Jun 26, 2022

L-Prime said:
magkaiba po ba ng file yan o nasa iisang php file lang po

magkaiba papi

Misanthropy · Jun 26, 2022

yung $meta['type'] po ba yan yung user type attribute po

M H I N Y E · Jun 26, 2022

nag try ako ganto lumabas awit

PHP:

<td >
                                <p class="m-0">
                                    <?php echo ($row['type'] == 1 )? "Adminstrator" : "Staff" ?>
                                    <?php echo ($row['type'] == 2 )? "Adminstrator" : "Staff" ?>
                                    <?php echo ($row['type'] == 3 )? "Adminstrator" : "Staff" ?>
                                    <?php echo ($row['type'] == 4 )? "Adminstrator" : "Staff" ?>
                                    <?php echo ($row['type'] == 5 )? "Adminstrator" : "Staff" ?>
                                    <?php echo ($row['type'] == 6 )? "Adminstrator" : "Staff" ?>
                                    <?php echo ($row['type'] == 7 )? "Adminstrator" : "Staff" ?>
                                    <?php echo ($row['type'] == 8 )? "Adminstrator" : "Staff" ?>
                                </p>
                            </td>

L-Prime said:
yung $meta['type'] po ba yan yung user type attribute po

yan po ung mga mga user type

mrhero05 · Jun 26, 2022

Ang gusto mo ba is ganito? (meron kang data sa database ng usertype tapos sa combo box kung ano man piliin nya gusto mo yun lang lalabas parang sort ganon ba?)

M H I N Y E · Jun 26, 2022

mrhero05 said:
Ang gusto mo ba is ganito? (meron kang data sa database ng usertype tapos sa combo box kung ano man piliin nya gusto mo yun lang lalabas parang sort ganon ba?)

yes po

mrhero05 said:
Ang gusto mo ba is ganito? (meron kang data sa database ng usertype tapos sa combo box kung ano man piliin nya gusto mo yun lang lalabas parang sort ganon ba?)

ganto po ksi itsura nyan

for example select ko yung auditor na user type tapos ang makalagay is staff parin

mrhero05 · Jun 26, 2022

Geuru said:
yes po

Ganto po sagot dyan, una ilagay mo po sa variable yung value ng selected combo box , tapos po sa table po ng view mo, mag query kalang ng select * where usertype = 'variablengselectedcombobox' tas i view mo na po sya sa table mo po

Geuru said:
yes po

ganto po ksi itsura nyan
View attachment 1997602
for example select ko yung auditor na user type tapos ang makalagay is staff parin
View attachment 1997604

ay ok gets gets, ang gusto mo lang pala is ilagay na value kay user type is yung selected sa combo box ganon ba? parang insert palang pala sya?

M H I N Y E · Jun 26, 2022

mrhero05 said:
Ganto po sagot dyan, una ilagay mo po sa variable yung value ng selected combo box , tapos po sa table po ng view mo, mag query kalang ng select * where usertype = 'variablengselectedcombobox' tas i view mo na po sya sa table mo po

ay ok gets gets, ang gusto mo lang pala is ilagay na value kay user type is yung selected sa combo box ganon ba?

oo yan paps

mrhero05 · Jun 26, 2022

Geuru said:
oo yan paps

ok hindi po kita ispoonfeed , ganto po , patingin ng code mo sa pag insert

M H I N Y E · Jun 26, 2022

mrhero05 said:
ok hindi po kita ispoonfeed , ganto po , patingin ng code mo sa pag insert

insert ng ano paps

mrhero05 · Jun 26, 2022

Geuru said:
insert ng ano paps

netong form papuntang database mo

M H I N Y E · Jun 26, 2022

mrhero05 said:
netong form papuntang database mo

PHP:

<?php
if(isset($_GET['id']) && $_GET['id'] > 0){
    $user = $conn->query("SELECT * FROM users where id ='{$_GET['id']}'");
    foreach($user->fetch_array() as $k =>$v){
        $meta[$k] = $v;
    }
}
?>
<?php if($_settings->chk_flashdata('success')): ?>
<script>
    alert_toast("<?php echo $_settings->flashdata('success') ?>",'success')
</script>
<?php endif;?>
<div class="card card-outline card-primary">
    <div class="card-body">
        <div class="container-fluid">
            <div id="msg"></div>
            <form action="" id="manage-user">   
                <input type="hidden" name="id" value="<?php echo isset($meta['id']) ? $meta['id']: '' ?>">
                <div class="form-group col-6">
                    <label for="name">First Name</label>
                    <input type="text" name="firstname" id="firstname" class="form-control" value="<?php echo isset($meta['firstname']) ? $meta['firstname']: '' ?>" required>
                </div>
                <div class="form-group col-6">
                    <label for="name">Last Name</label>
                    <input type="text" name="lastname" id="lastname" class="form-control" value="<?php echo isset($meta['lastname']) ? $meta['lastname']: '' ?>" required>
                </div>
                <div class="form-group col-6">
                    <label for="username">Username</label>
                    <input type="text" name="username" id="username" class="form-control" value="<?php echo isset($meta['username']) ? $meta['username']: '' ?>" required  autocomplete="off">
                </div>
                <div class="form-group col-6">
                    <label for="password">Password</label>
                    <input type="password" name="password" id="password" class="form-control" value="" autocomplete="off" <?php echo isset($meta['id']) ? "": 'required' ?>>
                    <?php if(isset($_GET['id'])): ?>
                    <small class="text-info"><i>Leave this blank if you dont want to change the password.</i></small>
                    <?php endif; ?>
                </div>
                <div class="form-group col-6">
                    <label for="type">User Type</label>
                    <select name="type" id="type" class="custom-select"  required>
                        <option value="1" <?php echo isset($meta['type']) && $meta['type'] == 1 ? 'selected': '' ?>>Administrator</option>
                        <option value="2" <?php echo isset($meta['type']) && $meta['type'] == 2 ? 'selected': '' ?>>Staff</option>
                        <option value="3" <?php echo isset($meta['type']) && $meta['type'] == 3 ? 'selected': '' ?>>Process Owner</option>
                        <option value="4" <?php echo isset($meta['type']) && $meta['type'] == 4 ? 'selected': '' ?>>Auditor</option>
                        <option value="5" <?php echo isset($meta['type']) && $meta['type'] == 5 ? 'selected': '' ?>>Auditor Lead</option>
                        <option value="6" <?php echo isset($meta['type']) && $meta['type'] == 6 ? 'selected': '' ?>>QAH</option>
                        <option value="7" <?php echo isset($meta['type']) && $meta['type'] == 7 ? 'selected': '' ?>>Team Management</option>
                        <option value="8" <?php echo isset($meta['type']) && $meta['type'] == 8 ? 'selected': '' ?>>Human Resource</option>
                    </select>
                </div>
                <div class="form-group col-6">
                    <label for="" class="control-label">Avatar</label>
                    <div class="custom-file">
                      <input type="file" class="custom-file-input rounded-circle" id="customFile" name="img" onchange="displayImg(this,$(this))">
                      <label class="custom-file-label" for="customFile">Choose file</label>
                    </div>
                </div>
                <div class="form-group col-6 d-flex justify-content-center">
                    <img src="<?php echo validate_image(isset($meta['avatar']) ? $meta['avatar'] :'') ?>" alt="" id="cimg" class="img-fluid img-thumbnail">
                </div>
            </form>
        </div>
    </div>
    <div class="card-footer">
            <div class="col-md-12">
                <div class="row">
                    <button class="btn btn-sm btn-success mr-2" form="manage-user">Save</button>
                    <a class="btn btn-sm btn-secondary" href="./?page=user/list">Cancel</a>
                </div>
            </div>
        </div>
</div>

mrhero05 · Jun 26, 2022

eto boss asan to

M H I N Y E · Jun 26, 2022

mrhero05 said:
View attachment 1997621
eto boss asan to

Code:

<form action="" id="manage-user">   
                <input type="hidden" name="id" value="<?php echo isset($meta['id']) ? $meta['id']: '' ?>">
                <div class="form-group col-6">
                    <label for="name">First Name</label>
                    <input type="text" name="firstname" id="firstname" class="form-control" value="<?php echo isset($meta['firstname']) ? $meta['firstname']: '' ?>" required>
                </div>
                <div class="form-group col-6">
                    <label for="name">Last Name</label>
                    <input type="text" name="lastname" id="lastname" class="form-control" value="<?php echo isset($meta['lastname']) ? $meta['lastname']: '' ?>" required>
                </div>
                <div class="form-group col-6">
                    <label for="username">Username</label>
                    <input type="text" name="username" id="username" class="form-control" value="<?php echo isset($meta['username']) ? $meta['username']: '' ?>" required  autocomplete="off">
                </div>
                <div class="form-group col-6">
                    <label for="password">Password</label>
                    <input type="password" name="password" id="password" class="form-control" value="" autocomplete="off" <?php echo isset($meta['id']) ? "": 'required' ?>>
                    <?php if(isset($_GET['id'])): ?>
                    <small class="text-info"><i>Leave this blank if you dont want to change the password.</i></small>
                    <?php endif; ?>
                </div>
                <div class="form-group col-6">
                    <label for="type">User Type</label>
                    <select name="type" id="type" class="custom-select"  required>
                        <option value="1" <?php echo isset($meta['type']) && $meta['type'] == 1 ? 'selected': '' ?>>Administrator</option>
                        <option value="2" <?php echo isset($meta['type']) && $meta['type'] == 2 ? 'selected': '' ?>>Staff</option>
                        <option value="3" <?php echo isset($meta['type']) && $meta['type'] == 3 ? 'selected': '' ?>>Process Owner</option>
                        <option value="4" <?php echo isset($meta['type']) && $meta['type'] == 4 ? 'selected': '' ?>>Auditor</option>
                        <option value="5" <?php echo isset($meta['type']) && $meta['type'] == 5 ? 'selected': '' ?>>Auditor Lead</option>
                        <option value="6" <?php echo isset($meta['type']) && $meta['type'] == 6 ? 'selected': '' ?>>QAH</option>
                        <option value="7" <?php echo isset($meta['type']) && $meta['type'] == 7 ? 'selected': '' ?>>Team Management</option>
                        <option value="8" <?php echo isset($meta['type']) && $meta['type'] == 8 ? 'selected': '' ?>>Human Resource</option>
                    </select>
                </div>
                <div class="form-group col-6">
                    <label for="" class="control-label">Avatar</label>
                    <div class="custom-file">
                      <input type="file" class="custom-file-input rounded-circle" id="customFile" name="img" onchange="displayImg(this,$(this))">
                      <label class="custom-file-label" for="customFile">Choose file</label>
                    </div>
                </div>
                <div class="form-group col-6 d-flex justify-content-center">
                    <img src="<?php echo validate_image(isset($meta['avatar']) ? $meta['avatar'] :'') ?>" alt="" id="cimg" class="img-fluid img-thumbnail">
                </div>
            </form>

PHP:

<form action="" id="manage-user">   
                <input type="hidden" name="id" value="<?php echo isset($meta['id']) ? $meta['id']: '' ?>">
                <div class="form-group col-6">
                    <label for="name">First Name</label>
                    <input type="text" name="firstname" id="firstname" class="form-control" value="<?php echo isset($meta['firstname']) ? $meta['firstname']: '' ?>" required>
                </div>
                <div class="form-group col-6">
                    <label for="name">Last Name</label>
                    <input type="text" name="lastname" id="lastname" class="form-control" value="<?php echo isset($meta['lastname']) ? $meta['lastname']: '' ?>" required>
                </div>
                <div class="form-group col-6">
                    <label for="username">Username</label>
                    <input type="text" name="username" id="username" class="form-control" value="<?php echo isset($meta['username']) ? $meta['username']: '' ?>" required  autocomplete="off">
                </div>
                <div class="form-group col-6">
                    <label for="password">Password</label>
                    <input type="password" name="password" id="password" class="form-control" value="" autocomplete="off" <?php echo isset($meta['id']) ? "": 'required' ?>>
                    <?php if(isset($_GET['id'])): ?>
                    <small class="text-info"><i>Leave this blank if you dont want to change the password.</i></small>
                    <?php endif; ?>
                </div>
                <div class="form-group col-6">
                    <label for="type">User Type</label>
                    <select name="type" id="type" class="custom-select"  required>
                        <option value="1" <?php echo isset($meta['type']) && $meta['type'] == 1 ? 'selected': '' ?>>Administrator</option>
                        <option value="2" <?php echo isset($meta['type']) && $meta['type'] == 2 ? 'selected': '' ?>>Staff</option>
                        <option value="3" <?php echo isset($meta['type']) && $meta['type'] == 3 ? 'selected': '' ?>>Process Owner</option>
                        <option value="4" <?php echo isset($meta['type']) && $meta['type'] == 4 ? 'selected': '' ?>>Auditor</option>
                        <option value="5" <?php echo isset($meta['type']) && $meta['type'] == 5 ? 'selected': '' ?>>Auditor Lead</option>
                        <option value="6" <?php echo isset($meta['type']) && $meta['type'] == 6 ? 'selected': '' ?>>QAH</option>
                        <option value="7" <?php echo isset($meta['type']) && $meta['type'] == 7 ? 'selected': '' ?>>Team Management</option>
                        <option value="8" <?php echo isset($meta['type']) && $meta['type'] == 8 ? 'selected': '' ?>>Human Resource</option>
                    </select>
                </div>
                <div class="form-group col-6">
                    <label for="" class="control-label">Avatar</label>
                    <div class="custom-file">
                      <input type="file" class="custom-file-input rounded-circle" id="customFile" name="img" onchange="displayImg(this,$(this))">
                      <label class="custom-file-label" for="customFile">Choose file</label>
                    </div>
                </div>
                <div class="form-group col-6 d-flex justify-content-center">
                    <img src="<?php echo validate_image(isset($meta['avatar']) ? $meta['avatar'] :'') ?>" alt="" id="cimg" class="img-fluid img-thumbnail">
                </div>
            </form>

mrhero05 said:
View attachment 1997621
eto boss asan to

yan na paps

Misanthropy · Jun 26, 2022

bat di po kayo mag if else sa unang code

L-Prime said:
bat di po kayo mag if else sa unang code

i mean else if tas ternary pa rin

M H I N Y E · Jun 26, 2022

L-Prime said:
bat di po kayo mag if else sa unang code

i mean else if tas ternary pa rin

yan din naisip ko pero diko alam kung ano structure

Misanthropy · Jun 26, 2022

Geuru said:
yan din naisip ko pero diko alam kung ano structure

medyo masakit lang sa mata paps

PHP Mga IT Gods Need your help

Forum Guru

Attachments

Eternal Poster

Forum Guru

Forum Veteran

Forum Guru

Forum Veteran

Forum Guru

Attachments

Eternal Poster

Forum Guru

Attachments

Eternal Poster

Forum Guru

Eternal Poster

Forum Guru

Eternal Poster

Forum Guru

Eternal Poster

Attachments

Forum Guru

Forum Veteran

Forum Guru

Forum Veteran

Similar threads

Popular Tags

About this Thread

Online statistics