3)){ $slugText = $_POST['name']; $slugText = preg_replace('~[^\p{L}\p{N}_-]+~u', '-', $slugText); $slugText = strtolower($slugText); $slugText = preg_replace('~-+~', '-', $slugText); $slugText = trim($slugText, '-'); $time=time(); $sid=rand(100,360).$time.rand(100,999);// $id='360000'.$time; //360000 concatineted with 1704215388 produces 10 width base_convert with 36 $siliconid = base_convert($sid,10,36); try { $conn = new PDO("mysql:host=$mariaServer;dbname=$mariaDb", $mariaUser, $mariaPass); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt = $conn->prepare("INSERT INTO api_tools (siliconid, name, title, description, slug, status) VALUES (:siliconid, :name, :title, :description, :slug, 0)"); $stmt->bindParam(':siliconid', $siliconid); $stmt->bindParam(':name', $_POST['name']); $stmt->bindParam(':title', $_POST['title']); $stmt->bindParam(':description', $_POST['description']); $stmt->bindParam(':slug', $slugText); $stmt->execute(); // echo ''; // $in_page_message = "
Thank you! Your Query has been submitted.
"; } catch (PDOException $e) { $in_page_message= "Error: " . $e->getMessage() . "
"; } } ?>Add New Tool