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

**miramar** · 12/09/2017, 15h37

Bonjour à tous et à toutes,

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

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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

**Inazo** · 12/09/2017, 15h54

Bonjour,

La fonction mysqli_insert n'existe pas dans PHP.

@+

**miramar** · 12/09/2017, 16h23

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 ?

**miramar** · 12/09/2017, 16h26

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

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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;
 
		}

**miramar** · 12/09/2017, 16h29

Désolé voici le code oupss !

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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;
 
		}	
 
	}

**Inazo** · 12/09/2017, 16h39

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

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

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

$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 ?

@+

**miramar** · 13/09/2017, 08h10

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 :

Sélectionner tout - Visualiser dans une fenêtre à part

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éé

**miramar** · 13/09/2017, 08h16

Et voici la portion de code dans mon fichier php

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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 :

Sélectionner tout - Visualiser dans une fenêtre à part

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 :

Sélectionner tout - Visualiser dans une fenêtre à part

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

Invité · 13/09/2017, 08h39

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...

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

PHP & Base de données

Vue hybride

Discussions similaires

Partager

Partager