PHP - Get Random Text From Database Table, How To?

Hi,
I'm a researcher (and complete coding noob), and am planning a longitudinal study that requires e-mail follow-up with subjects taking an initial survey. For purposes of ethics/anonymity due to sensitive survey data, I'd like the acquired e-mails to be saved uncoupled from the survey responses; this is simple to deal with, and I use a basic PHP e-mail form, which injects the email address in a table in MySQL in a different server than the one used for the survey.

The issue is that the e-mails are saved in the MySQL database in order of injection, thus it is still theoretically possible for me to link the e-mails back to the survey responses (which have a time stamp that I cannot remove).  Ideally I would like not to be able (at all) to link the e-mails to the survey responses, and one way to do that (since I don't save the e-mail injection timestamps in MySQL) might be to have the e-mails saved in MySQL in a random order. Not sure if this is possible, and not even sure if this would be via PHP or MySQL side of things. The server is on godaddy and uses Starfield interface for MySQL but I cannot find an option for random insert/saving of table items (emails). They are saved in order of injection.
Any solution for this?
Thanks,

the second database found on the cloud

 

i try to get JSON data but how to insert and update  them to another online database with the same table

my php script to return json data 

<?php        

 include_once('db.php');

        $users = array();

        $users_data = $db -> prepare('SELECT id, username FROM  users');

        $users_data -> execute();

        while($fetched = $users_data->fetch()) {

            $users[$fetchedt['id']] = array (

                'id' => $fetched['id'],

                'username' => $fetched['name']

            );

        }

        echo json_encode($leaders);

 

 

 

 

i get

 

{"1":{"id":1,"username":"jeremia"},"2":{"id":2,"username":"Ernest"}}

 

Edited March 24 by mahenda

Hello,

I need some help. Say that I have a list in my MySQL database that contains elements "A", "S", "C", "D" etc... Now, I want to generate an html table where these elements should be distributed in a random and unique way while leaving some entries of the table empty, see the picture below. But, I have no clue how to do this... Any hints?



Thanks in advance,
Vero

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