php - base de données qui n'est pas remplie

Version imprimable

Bonjour à tous et à toutes,

Voici mon problème : J'ai une portion de code

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
 
 
if(isset($_POST['send']))
{
	unset($_POST['send']);
 
	if(!empty($_FILES['file']['name'])){
		$file['files']=$_FILES['file'];
		$file['destination']='contact_us_attachment';
		$_POST['file']=upload_file($file);
	}
	$table['table']='contact_us';
	$table['values']=$_POST;
	if(mysqli_insert($table))
	{
		foreach($ADMIN_EMAIL as $val)
		{
			$EMAIL['email']=$val;
			$EMAIL['title']="New enquiry recieved from website";
			$EMAIL['body']="<h3>Hi admin,</h3><br>
							<p> you recieved a new enquiry<p>
							<table>
								<tbody>
									<tr>
										<th>Type of member</th>
										<th>:</th>
										<td>{$_POST['type']}</td>
									</tr>
									<tr>
										<th>Topic</th>
										<th>:</th>
										<td>{$_POST['topic']}</td>
									</tr>
									<tr>
										<th>Email</th>
										<th>:</th>
										<td>{$_POST['email']}</td>
									</tr>
									<tr>
										<th>Mobile</th>
										<th>:</th>
										<td>{$_POST['mobile']}</td>
									</tr>
									<tr>
										<th>Subject</th>
										<th>:</th>
										<td>{$_POST['subject']}</td>
									</tr>
									<tr>
										<th>Message</th>
										<th>:</th>
										<td>{$_POST['message']}</td>
									</tr>
									<tr>
										<th>File</th>
										<th>:</th>
										<td><a href='$URL/contact_us_attachment/{$_POST['file']}'>{$_POST['file']}</a></td>
									</tr>
									<tr>
										<th>Sent on</th>
										<th>:</th>
										<td>".strftime('%d %b %Y %H:%M:%S',strtotime(date('Y-m-d H:i:s')))."</td>
									</tr>
								</tbody>
							</table>
							";
 
				$mail_print=send_mail($EMAIL);
		}
 
 
		$success=true;
	}
	else
	{
		$success=false;
	}
}
?>

celui ci correspondant aux messages email qui sont envoyés et aussi inscrit sur la BD

Le problème que je rencontre pour ce code, c'est que l'id est bien créé, mais la ligne complète est vide

J'espère de votre aide à tous

Cordialement.
Pat

12/09/2017, 15h54
Inazo

Bonjour,

La fonction mysqli_insert n'existe pas dans PHP.

@+
12/09/2017, 16h23
miramar

Citation:

Envoyé par Inazo

Bonjour,

La fonction mysqli_insert n'existe pas dans PHP.

@+

Et quelle serait la procédure à suivre pour rectifier le problème ?

Car j'avais placé ce code dans le fichier "db_function.php

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
 
 
function insert($data_all=array())
 
	{
 
		global $conn;
 
		$columns=null;
 
		$valuess=null;
 
		$values=array();
 
		$table=null;
 
		$primary_key=null;
 
		if(is_array($data_all))
 
		{	
 
			extract($data_all);
 
		}
 
		$columns=implode(',',array_keys($values));
 
		$valuess="'".implode("','",implode_array($values))."'";
 
		$query="INSERT INTO $table ($columns) VALUES ($valuess)";
 
		$result=mysqli_query($conn,$query);
 
		if(mysqli_error($conn))
 
		{
 
			message_redirect(array('message'=>'function insert error,  Error:'.mysqli_error($conn).',  Query:'.$query, 'type'=>'error','die'=>true));
 
			die;
 
		}

Désolé voici le code oupss !

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
 
 
function mysqli_insert($data_all=array())
 
	{
 
		global $conn;
 
		$columns=null;
 
		$valuess=null;
 
		$values=array();
 
		$table=null;
 
		$primary_key=null;
 
		if(is_array($data_all))
 
		{	
 
			extract($data_all);
 
		}
 
		foreach($values as $key=>$val){
 
			$values[$key]=str_replace(",",$val);
 
		}
 
 
 
		$columns=implode(',',array_keys($values));
 
		$valuess="'".implode("','",implode_array($values))."'";
 
		$query="INSERT INTO $table ($columns) VALUES ($valuess)";
 
		$result=mysqli_query($conn,$query);
 
		if(mysqli_error($conn))
 
		{
 
			message_redirect(array('message'=>'function insert error,  Error:'.mysqli_error($conn).',  Query:'.$query, 'type'=>'error','die'=>true));
 
			die;
 
		}
 
		if(mysqli_affected_rows($conn))
 
		{
 
				if($primary_key)
 
				{
 
					return last_id($data_all);
 
				}
 
				else
 
				{	
 
					return true;
 
				}
 
		}
 
		else
 
		{
 
			return false;
 
		}	
 
	}

12/09/2017, 16h39
Inazo

Tu n'as pas du tout de message d'erreur ?

Sinon ici, à mon avis il y a un soucis :

Code:

$valuess="'".implode("','",implode_array($values))."'";

Si tu affiches la valeur de $valuess tu devrais avoir un '' en trop devant après il peut correspondre pour le champ auto incrémenté, mais si et seulement si il est présent dans la liste des clés.

Tu peux nous afficher ce qu'il y a dans la variable $query s'il te plaît ?

@+

Bonjour et merci pour ton aide.
Non je n'ai pas de message d'erreur

Voici ce qu'il y a dans la BD

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
 
 
CREATE TABLE `contact_us` (
  `id` int(11) NOT NULL,
  `type` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `topic` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mobile` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `subject` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `message` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `file` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
--
-- Contenu de la table `contact_us`
--
 
INSERT INTO `contact_us` (`id`, `type`, `topic`, `name`, `email`, `mobile`, `subject`, `message`, `file`, `datetime`) VALUES
(1, '', '', 'cortana', 'test@gmail.com', '8602650456', 'this is test message', 'this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message ', '', '2016-12-15 09:38:11'),
(2, '', '', 'cortana', 'test@gmail.com', '8602650456', 'this is test message', 'this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message ', '', '2016-12-15 09:38:14'),
(3, '', '', 'cortana', 'test@gmail.com', '8602650456', 'this is test message', 'this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message ', '', '2016-12-15 09:38:16'),
(4, '', '', 'cortana', 'test@gmail.com', '8602650456', 'this is test message', 'this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message this is detailed message ', '', '2016-12-15 09:38:18'),
(5, 'passenger', 'I have a technical problem', '', 'test@gmail.com', 'sdas', 'dasdas', 'sadasd', 'o7CPv1497078680.jpg', '2017-06-10 07:11:20'),
(26, '', '', '', '', '', '', '', '', '2017-06-30 09:14:55'),
(27, '', '', '', '', '', '', '', '', '2017-06-30 09:15:20'),
(28, '', '', '', '', '', '', '', '', '2017-07-07 14:48:00');
 
--
-- Index pour les tables exportées
--
 
--
-- Index pour la table `contact_us`
--
ALTER TABLE `contact_us`
  ADD PRIMARY KEY (`id`);
 
--
-- AUTO_INCREMENT pour les tables exportées
--
 
--
-- AUTO_INCREMENT pour la table `contact_us`
--
ALTER TABLE `contact_us`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

Jusqu'à ID 5 ça fonctionnait, mais après plus rien des infos ne s'affiche dans la BD, seulement l'ID créé

Et voici la portion de code dans mon fichier php

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
 
 
 
 
<div class="row contact-form-section u-hide">
						<form name="contact" method="post" action="" class="contact-form span6 elem-visible" id="contact_form" enctype="multipart/form-data">
							<h2 id="contact-form-title" class="margin-bottom size24">
								<?php echo _("Contact us");?>
							</h2>
							<div class="control-group contact-category margin-top">
								<div class="control-group ">
									<div class="c-chunk LegoTheme controls">
										<div class="contact-radio-container u-padding-all">
											<ul class="u-reset">
												<li class="u-inlineBlock">
													<label class="u-textBold u-alignCenter" for="passenger" data-input-id="passenger">
														<span class="c-item-label">
															<?php echo _("I'm a passenger");?>
														</span><br>
														<span>
															<span class="c-control u-padding-top">
																<input type="radio" name="type" value="passenger" class="type">
															</span>
														</span>
													</label>
												</li>
												<li class="u-inlineBlock">
													<label class="u-textBold u-alignCenter" for="driver" data-input-id="driver">
														<span class="c-item-label">
															<?php echo _("I'm a driver");?>
														</span><br>
														<span>
															<span class="c-control u-padding-top">
																<input type="radio" name="type" value="driver" class="type">
															</span>
														</span>
													</label>
												</li>
												<li class="u-inlineBlock">
													<label class="u-textBold u-alignCenter" for="other" data-input-id="other">
														<span class="c-item-label">
															<?php echo _("Non-members");?>
														</span><br>
														<span>
															<span class="c-control u-padding-top">
																<input type="radio" name="type" value="non-member" class="type">
															</span>
														</span>
													</label>
												</li>
											</ul>
										</div>
									</div>
								</div>
								<div class="control-group topic-section u-hide">
									<div class="controls">
										<select id="topic" name="topic" class="select-contact input-block-level margin-bottom" title="Please choose">
										</select>
									</div>
								</div>
							</div>
 
 
							<div id="contact-form-content" class="elem-visible u-hide">
								<div class="js-contact-top-text margin-half-vertical size14">Send us a note</div>
								<div class="control-group">
									<div class="controls">
										<input type="text" id="subject" name="subject" class="input-block-level" title="Subject" placeholder="Subject">
									</div>
								</div>
 
								<div class="control-group">
									<div class="controls">
										<textarea id="message" name="message" class="input-block-level" title="Message" placeholder="Message" rows="5"></textarea>
									</div>
								</div>
 
								<div class="control-group">
									<div class="controls">
										<input type="email" id="email" name="email" class="input-block-level" title="Your email address" placeholder="Your email address">
									</div>
								</div>
 
								<div class="control-group">
									<div class="controls">
										<input type="text" id="mobile" name="mobile" class="input-block-level" title="Your mobile number" placeholder="Your mobile number">
									</div>
								</div>
 
								<div class="fileupload fileupload-new u-hide" data-provides="fileupload">
									<div class="input-append" >
										<label for="contact_file"><?php echo _("Screenshot or PDF - optional");?></label>
										<div class="uneditable-input span3">
											<i class="icon-file fileupload-exists"></i>
											<span class="fileupload-preview"></span>
										</div>
										<span class="btn btn-file">
											<span class="fileupload-new">Attach</span>
											<span class="fileupload-exists">Change</span>
											<input type="file" id="file" name="file" accept="image/png, image/jpeg, image/jpg, image/gif, application/pdf, application/x-pdf" >
										</span>
										<a href="#" class="btn fileupload-exists" data-dismiss="fileupload">Remove</a>
									</div>
								</div>
								<div class="control-group ">
									<div class="controls">
										<button type="submit" name="send" class="Button Button--primary Button--big  Button--full apply-btn-loader" >Send</button>
									</div>
								</div>
							</div>
						</form>
					</div>
				</div>
			</div>
		</div>

suite

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
 
 
<script>
 
	$(document).ready(function(){
 
		$.validator.addMethod('filesize', function (value, element, param) {
			return this.optional(element) || (element.files[0].size <= param)
		}, 'File size must be less than {0}');
 
		$.validator.setDefaults({ 
			ignore: [],
		});
 
		$('#contact_form').validate({
			rules: {
				type: 'required',
				topic: 'required',
				subject: 'required',
				message: 'required',
				email: 'required',
				file: {
					extension :"jpg|jpeg|png|pdf|x-pdf",
					filesize :5242880,
				},
			},
 
			messages: {
				type: 'Select type',
				topic: 'Select topic',
				subject: 'Enter subject',
				message: 'Enter message',
				email: 'Enter email',
				file: {
					extension :"jpg|jpeg|png|pdf|x-pdf",
					filesize :5242880,
				},
			},
 
			errorPlacement: function (error, element) {
				if(element.is(':checkbox') || element.is(':radio')) {
					var controls = element.closest('div[class*="col-"]');
					if(controls.find(':checkbox,:radio').length > 1) controls.append(error);
					else error.insertAfter(element.parent().parent());
				}
				else if(element.is(':file')) 
				{
					error.insertAfter(element.parent());
				}
				else error.insertAfter(element);
			},
			highlight: function (e) {
				$(e).parent().focus();
			},
 
			submitHandler: function (form) {
				form.submit();
			},
			invalidHandler: function (form) {
			}
		});
 
 
 
 
 
		$('.contact_us').click(function(){
			$(this).hide();
			$('.contact-form-section').removeClass('u-hide');
		});
		$('.type').click(function(){
			$('.topic-section').removeClass('u-hide');
			$('.fileupload').addClass('u-hide');
			$('#file').val('');
			var type=$('input[name=type]:checked').val()
			if(type=='passenger')
			{
				$('#topic').html('	<option value="" selected="selected">Help topics</option>\
									<option value="I have a question about how the site works" >I have a question about how the site works</option>\
									<option value="I\'ve lost my username and/or password" >I\'ve lost my username and/or password</option>\
									<option value="I have a technical problem" >I have a technical problem</option>\
									<option value="Contact us" >Contact us</option>\
									<option value="Other" >Other</option>\
								');
			}
			if(type=='driver')
			{
				$('#topic').html('	<option value="" selected="selected">Help topics</option>\
									<option value="I have a question about how the site works" >I have a question about how the site works</option>\
									<option value="I\'ve lost my username and/or password" >I\'ve lost my username and/or password</option>\
									<option value="I have a technical problem" >I have a technical problem</option>\
									<option value="Contact us" >Contact us</option>\
									<option value="Other" >Other</option>\
								');
			}
			if(type=='non-member')
			{
				$('#topic').html('	<option value="" selected="selected">Help topics</option>\
									<option value="I have a question about how the site works" >I have a question about how the site works</option>\
									<option value="I\'m a journalist" >I\'m a journalist</option>\
									<option value="I\'m a business" >I\'m a business</option>\
									<option value="I represent a community (campus, council, etc.)" >I represent a community (campus, council, etc.)</option>\
									<option value="I would like to propose a partnership" >I would like to propose a partnership</option>\
									<option value="I have a technical problem" >I have a technical problem</option>\
									<option value="Contact us" >Contact us</option>\
									<option value="Other" >Other</option>\
								');
			}
		});
		$('#topic').change(function(){
			$('#contact-form-content').removeClass('u-hide');
			var topic=$(this).val()
			if(topic=='I have a technical problem')
			{
				$('.fileupload').removeClass('u-hide');
			}
			else
			{
				$('.fileupload').addClass('u-hide');
				$('#file').val('');
			}
		});
		$('.type').click(function(){
			$('.topic-section').removeClass('u-hide');
		});
	});
</script>

et re suite

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
 
 
<?php 
include_once('functions/functions.php');
if(isset($_POST['send']))
{
	unset($_POST['send']);
 
	if(!empty($_FILES['file']['name'])){
		$file['files']=$_FILES['file'];
		$file['destination']='contact_us_attachment';
		$_POST['file']=upload_file($file);
	}
	$table['table']='contact_us';
	$table['values']=$_POST;
	if(mysqli_insert($table))
	{
		foreach($ADMIN_EMAIL as $val)
		{
			$EMAIL['email']=$val;
			$EMAIL['title']="New enquiry recieved from website";
			$EMAIL['body']="<h3>Hi admin,</h3><br>
							<p> you recieved a new enquiry<p>
							<table>
								<tbody>
									<tr>
										<th>Type of member</th>
										<th>:</th>
										<td>{$_POST['type']}</td>
									</tr>
									<tr>
										<th>Topic</th>
										<th>:</th>
										<td>{$_POST['topic']}</td>
									</tr>
									<tr>
										<th>Email</th>
										<th>:</th>
										<td>{$_POST['email']}</td>
									</tr>
									<tr>
										<th>Mobile</th>
										<th>:</th>
										<td>{$_POST['mobile']}</td>
									</tr>
									<tr>
										<th>Subject</th>
										<th>:</th>
										<td>{$_POST['subject']}</td>
									</tr>
									<tr>
										<th>Message</th>
										<th>:</th>
										<td>{$_POST['message']}</td>
									</tr>
									<tr>
										<th>File</th>
										<th>:</th>
										<td><a href='$URL/contact_us_attachment/{$_POST['file']}'>{$_POST['file']}</a></td>
									</tr>
									<tr>
										<th>Sent on</th>
										<th>:</th>
										<td>".strftime('%d %b %Y %H:%M:%S',strtotime(date('Y-m-d H:i:s')))."</td>
									</tr>
								</tbody>
							</table>
							";
 
				$mail_print=send_mail($EMAIL);
		}
 
 
		$success=true;
	}
	else
	{
		$success=false;
	}
}
?>

Merci

13/09/2017, 08h39
Invité

Bonjour,

Merci de NE PAS cliquer inutilement* sur le bouton "Répondre avec citation".

Il faut utiliser le bouton "+ Répondre à la discussion" ci-dessous, en bas à gauche.

* surtout que tu ne réponds pas aux questions qu'on te pose...
13/09/2017, 09h30
miramar

@ jreaux62

Bonjour,

merci pour ces informations car je ne savais pas qu'il fallait employer "répondre à la discussion", étant débutant sur le site comme en php/Mysql

Répondre à la question : je pense avoir tout mis comme infos ! sinon je ne vois pas.

Cordialement
Pat
13/09/2017, 09h37
Inazo

En fait ma question était qu'y-a-t-il dans la variable $query à ce moment là :

Code:

$query="INSERT INTO $table ($columns) VALUES ($valuess)";

Dans ta fonction mysqli_insert() ?

On verra si tes POST sont bien passé mais à mon avis il y un soucis de ce côté là.

@+
13/09/2017, 10h05
Invité
1/ Quand on est débutant, il faut apprendre avant tout le "débogage de base" :
- afficher les variables
Code:

echo $ma_variable;
- afficher les tableaux
Code:

var_dump( $mon_array );

ou

Code:

echo '<pre>'; print_r( $mon_array ); echo '</pre>';

En clair : savoir ce qu'on fait, ce qu'on récupère ou transmet.

2/ ATTENTION aussi à la casse (majuscules/minuscules) : id est différent de Id.

3/ Enfin (?), faire une insertion en bdd sans requête préparée ou , au minimum, vérifier/protéger les paramètres transmis, est suicidaire...