Menu
Community /Pin to ProfileBookmark
@daveyerwinJul 14.2020 — #@developer_web#1620540
this is what I posted in another reply to you ...
#########################
Q2.
On some tutorials, I see the Submit button code to be like the following if I remember correctly. None of them are not the same as the one I mentioned just above.
Which ones are correct ? Give your ranking according to preference ....
<input type = "button" value = "submit">
correct But does not submit form
<input type = "submit" value = "submit">
correct and submits form
##############
this is what you have in your form ...
<input type="button" name="submit_link" id="submit_link" value="Submit Link!">@daveyerwinJul 16.2020 — #<input type="button" value="submit!">
the above line will not submit form @daveyerwinJul 16.2020 — #here is working example using prepared staements ...
this is a working example
put it on your server
if it doesn't work
post here
if it works begin to change it to suit you
test after every change no matter how small a change
when you have problems post here@daveyerwinJul 17.2020 — #<button type="submit">Submit</button>
<button type="submit" value="submit">Submit</button>
<input type="submit" value="submit">
<button name=submit value=" ">Submit</button>
if you would learn HTML Forms you would know
a name is required for the element value to be
submitted to the server
had you first began to learn HTML Forms
you would have had no need to post here
I have so enjoyed replying to your posts
I really needed this refresher course
Thank You and do post again
INSERT Fails Why ?
Folks,
Why this code fails to INSERT ? I get no response after I click button.
[code]
<?php
include(‘error_reporting.php’);
require(‘conn.php’);
//equire(‘link_submission_form.php’);
?>
<form name = “submit_link” method = “POST” action=”<?php echo $_SERVER[‘PHP_SELF’]; ?>”>
<label for=”domain”>Domain:</label>
<input type=”text” name=”domain” id=”domain” placeholder=”Input Domain”>
<br>
<label for=”domain_email”>Domain Email:</label>
<input type=”email” name=”domain_email” id=”domain_email” placeholder=”Input Domain Email”>
<br>
<label for=”url”>Url:</label>
<input type=”url” name=”url” id=”url” placeholder=”Input Url”>
<br>
<label for=”link_anchor_text”>Link Anchor Text:</label>
<input type=”text” name=”link_anchor_text” id=”link_anchor_text” placeholder=”Input Link Anchor Text”>
<br>
<textarea rows=”10″ cols=”20″>Page Description</textarea>
<br>
<label for=”keywords”>Keywords:</label>
<input type=”text” name=”keywords” id=”keywords” placeholder=”Input Keywords related to Page”>
<br>
<label for=”tos_agreement”>Agree to TOS or not ?</label>
<select name=”tos_agreement” id=”tos_agreement”>
<option value=”yes”>Yes</option>
<option value=”no”>No</option>
</select>
<br>
<input type=”button” name=”submit_link” id=”submit_link” value=”Submit Link!”>
<br>
<input type=”reset”>
<br>
</form>
<?php
if($_SERVER[‘REQUEST_METHOD’] === ‘POST’)
{
if(ISSET($_POST[‘submit_link’]))
{
$query = “INSERT into links (domain,domain_email,url,link_anchor_text,page_description,keywords) VALUES ?,?,?,?,?,?”;
$stmt = mysqli_stmt_init($conn);
if(mysqli_stmt_prepare($stmt,$query))
{
mysqli_stmt_bind_param($stmt,’ssssss’,$_POST[‘domain’],$_POST[‘domain_email’],$_POST[‘url’],$_POST[‘link_anchor_text’],$_POST[‘page_description’],$_POST[‘keywords’]);
mysqli_stmt_close($stmt);
mysqli_close($conn);
}
else
{
die(“INSERT failed!”);
}
}
}
?>
Sign in
to post a comment16 Comments(s) ↴
0
@daveyerwinJul 14.2020 — #this is what I posted in another reply to you ...
#########################
Q2.
On some tutorials, I see the Submit button code to be like the following if I remember correctly. None of them are not the same as the one I mentioned just above.
Which ones are correct ? Give your ranking according to preference ....
<input type = "button" value = "submit">
correct But does not submit form
<input type = "submit" value = "submit">
correct and submits form
##############
this is what you have in your form ...
<input type="button" name="submit_link" id="submit_link" value="Submit Link!">
0
@daveyerwinJul 16.2020 — #the above line will not submit form
0
@daveyerwinJul 16.2020 — #here is working example using prepared staements ...``<i>
</i><?php
//include('error_reporting.php');
ini_set('error_reporting','E_ALL');//Same as: error_reporting(E_ALL);
ini_set('display_errors','1');
ini_set('display_startup_errors','1');
?>
<form method = "POST" action="">
<label for="keywords">Keywords:*</label>
<input type="text" name="keywords" id="keywords" placeholder="Input Keywords" required>
<br>
<button name=search_links value=" ">send</button>
<br>
<input type="reset">
<br>
</form>
<?php
if($_SERVER['REQUEST_METHOD'] === 'POST')
{
if(ISSET($_POST['search_links']))
{
if(ISSET($_POST['keywords']))
{
$keywords = $_POST['keywords'];
}
$servername = "localhost";
$username = "x-x-x-x-x-x-x-";
$password = "x-x--x-x--x-x";
$dbname = "x-x-x-x-x-x-x-x-";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: ");
}
$sql = "CREATE TABLE IF NOT EXISTS Test (
link VARCHAR(255) NOT NULL
) ";
if($result=mysqli_query($conn, $sql)){
echo 'table created successfully<br>';
}
else {
echo 'Error creating table<br>' ;
}
$sql = "INSERT into Test (link) VALUES (?)";
$stmt = mysqli_stmt_init($conn);
mysqli_stmt_prepare($stmt,$sql);
mysqli_stmt_bind_param($stmt, "s", $keywords);
mysqli_stmt_execute($stmt);
$sql = "SELECT * FROM Test";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
while($row = mysqli_fetch_array($result)) {
echo $row[0]. "<br>";
}
} else {
echo "0 results";
}
mysqli_close($conn);
}}
?><i>
</i>``this is a working example
put it on your server
if it doesn't work
post here
if it works begin to change it to suit you
test after every change no matter how small a change
when you have problems post here
0
@daveyerwinJul 17.2020 — #<button type="submit" value="submit">Submit</button>
<input type="submit" value="submit">
<button name=submit value=" ">Submit</button>
if you would learn HTML Forms you would know
a name is required for the element value to be
submitted to the server
had you first began to learn HTML Forms
you would have had no need to post here
I have so enjoyed replying to your posts
I really needed this refresher course
Thank You and do post again