CREATE TABLE `rainbow_table` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`pass` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci',
`hash` CHAR(32) NOT NULL COLLATE 'utf8mb4_unicode_ci',
PRIMARY KEY (`id`) USING BTREE,
INDEX `hash_index` (`hash`) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB;
$config = [
'db_name' => 'md5hashes',
'db_host' => '127.0.0.1',
'db_user' => 'mysql',
'db_pass' => 'mysql',
];
$hash = $_POST['hash'];
$dsn = 'mysql:dbname='.$config['db_name'].';host='.$config['db_host'];
$pdo = new PDO($dsn, $config['db_user'], $config['db_pass']);
$stmt = $pdo->prepare('SELECT * FROM `rainbow_table` WHERE `hash` = :hash')
$stmt->execute(['hash' => $hash]);
if ($stmt->rowCount() > 0) {
$row = $stmt->fetch(PDO::FETCH_ASSOC);
echo 'Хэш найден: '.$row['pass'];
} else {
echo 'Хэш не найден';
}
$dsn = 'mysql:dbname='.$config['db_name'].';host='.$config['db_host'];
$pdo = new PDO($dsn, $config['db_user'], $config['db_pass']);
$stmt = $pdo->prepare('INSERT INTO `rainbow_table` (`pass`, `hash`) VALUES (:pass, :hash)');
$fp = fopen('words.txt', 'r');
if ($fp) {
while (($buffer = fgets($fp)) !== false) {
$stmt->execute(['pass' => $buffer, 'hash' => md5($buffer)]);
}
if (!feof($fp)) {
echo "Ошибка: fgets() неожиданно потерпел неудачу\n";
}
fclose($fp);
}
лучше сразу ссылку на статью) В первом результате демонстрируется написание дырявых запросов и использования MD5. Очень много мусора в поиске.
Не могу понять как передать экземпляр $request
public function getTrackListJson(Request $request): \Illuminate\Http\JsonResponse
{
dd($this->upload($request));
$tracks = DB::table('songs_tracks')->where('id', $id)->first();
return response()->json([$tracks]);
}
$tracks = DB::table('songs_tracks')->where('id', $id)->first();
$track = SongTrack::findOrFail($id);
$table->integer('year')->nullable()->default(null)->change();
Film::whereYear('Не указано')->update(['year' => null])
$a = "Артем=>4,Максим.Антон=>421414,Алина=>222,";
$a = trim($a, ', \n\r\t\v\x00');
$result = call_user_func_array(
'array_merge_recursive',
array_map(function($str){
[$key, $value] = explode('=>', $str);
return [$key => $value];
}, explode(',', $a))
);
foreach ($result as $key => $value) {
echo $key . ' : ' . $value . "<br>\n";
}
$a = "Артем=>4,Максим.Антон=>421414,Алина=>222,";
$a = trim($a, ', \n\r\t\v\x00');
$result = array_map(fn($str) => explode('=>', $str), explode(',', $a));
foreach ($result as $v) {
echo $v[0] . ' : ' . $v[1] . "<br>\n";
}
foreach ($_GET['aServicesObj'] as $key => $value) {
$serv .= $key.'=>'.$value.',';
}
$serv = trim($serv, ',');
//foreach ($_GET['aServicesObj'] as $key => $value) {
// $serv .= $key.'=>'.$value.',';
//}
$serv = json_encode($_GET['aServicesObj']);
$result = json_decode($serv);
foreach ($result as $k => $v) {
echo $k . ' : ' . $v . "<br>\n";
}
$data = [
'Артем' => 4,
'Максим.Антон' => 421414,
'Алина' => 222,
];
$serv = http_build_query($data);
/////////////////
parse_str($serv, $result);
foreach ($result as $k => $v) {
echo $k . ' : ' . $v . "<br>\n";
}
public function show(Category $category)
{
return response()->json($category->toArray());
}
$item_data = [
[
'barcode' => '656334e3564439',
'stock' => 1,
'warehouseId' => 7543,
]
];
$data = json_encode($item_data);