Insert into php database

Question

I am trying to insert into a table media and a column membro, a member name when he is logged in and he has uploaded an image/video, with no luck, this is my code that I put in submit.php:

<?php $fbme = $_SESSION['jigowatt']['username'];?>
<?php if (!isset($_SESSION)) session_start();
    if(isset($_SESSION['jigowatt']['username'])) {
    mysqli_query("INSERT INTO media (membro) values ('$fbme')");
}?>

I don't like to waste your time as I love this site, but some tips will be thanked.

Your session_start() placement is wrong. It should be at top the document (before the $fbme line). — Rahil Wazir
– Rahil Wazir, Commented Dec 29, 2013 at 14:57

Mahmood Rehman · Accepted Answer · 2013-12-29 14:53:57Z

1

Try your code with little difference like this :

<?php
if (!isset($_SESSION)) session_start();
 $fbme = $_SESSION['jigowatt']['username'];?>
<?php 
if(isset($_SESSION['jigowatt']['username'])) {
mysqli_query("INSERT INTO media (membro) values ('$fbme')");
}?>

answered Dec 29, 2013 at 14:53

Mahmood Rehman

4,3377 gold badges43 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

MadsBjaerge Over a year ago

You need to start_session() no matter what, not only if $_SESSION is not set.

Mahmood Rehman Over a year ago

Where the problem is ? in query or session value ?

Mahmood Rehman Over a year ago

@MadsBjaerge But you can check whether the session is already started or not.

MadsBjaerge Over a year ago

@MahmoodRehman, no you check whether the $_SESSION var i set, which is not the same as having it actually started...

Mahmood Rehman Over a year ago

I can't test your code just now.can you tell me the error ? or what you expect from code that is not working

|

Noor · Accepted Answer · 2013-12-29 15:52:12Z

1

Start session at the start of the code and the use session after that

     <?php if (!isset($_SESSION)) session_start(); ?>
       <?php $fbme = $_SESSION['jigowatt']['username'];?>

edited Dec 29, 2013 at 15:52

answered Dec 29, 2013 at 14:54

Noor

1,4019 silver badges28 bronze badges

Comments

Daryl Gill · Accepted Answer · 2013-12-29 14:55:18Z

0

Try turning on your session so it can be accessed:

session_start();

Throw this at the top of your page, unles you already have it on an include further up the page. If you already have; Everything looks in order from a first glimpse, if there is an under-laying problem with the MySQLI Driver within your code, try turning on the error reporting

mysqli_report(MYSQLI_REPORT_ALL);

Or even it's because you have not specified the database link:

$DB = new mysqli("","","","");
mysqli_query($DB,"");

answered Dec 29, 2013 at 14:55

Daryl Gill

5,52511 gold badges41 silver badges71 bronze badges

Collectives™ on Stack Overflow

Insert into php database

3 Answers 3

9 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

9 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related