levani01Hi
I'm trying to create custom write panel directly on my wordpress blog, without the dashbord. But I have a little problem. I use the standart INSERT statement to send data to database, but every time I do this only 0 is sent instead of the real value. I have checked several times that the variable has right value but still no successes.
This is my code:
Form:
<form id="lev-post" name="lev-post" method="post" action="?page_id=7">
<input name="lev-post-author-id" type="hidden" value="<?php echo $current_user->ID; ?>" />
<input name="lev-post-post-status" type="hidden" value="publish" />
<input name="lev-post-comment-status" type="hidden" value="open" />
<input name="lev-post-ping-status" type="hidden" value="open" />
<input name="lev-post-type" type="hidden" value="post" />
<input name="lev-post-menu-order" type="hidden" value="0" />
<input name="lev-post-post-parent" type="hidden" value="0" />
<input name="lev-post-post-cat" type="hidden" value="0" />
<label>
title: <input type="text" name="lev-post-title" />
</label>
<p>
<label>
content: <textarea name="lev-post-content"></textarea>
</label>
</p>
<p>
<label>
category: <select name="lev-post-cat">
<option value="1">Cat 1</option>
<option value="2">Cat 2</option>
<option value="3">Cat 3</option>
<option value="4">Cat 4</option>
</select>
</label>
</p>
<input name="" type="submit" value="submit" />
</form>php code on page 7:
<?php $lev_post_author_id = $_POST["lev-post-author-id"]; ?>
<?php $lev_post_status = $_POST["lev-post-post-status"]; ?>
<?php $lev_comment_status = $_POST["lev-post-comment-status"]; ?>
<?php $lev_ping_status = $_POST["lev-post-ping-status"]; ?>
<?php $lev_post_type = $_POST["lev-post-type"]; ?>
<?php $lev_menu_order = $_POST["lev-post-menu-order"]; ?>
<?php $lev_post_parent = $_POST["lev-post-post-parent"]; ?>
<?php $lev_post_category = $_POST["lev-post-post-cat"]; ?>
<?php $lev_post_title = $_POST["lev-post-title"]; ?>
<?php $lev_post_content = $_POST["lev-post-content"]; ?>
<?php $lev_post_cat = $_POST["lev-post-cat"]; ?>
<?php $table_name = 'wp_posts'; ?>
<?php $insert = "INSERT INTO " . $table_name .
" (post_author, post_content, post_title, post_category, post_status, comment_status, ping_status, post_parent, menu_order, post_type) " .
"VALUES ('" . $current_user->ID . "',araperi,'" . $lev-post-title . "','" . $wpdb->escape($lev_post_category) . "','" . $wpdb->escape($lev_post_status) . "','" . $wpdb->escape($lev_comment_status) . "','" . $wpdb->escape($lev_ping_status) . "','" . $wpdb->escape($lev_post_parent) . "','" . $wpdb->escape($lev_menu_order) . "','" . $wpdb->escape($lev_post_type) . "')";
$results = $wpdb->query( $insert ); ?>Can anyone tell me what's wrong with this code?
Thanks in advance
Lacpapi