PaulosK
-
Posts
6 -
Joined
-
Last visited
PaulosK's Achievements
Newbie (1/5)
0
Reputation
-
Dynamically accessing html value within the same file
PaulosK replied to PaulosK's topic in PHP Coding Help
I tried what you propose and it worked. I also changed the form in html to this: I also use php to show the outcome instead of js and only using js to get the SID <form action = "read.php" method="post"> <input id="sid_label" name="sid" readonly="readonly"> <button id="button_clicker" type="submit" onclick="get_sid()">READ</button> </form> -
Dynamically accessing html value within the same file
PaulosK replied to PaulosK's topic in PHP Coding Help
i don't know how to pass send the message from the rpi to the app, but I haven't got to that stage yet, so it will be something I 'll do in the future. I think that it will need something with javascript thought, thus, I am making this function as a placeholder. The general idea of the app will be to read an nfc card, find its values from a db using the serial number of the nfc car (SID) and then display the values found on the db or write values to the db on the row with the specific SID. I 'll try what you said and i 'll update with the results. -
Dynamically accessing html value within the same file
PaulosK replied to PaulosK's topic in PHP Coding Help
can i keep the code for the rest of the app the same and just rewrite this page with ajax, or how does it work? I haven't used ajax before, so I know nothing about it -
Dynamically accessing html value within the same file
PaulosK replied to PaulosK's topic in PHP Coding Help
<div id="form"> <form action = "read.php" method="post"> <label id="sid_label" name ="sid"></label> <button id="button_clicker" type="submit" onclick="get_sid(), show_message()">READ</button> </form> </div> It still doesn't work. Also, I need to get the sid with javascript, not from an input text. I am planning to automatically give an sid with a raspberry pi in the future, so I don't think that an input text will be a good start to achieve this -
Dynamically accessing html value within the same file
PaulosK replied to PaulosK's topic in PHP Coding Help
I think i am just braindead and didn't notice that my html code is wrong. I 'll update you with the result of the fixed code -
Hello everyone, I am making a web app and I need the user to be able to enter a code and then the php will search for the column that the code is in and then output the content of said column. The issue is that I can't find a way to pass the value from the html to the php. With the <form> tag, it throws this error: I also tried with cookies. They kind of work, the issue is that the page has to be refreshed first. Here is my code (sorry in advance for the mesh you are about to see) <!DOCTYPE html> <?php session_start(); //currently using this to test the rest of the app $SID = $_POST["sid"]; echo $SID; $values_arr = array(); //database connection $host = 'localhost'; $dbname = "test"; $username = "root"; $password = ""; // Create connection $conn = mysqli_connect(hostname: $host, username: $username, password: $password, database: $dbname); // Check connection if (mysqli_connect_errno()) { die("Connection failed: " . mysqli_connect_errno()); } $sql = "SHOW COLUMNS FROM test"; $result = mysqli_query($conn,$sql); for($o=0; $o<$row = mysqli_fetch_array($result); $o++){ //if the column is the LID skip //echo $row['Field']; if($row['Field']==='LID'){} else{ $column = $row['Field']; } if($o>0){ $repeat[$o-1] = $column; } } $sql = "SELECT * FROM `test` WHERE LID = $_SESSION[id]";//I currently use this to test the rest of the app $result = mysqli_query($conn, $sql); // First parameter is just return of "mysqli_connect()" function while ($row = mysqli_fetch_assoc($result)) { // Important line !!! Check summary get row on array .. $i = 0; foreach ($row as $field => $value) { // I you want you can right this line like this: foreach($row as $value) { //get every value in an index $values_arr[$i] = $value; $i++; //echo $value; // I just did not use "htmlspecialchars()" function. } } //make the array into a string $values_str = implode($values_arr); //turn that string back to an array $trimmed = str_split($values_str); //for the size of that array for($j=0; $j<sizeof($trimmed); $j++){ //if there is " replace it with space if($trimmed[$j]=='"'){ $trimmed[$j]=' '; } } //turn that array back to a string $new_str = implode($trimmed); ?> <html> <head> <title></title> </head> <body> <div id="demo" value="<?php echo "$new_str" ?>"></div> <div action = "read.php" id="form"> <form method="post"> <label id="sid_label" name ="sid"></label> <button id="button_clicker" onclick="get_sid(), show_message(); return false">READ</button> </form> </div> <div id="txt"></div> </body> <script> //check fot the sid (replace with the raspberry pi code) function get_sid(){ let text = prompt("SID"); let lbl = document.getElementById("sid_label"); let txt = document.createTextNode(text); lbl.appendChild(txt) } //show the selected row after clicking the button function show_message() { //get the value of the demo let id_param = document.getElementById("demo").getAttribute('value'); //id of button let button_click = document.getElementById("txt"); //create p element let text = document.createElement("p") //create text text_content = document.createTextNode(id_param); //put the text as a child of the p element text.appendChild(text_content); //put the p element as a child of the butto_click element button_click.appendChild(text); } </script> </html> Any solutions to this problem?