Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = 'ip_address';
- $user = 'user_name';
- $password = 'password';
- $link = mysql_connect($host, $user, $password);
- $selected = mysql_select_db('db_name', $link);
- if(!isset($_POST['text-input']))
- ?>
- <form method="post">
- %slice%
- <input type="submit" value="Submit" />
- </form>
- %[if !edit]%
- <?php
- %[repeat items]%
- $form_input%id=repeatIndex% = $_POST['element-%id=repeatIndex%'] ;
- %[endrepeat]%
- $query = 'INSERT INTO `table_name` (%[repeat items]%%[endif]%%html="Edit Me"%%[if !edit]%,%[endrepeat]%) VALUES (%[repeat items]%"' . $form_input%id=repeatIndex% . '",%[endrepeat]%);';
- $query = preg_replace('/,);/',');',$query);
- $query = preg_replace('/,) /',')',$query);
- mysql_query($query);
- ?>
- %[endif]%
- <?php
- db = new PDO('mysql:host=ip_address;dbname=db_name;', 'user_name', 'password');
- ?>
- <form method="post">
- %slice%
- <input type="submit" value="Submit" />
- </form>
- %[if !edit]%
- <?php
- %[repeat items]%
- $form_input%id=repeatIndex% = $_POST['element-%id=repeatIndex%'] ;
- %[endrepeat]%
- $query = 'INSERT INTO `table_name` (%[repeat items]%%[endif]%%html="Edit Me"%%[if !edit]%,%[endrepeat]%) VALUES (%[repeat items]%"' . $form_input%id=repeatIndex% . '",%[endrepeat]%);';
- $query = preg_replace('/,);/',');',$query);
- $query = preg_replace('/,) /',')',$query);
- mysql_query($query);
- ?>
- %[endif]%
- Warning: mysql_query() [function.mysql-query]: Access denied for user
- 'kuler'@'localhost' (using password: NO) in
- /home/path_to/index.php on line 125
- Warning: mysql_query() [function.mysql-query]: A link to the server could not be
- established in /home/path_to/index.php on line 125
- <?php
- //Connection vars
- $host = '%id=server%';
- $user = '%id=username%';
- $password = '%id=password%';
- $databasename = '%id=database%';
- //This block establishes the connection
- try{
- //
- $connectiondetails = "mysql:host={$host};dbname={$databasename}";
- $db = new PDO($connectiondetails , $user , $password);
- $db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_WARNING);
- }
- catch (PDOException $e) {
- print "Error!: " . $e->getMessage() . "<br/>";
- die();
- }
- //Check if all the input fields of the form have been submitted
- if(
- %[repeat items]%
- isset($_POST['element-%id=repeatIndex%'])&&
- %[endrepeat]%
- (true===true)
- ){
- //The variables to read the output
- %[repeat items]%
- $form_input%id=repeatIndex% = $_POST["element-%id=repeatIndex%"] ;
- %[endrepeat]%
- //DB
- global $db; //must set this, otherwise can't access the db
- $query = 'INSERT INTO `%id=table%` (%[endif]%%[repeat items]%%html="Edit Me"%%[if !edit]%,%[endif]%%[endrepeat]%%[if !edit]%)%[endif]% %[if !edit]%VALUES (%[repeat items]%"' . $form_input%id=repeatIndex% . '",%[endrepeat]%);';
- $query = preg_replace('/,);/',');',$query);
- $query = preg_replace('/,) /',')',$query);
- $db->query($query);
- //[DB]
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement