Byjumbo125
Hello everyone
I often write some data into my databases using MySQL PHP.
Now I have a database with almost 40 columns.
the mysql code is getting incredibly long…..
Is there a clear way of writing this?
Thank you
LG Jumbo
(1 votes)
Loading...Hi, I wanted to know what it's like. I'm currently working at a bank, but since the salary is very low and I've always been interested in something like programming, I wanted to know how I can even get started as a career changer. I've heard of a free training course funded by the job…
If you select the checkbox, a value "2" should come, otherwise if it is not selected, then value "1" <div class="col-xs-4">{if $pdf}<span class="span-checkbox{if isset($values.Krank_0)} span-checkbox-checked{/if}"></span> Masern{else}<label class="checkbox-inline"><input type="checkbox" name="Masern" id="Masern" value="1"> Masern</label>{/if}</div>
Hi, I'm currently following the unity Junior program and I'm a bit stuck at 1.2 In the attached video, you can see the guy using autocomplete, and I've actually followed everything as instructed so far (with a few changes where it doesn't make a difference; for example, I used a roadblock instead of a box;…
I was just about to open a new Unity project in 2D, and now it's been loading for an hour. Do you have a solution?
Good morning! I would like to report the current status of policy compliance in a subscription. So I pull the following data: $azState = Get-AzPolicyStateSummary -SubscriptionId $subscriptionId $exportObject.Compliance.TotalRessources = $azState.Results.ResourceDetails[0].Count + $azState.Results.ResourceDetails[1].Count + $azState.Results.ResourceDetails[2].Count $exportObject.Compliance.CompliantRessources = $azState.Results.ResourceDetails[0].Count $exportObject.Compliance.NonCompliantRessources = $azState.Results.ResourceDetails[1].Count $exportObject.Compliance.Exceptions = $azState.Results.ResourceDetails[2].Count $exportObject.Compliance.Percentage = [math]::Round((1.0 – $exportObject.Compliance.NonCompliantRessources / ($exportObject.Compliance.CompliantRessources + $exportObject.Compliance.NonCompliantRessources + $exportObject.Compliance.Exceptions)) *…
00 00 00 00 00 00 00 00 white=00 00 00 00 00 00 00 00 00 red=11 00 00 01 00 00 01 00 00 blue=01 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 11 00 00 00 00 11 00 00 00 11 11…
I found a creative way in a Dart Library.
A map (Key-Value object) is used there. The key is the column name and value of the value to be added to the database. This then forms the SQL statement.
Here find the relevant code detail on GitHub.
You need to adjust it to the PHP Syntax and PHP objects.
If you only set a key and value per line when creating the map, it is clear, even if it contains 40 columns or Code lines will be a little long.
select into says nothing to me. You mean insert?
When you collect some data, you only need to specify some columns.
Other columns can be automatically filled with data, such as the capture time. Is specified when defining the columns.
A database has no columns. You have a database table with 40 fields or attributes.
How to make your SQL statement together within PHP will be left to you. It only has to have the correct syntax when using it.
And no one says you can’t put your statement together as a string of clearer blocks.
Okay, I understand what you mean. I could also scream down the fields in a php array and then put a string together by grinding….
then I don’t always have to repair everything in the long string chain…