PHP - Random Id For Dosie Witch Does Not Exist In Database

Ok guys, I am working on my code as I am checking the row in a database that if i have got a same row that I insert the functions in the URL then throw the error that says "you can't store". When I am checking as the rows have already exist, i keep getting "you can now store".

Do you know how i can check in a database to see if the rows is exist?

here's the code:

Code: [Select]
<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'mydbuser');
    define('DB_PASSWORD', 'mydbpass');
    define('DB_DATABASE', 'mydbname');
       
    $errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {

die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
    $image = clean($_GET['image']);
    $strings = clean($_GET['strings']);
    $username = clean($_GET['user']);
    $password = clean($_GET['pass']);


if (isset($_GET['user']) && (isset($_GET['pass']))) {
    if($username == '' || $password == '') {
  $errmsg_arr[] = 'username or password are missing';
  $errflag = true;
    }
}
if (isset($_GET['image']) || (isset($_GET['strings'])) || (isset($_GET['user']))) {
    if($image == '' || $strings == '' || $username == '') {
  $errmsg_arr[] = 'image, strings or username are missing';
  $errflag = true;
    }
}
    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {

 
$insert = array();
if(isset($_GET['image'])) {
    $insert[] = 'image = \'' . clean($_GET['image']) . '\'';
}
if(isset($_GET['user'])) {
    $insert[] = 'user = \'' . clean($_GET['user']) .'\'';
}
if(isset($_GET['pass'])) {
    $insert[] = 'pass = \'' . clean($_GET['pass']) . '\'';


if (count($insert)>0) {
  $names = implode(',',$insert);


 if($image && $strings && $from && $username) {
   $qry="SELECT * FROM members WHERE username='$username'";
   $result=mysql_query($qry) or die('Error:<br />' . $qry . '<br />' . mysql_error());
   $row=mysql_fetch_assoc($result);

   if ($row >= 1) {
      echo 'you cant store.';
   } else {
      echo 'you can now store';
 }
} elseif($username && $pass) {
  echo "working 2";
  }
 }
}
?>

i have error where my code should update existing data where id exist, it get updated ..but the others data is disappeared .only the data updated is remained 

$sql1 ="select*from semakan_dokumen where email='$stdEmail'";
$sqlsearch1 = mysqli_query($dbconfig,$sql1);
$resultcount1 = mysqli_num_rows($sqlsearch1);

if($resultcount1 > 0){
$query1=("UPDATE  semakan_dokumen set student_id='$noMatrik', email= '$stdEmail', surat_tawaran='$fileName', ic='$fileName1',sijil_lahir='$fileName2',sijil_spm= '$fileName3',sijil_sekolah= '$fileName4', sijil_dip= '$fileName5',sej_julai='$fileName6',bm_julai='$fileName7',muet='$fileName8', mid1='$fileName9',yuran= '$fileName10',umpa_bend1= '$fileName11',umpa_bend2='$fileName12',bpkp='$fileName13', penaja='$fileName14',kesihatan= '$fileName15', jhepa='$fileName16' where email= '$stdEmail' ");

}else{


//filezip
$query1 = "INSERT INTO semakan_dokumen (email,surat_tawaran,ic,sijil_lahir,sijil_spm,sijil_sekolah,sijil_dip,sej_julai,bm_julai,muet,mid1,yuran,umpa_bend1,umpa_bend2,bpkp,penaja,kesihatan,jhepa) VALUES ('$stdEmail','$fileName','$fileName1','$fileName2','$fileName3','$fileName4','$fileName5','$fileName6','$fileName7','$fileName8','$fileName9','$fileName10','$fileName11','$fileName12','$fileName13','$fileName14','$fileName15','$fileName16')";
}

 

Hi,

Would someone please give me some assistance on how to display random products from my database

I need to display a maximum of 6 images and there link in two rows of 3 so;

[image] [image] [image]
[image] [image] [image]

and each image would have something like;

<a href="<? echo $row['product_link'] ?>"><img src="<? echo $row['product_image'] ?>"/></a>

but i don't know how to display these at random and make sure only 6 appear at a time.

Thanks for any help, hope you understand what im trying to explain

Code: [Select]
require('../conn/db_connection.php');

//seleksi restoran

$pilih_resto="select * from restoran";
$query_pilih_resto=mysql_query($pilih_resto);

echo "<h3>Truly Data : </h3>";
while($resto=mysql_fetch_array($query_pilih_resto)){
echo"<font color='red'>".$resto["id_restoran"].".". $resto["nama_restoran"]."</font><br>";

$seleksi_menu_1="select * from jenis_menu";
$query_menu_1=mysql_query($seleksi_menu_1);
while($menu_1=mysql_fetch_array($query_menu_1)){
echo "<font color='green'>".$menu_1["id_jenis_menu"]."</font><br>";

$seleksi_data_eat="select * from eat where id_restoran like '".$resto["id_restoran"]."' and id_jenis_menu like '".$menu_1["id_jenis_menu"]."'";
$query_eat=mysql_query($seleksi_data_eat);

while($eat=mysql_fetch_array($query_eat)){
echo $eat["nama_eat"]."<br>";

}

}
echo"<br>";
}

echo "------------------------------<br>";

echo "<h3>Random Data : </h3>";

$pilih_resto_2="select * from restoran";
$query_pilih_resto_2=mysql_query($pilih_resto_2);
$menu_PNP="PNP";
$menu_PBK="PBK";
$menu_UTM_1="UTM";
while($data_resto=mysql_fetch_array($query_pilih_resto_2)){

echo "<b>".$data_resto["id_restoran"]."-".$data_resto["nama_restoran"]."</b><br>";
$seleksi_data_eat_PNP="select * from eat where id_restoran like '".$data_resto["id_restoran"]."' and id_jenis_menu like '".$menu_PNP."'";

$seleksi_data_eat_PBK="select * from eat where id_restoran like '".$data_resto["id_restoran"]."' and id_jenis_menu like '".$menu_PBK."'";

$seleksi_data_eat_UTM="select * from eat where id_restoran like '".$data_resto["id_restoran"]."' and id_jenis_menu like '".$menu_UTM_1."'";

$query_eat_UTM=mysql_query($seleksi_data_eat_UTM);
$jml_data_UTM=mysql_num_rows($query_eat_UTM);
echo "Summary of main Menu : $jml_data_UTM<br>";
$query_eat_PNP=mysql_query($seleksi_data_eat_PNP);
$query_eat_PBK=mysql_query($seleksi_data_eat_PBK);

while($eat_PNP=mysql_fetch_array($query_eat_PNP)){
$data_eat_PNP[]=$eat_PNP["nama_eat"];
}
while(list($index_PNP,$data_PNP)=each($data_eat_PNP)){
$data_eat_PNP_list[$index_PNP]=$data_PNP;
}

while($eat_PBK=mysql_fetch_array($query_eat_PBK)){
$data_eat_PBK[]=$eat_PBK["nama_eat"];
}
while(list($index_PBK,$data_PBK)=each($data_eat_PBK)){
$data_eat_PBK_list[$index_PBK]=$data_PBK;
}
while($eat_UTM=mysql_fetch_array($query_eat_UTM)){
$eat_UTMx[]=$eat_UTM["nama_eat"];
}
for($i=0;$i<$jml_data_UTM;$i++){

$random_data_PNP[$i]=array_rand($data_eat_PNP_list,1);
$random_data_PBK[$i]=array_rand($data_eat_PBK_list,1);
echo "<font color='red'>".$data_eat_PNP_list[$random_data_PNP[$i]]."</font>---<font color='green'>". $eat_UTMx[$i]."</font>---<font color='blue'>".$data_eat_PBK_list[$random_data_PBK[$i]]."</font><br>";

}
}


Please Help, There is a random error data


 how to create random data like this?

Data =>
Restoran A:

Menu appetizers :
- Sup
- Sate Usus
- Trancam

Main Menu
- Nasi Goreng
- Nasi Goreng Putih
- Nasi + Ayam Penyet
- Nasi + Bebek Panggang
- Ikan Gurame Asam + Nasi
- Nasi Soto

Menu Dessert
- Pudding
- Buah Segar
- Juice Aplukat


Restoran B :

Menu appetizers
-Sup Ikan Paprika
-Sup Jamur Spesial
-Sup Urat Sapi Saus Tiram
-Sup May Jala - Jala

Main Menu
- Bubur Ayam Kombinasi
- Bubur Ayam/Sapi Clay Pot
- Bubur Telor Pitan Clay Pot
- Gurame Panggang
- Pangsit Udang
- Cumi-cumi Goreng Special
- Kepiting Lembek Mentega
- Sayap Ayam Panggang

Dessert
-Juice Alpukat
-Mix Juice
-Sui Kiau Goreng Salad
-Ha Kaou Sayuran


Out Put :

Restoran A :

Menu e ---+--- Main Menu --+---- Dessert
----------------------------------------------------

Sup ------- Nasi Goreng ------- Pudding
Sup ------- Nasi Goreng Putih ------- Juice Aplukat
Sate Usus ------- Nasi + Ayam Penyet ------- Pudding
Sup ------- Nasi + Bebek Panggang ------- Buah Segar
Trancam ------- Ikan Gurame Asam + Nasi ------- Buah Segar
Sate Usus ------- Nasi Soto ------- Pudding

Restoran B :

Menu Pembuka ---+-- Menu Utama --+--- Menu Penutup
-----------------------------------------------------------------------

Sup Ikan Paprika ------- Bubur Ayam Kombinasi ------- Juice Alpukat
Sup Urat Sapi Saus Tiram ------- Bubur Ayam/Sapi Clay Pot ------- Sui Kiau Goreng Salad
Sup May Jala-Jala ------- Bubur Telor Pitan Clay Pot ------- Juice Alpukat
Kepiting Lembek Mentega ------- Gurame Panggang ------- Juice Alpukat
Sup Urat Sapi Saus Tiram ------- Pangsit Udang ------- Mix Juice
Sup May Jala-Jala ------- Cumi-cumi Goreng Special ------- Ha Kaou Sayuran
Sup Jamur Spesial ------- Kepiting Lembek Mentega ------- Sui Kiau Goreng Salad
Sup May Jala-Jala ------- Sayap Ayam Panggang ------- Ha Kaou Sayuran

Note :
appetizers and desserts at random based on count of data main menu