form

slimjim

I have tried everything I could think of to try to make a auotmatic submission for that this place requires, I always fail.
It seems simple enough right.
Wrong, I mean I tried a basic form and simple mysql input with the required fields for the form.
I was wondering if anyone has ever tackled something like this or has a copy of code that works so I can see what I cam doing so darn wrong.
Heck I even ask you to give it a try and see if you succeed at it.
No sence in putting my form or insert in here cause it is basic and does not work.
So any help would be great.

Here is the place where you add 2 links ...

http://multilinks.net/submissionsadd.shtml?

rincewind456

I'm unsure of what your after!

Do you want a page that does the same type of thing as the link you supplied? or something else?

slimjim

Hope this makes since.
trying to build a ffa script, then join this submission service, they send a massive amount of links. But first need to pass that test to see if the form works, and link gets entered into database, and then link shows up on page.

Need a page with a form on it, that when filled out, the data gets put into a database, and then is shown on a page as links.

I am trying to get the form to work with this automated service that will send hundreds of links. Like a ffa submissions automatically.

Here is what they say:
Please note that if you cannot add your site to our
service, you will not be able to add it to most
automatic submission services.

Your submission script must be able to accept at least
a Business section for the link posted.
Which this form does.

If you change your script to accept at least a Business
section and show the submitted link after submission on
the main page then you can try submitting it again and
you should be successful.

Here is example of the form needed.

<form method="POST" 
action="http://somesite.com/links.php">
<p>Title: <input type="text" name="title" size="55" 
maxlength="60"><br>
URL: <input type="text" name="url" size="55"><br>
Email Address: <input type="text" name="email" 
size="47"><br>
Section to be placed in: <select name="section" 
size="1">
<option> Business </option>
<option> Computers </option>
<option> Education </option>
<option> Entertainment </option>
<option> Government </option>
<option> Personal </option>
<option selected> Miscellaneous </option>
</select><br>
<input type="submit" value="Add"> * <input 
type="reset"></p>
</form>

rincewind456

Ok here's how I would do the sql insert script

<?php
// your sql connection parameters here

// Quote variable to make safe
function quote_smart($value){
    // Stripslashes
    if (get_magic_quotes_gpc()) {
        $value = stripslashes($value);
    }
    // Quote if not a number or a numeric string
    if (!is_numeric($value)) {
        $value = "'" . mysql_real_escape_string($value) . "'";
    }
    return $value;
}

//test to see if submit pressed
if (isset($_POST['submit'])) {

//trim whitespace
$title = trim($_POST["title"]);
$url = trim($_POST["url"]);
$email = trim($_POST["email"]);
$section = trim($_POST["section"]);
//build query
$query = sprintf("INSERT INTO table_name 
(title
, url
, email
section)
VALUES(
%s
, %s
, %s
,%s
",
quote_smart($title),
quote_smart($url),
quote_smart($email),
quote_smart($section));

$result = mysql_query($query) or die(mysql_error(" Query failed"));
$num_rows = mysql_num_rows($result);

echo "$num_rows Rows Inserted\n";


}	else	 {
?>



<form method="POST" action="">
<p>Title: <input type="text" name="title" size="55" maxlength="60"><br>
URL: <input type="text" name="url" size="55"><br>
Email Address: <input type="text" name="email" size="47"><br>
Section to be placed in: <select name="section" size="1">
<option> Business </option>
<option> Computers </option>
<option> Education </option>
<option> Entertainment </option>
<option> Government </option>
<option> Personal </option>
<option selected> Miscellaneous </option>
</select><br>
<input type="submit" name="submit"value="Add"> * <input
type="reset"></p>
</form>

<?php
}
?>

And for you print out script something like

<?php
// your sql connection parameters here

$query = "SELECT * FROM table_name";

$result = mysql_query($query) or die(mysql_error(" Query failed"));
$links = "";
while ($row = mysql_fetch_assoc($result)){
	//build your link rows like:
	$links .="<a href='".$row['url'].">".$row['title']."</a>";
}

print $links;

?>

slimjim

Ok I will test this and see if that will actually pass their test.
I will post back when I finish.

slimjim

What could be wrong with this part ?
Getting this error :
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource on line 43

$query = sprintf("INSERT INTO links
(title 
, url 
, email 
section) 
VALUES( 
%s 
, %s 
, %s 
,%s 
", 
quote_smart($title), 
quote_smart($url), 
quote_smart($email), 
quote_smart($section)); 

$result = mysql_query($query) or die(mysql_error(" Query failed")); //LINE 43
$num_rows = mysql_num_rows($result);

slimjim

Well it didnt work..
Best thing for you to try is go here..
http://submitomatic.net/
Form adding link is at bottom
Once the form has been made, then of course that info has to be added to database.
Then info has to be showed on a page based on categories.
Then
Click add ffa page here http://submitomatic.net/

Now if all works, it should be accepted, cause I cant get nothing accepted.
Please try and get yours accepted and let me know how you did it.

To understand what is happening and what I am trying to do, cause same error is here when I try to add my pages.