#What is a PHP Developer?

[valueadsservices]

What is a PHP Developer?

A polished listing on a reputable platform builds consumer trust and confidence. From kirana stores to fashion boutiques—visibility = sales. Plumbers, photographers, tutors—stand out in your area. Build credibility and increase reach in your business niche. Banquet halls, caterers, DJs—Value Ads is the go-to platform for local discovery. No need to scroll endlessly—find reliable businesses near you in minutes. Get updated deals, contact numbers, directions—all in one click.

[tpointtechblogs]

What is PHP Developer? A Complete Beginner’s Guide

visit the blog : https://penzu.com/public/9aeec77156b814b6

visit for more blogs :

https://dev.to/tpointtechblog/kickstart-your-coding-career-learn-typescript-today-4ogk

https://tpointtechblog.hashnode.dev/from-zero-to-dashboard-power-bi-tutorial-for-absolute-beginners

https://medium.com/@tpointtechblog/what-is-django-used-for-benefits-features-real-world-use-cases-67932cd53a3f

https://www.linkedin.com/pulse/what-apache-kafka-used-benefits-real-world-examples-udhav-khera-4makc

https://sites.google.com/view/what-is-my-sql/home

https://tpointtechblog.blogspot.com/2025/06/the-ultimate-nodejs-tutorial-for.html

[infoanalysishub]

Introduction to PHP for Beginners

Start your PHP journey with this beginner-friendly guide Introduction to PHP. Learn what PHP is, how it works, why it’s used, and how to write your first PHP script. Perfect for aspiring web developers. Introduction to PHP for Beginners | Learn PHP Basics for Web Development PHP (Hypertext Preprocessor) is a widely-used open-source scripting language especially suited for web development. It’s…

[hostitsmartcanada]

Discover what’s the use of PHP in web development & know why PHP remains a powerhouse choice for developers worldwide. Read the complete guide in detail!

[sabelacarsonsblog]

PHP Frameworks: Which One Is Right For Your Next Project?

Versatile and interactive, PHP is a scripting language ideal for dynamic websites. Explore a curated list of top PHP frameworks tailored for your website needs.

[the-nox-syndicate]

SysNotes devlog 1

Hiya! We're a web developer by trade and we wanted to build ourselves a web-app to manage our system and to get to know each other better. We thought it would be fun to make a sort of a devlog on this blog to show off the development! The working title of this project is SysNotes (but better ideas are welcome!)

What SysNotes is✅:

A place to store profiles of all of our parts

A tool to figure out who is in front

A way to explore our inner world

A private chat similar to PluralKit

A way to combine info about our system with info about our OCs etc as an all-encompassing "brain-world" management system

A personal and tailor-made tool made for our needs

What SysNotes is not❌:

A fronting tracker (we see no need for it in our system)

A social media where users can interact (but we're open to make it so if people are interested)

A public platform that can be used by others (we don't have much experience actually hosting web-apps, but will consider it if there is enough interest!)

An offline app

So if this sounds interesting to you, you can find the first devlog below the cut (it's a long one!):

(I have used word highlighting and emojis as it helps me read large chunks of text, I hope it's alright with y'all!)

Tech stack & setup (feel free to skip if you don't care!)

The project is set up using:

Database: MySQL 8.4.3

Language: PHP 8.3

Framework: Laravel 10 with Breeze (authentication and user accounts) and Livewire 3 (front end integration)

Styling: Tailwind v4

I tried to set up Laragon to easily run the backend, but I ran into issues so I'm just running "php artisan serve" for now and using Laragon to run the DB. Also I'm compiling styles in real time with "npm run dev". Speaking of the DB, I just migrated the default auth tables for now. I will be making app-related DB tables in the next devlog. The awesome thing about Laravel is its Breeze starter kit, which gives you fully functioning authentication and basic account management out of the box, as well as optional Livewire to integrate server-side processing into HTML in the sexiest way. This means that I could get all the boring stuff out of the way with one terminal command. Win!

Styling and layout (for the UI nerds - you can skip this too!)

I changed the default accent color from purple to orange (personal preference) and used an emoji as a placeholder for the logo. I actually kinda like the emoji AS a logo so I might keep it.

Laravel Breeze came with a basic dashboard page, which I expanded with a few containers for the different sections of the page. I made use of the components that come with Breeze to reuse code for buttons etc throughout the code, and made new components as the need arose. Man, I love clean code 😌

I liked the dotted default Laravel page background, so I added it to the dashboard to create the look of a bullet journal. I like the journal-type visuals for this project as it goes with the theme of a notebook/file. I found the code for it here.

I also added some placeholder menu items for the pages that I would like to have in the app - Profile, (Inner) World, Front Decider, and Chat.

i ran into an issue dynamically building Tailwind classes such as class="bg-{{$activeStatus['color']}}-400" - turns out dynamically-created classes aren't supported, even if they're constructed in the component rather than the blade file. You learn something new every day huh…

Also, coming from Tailwind v3, "ps-*" and "pe-*" were confusing to get used to since my muscle memory is "pl-*" and "pr-*" 😂

Feature 1: Profiles page - proof of concept

This is a page where each alter's profiles will be displayed. You can switch between the profiles by clicking on each person's name. The current profile is highlighted in the list using a pale orange colour.

The logic for the profiles functionality uses a Livewire component called Profiles, which loads profile data and passes it into the blade view to be displayed. It also handles logic such as switching between the profiles and formatting data. Currently, the data is hardcoded into the component using an associative array, but I will be converting it to use the database in the next devlog.

New profile (TBC)

You will be able to create new profiles on the same page (this is yet to be implemented). My vision is that the New Alter form will unfold under the button, and fold back up again once the form has been submitted.

Alter name, pronouns, status

The most interesting component here is the status, which is currently set to a hardcoded list of "active", "dormant", and "unknown". However, I envision this to be a customisable list where I can add new statuses to the list from a settings menu (yet to be implemented).

Alter image

I wanted the folder that contained alter images and other assets to be outside of my Laravel project, in the Pictures folder of my operating system. I wanted to do this so that I can back up the assets folder whenever I back up my Pictures folder lol (not for adding/deleting the files - this all happens through the app to maintain data integrity!). However, I learned that Laravel does not support that and it will not be able to see my files because they are external. I found a workaround by using symbolic links (symlinks) 🔗. Basically, they allow to have one folder of identical contents in more than one place. I ran "mklink /D [external path] [internal path]" to create the symlink between my Pictures folder and Laravel's internal assets folder, so that any files that I add to my Pictures folder automatically copy over to Laravel's folder. I changed a couple lines in filesystems.php to point to the symlinked folder:

And I was also getting a "404 file not found" error - I think the issue was because the port wasn't originally specified. I changed the base app URL to the localhost IP address in .env:

…And after all this messing around, it works!

(My Pictures folder)

(My Laravel storage)

(And here is Alice's photo displayed - dw I DO know Ibuki's actual name)

Alter description and history

The description and history fields support HTML, so I can format these fields however I like, and add custom features like tables and bullet point lists.

This is done by using blade's HTML preservation tags "{!! !!}" as opposed to the plain text tags "{{ }}".

(Here I define Alice's description contents)

(And here I insert them into the template)

Traits, likes, dislikes, front triggers

These are saved as separate lists and rendered as fun badges. These will be used in the Front Decider (anyone has a better name for it?? 🤔) tool to help me identify which alter "I" am as it's a big struggle for us. Front Decider will work similar to FlowCharty.

What next?

There's lots more things I want to do with SysNotes! But I will take it one step at a time - here is the plan for the next devlog:

Setting up database tables for the profile data

Adding the "New Profile" form so I can create alters from within the app

Adding ability to edit each field on the profile

I tried my best to explain my work process in a way that wold somewhat make sense to non-coders - if you have any feedback for the future format of these devlogs, let me know!

~~~~~~~~~~~~~~~~~~

Disclaimers:

I have not used AI in the making of this app and I do NOT support the Vibe Coding mind virus that is currently on the loose. Programming is a form of art, and I will defend manual coding until the day I die.

Any alter data found in the screenshots is dummy data that does not represent our actual system.

I will not be making the code publicly available until it is a bit more fleshed out, this so far is just a trial for a concept I had bouncing around my head over the weekend.

We are SYSCOURSE NEUTRAL! Please don't start fights under this post

[artsygirl0315]

The Circus is here?? | Old KND OCs

More old KND OCs that I remembered making at my early stages of hyperfixing Codename Kids Next Door, This was what Sector PHP was supposed to be in earlier development and I think you can distinct who was who.

I named them as Sector BT for Big Top or Bug Top, which in my defense was very clever for their concept.

I had inspired them in a Circus-esque theme but make them also related bugs, I still don't know what got in my head for the idea but why the heck not??

The members of Sector BT are as followed;

Luther Religiosa- Praying Mantis

Orion Leiurus- Scorpion

Jojo Pipiens- Mosquito

Melody Centi- Centipede

Eliza Widow- Spider

I'll explain the mechanics of them another time if anyone's interested.

[wojenka]

i need more mutuals who are into coding and engineering!! more info under the cut!!

I planned to become an electrical engineer like my stepdad but then I decided to change my path to programming. I'm currently studying at technikum (<- wikipedia link so I don't have to explain the whole polish learning system), programmer major.

this year I have exams from web development (10th Jan - theory, 16th Jan - practical exams) and next year I have exams from App development (both mobile and desktop).

I know C family languages, Java, Python and those ones I am currently using. I also know a bit of Kotlin and I think I will continue learning it.

For web dev I know HTML and CSS ofc but also PHP and JS.

Planning on learning more languages I can use for App and operating system development as well as just to know them cause I want to after this year's exams!

my learning list:

Lua (I heard it's easy but I can't really get myself to read anything about this atm idk why)

Ruby

Assembly

Rust

As for electrical engineering I don't know much tbh but I would like to learn! I just used CAD programs for technical drawings (dad taught me some basic things when I was still thinking about going his path) helped my dad fix things on his Solar farm, houses of our neighbors and I made a few very simple circuits for fun a few years ago. Now I'm mostly focused on programming but since I learned most of the things I need for exams I have more time to do whatever I want now!

I'd like to get to know more people so I can share and mostly learn new things since even though I'm coding for years I consider myself a beginner and I am a total beginner when it comes to electrical engineering.

I'm willing to be friends or at least mutuals with anyone who codes or makes websites or is in STEM! no matter what your specialty/interest is exactly and no matter if you are a total beginner or a professional ^__^

I'd also like to have some mutuals who are into old web development and retro computing!!!!!!!!

edit: I forgot but I'm also interested in physics and quantum physics

[webfarmhouses-blog]

Web designer in Jodhpur

Creative Web Design

We are a web designing company that has a team of skilled and experienced web designers and developers who can create stunning and functional websites for any type of business or domain. We offer a variety of web designing services, such as custom web design, web development, web hosting, SEO, and maintenance. We also provide you with a free web design consultation, where we can discuss your goals, needs, and preferences, and provide you with a web design proposal that suits your requirements and expectations.

What we do in Web Design

Our web designing services are the services that provide web designing solutions for clients who want to create or improve their online presence. It involves the use of various elements such as colours, fonts, images, graphics, animations, and interactions to convey the message and purpose of the website to visitors. Web designing services can help clients with various aspects of web designing, such as Consultation: Our web designing services can help clients understand their goals, needs, and preferences, and provide them with expert advice and guidance on how to achieve them . Strategy: Our services can help clients develop a clear and effective web design strategy that aligns with their brand identity, target audience, and business objectives.Design: We help clients create a unique and attractive web design that reflects their vision and personality, and that engages and impresses their visitors.Launch: Our services can help clients launch their website to the public, and provide them with web hosting, domain registration, and security services.

Our Design Technology

At Web Farm House, we understand that web design is not just about making a website look good. It is also about making it work well, communicate effectively, and provide value to the users. That is why we use the latest web design technology to create websites that are:

Visually appealing: We use web graphic design to create stunning and consistent visual elements for your website, such as colours, fonts, images, icons, and animations.

Easy to use: We use user interface design to create intuitive and interactive elements for your website, such as buttons, menus, forms, and navigation.

Functional and reliable: We use web development to code and program your website, using languages such as HTML, CSS, JavaScript, PHP, and others. We follow the principles of web standards, web accessibility, web performance, and web security, to ensure the quality and reliability of your website.

Our Work Process

At Web Farm House, we follow a systematic and collaborative work process to create your website. Our work process consists of four main phases: Discovery, Design, Development, and Delivery:

Discovery: This is the phase where we get to know you and your project. We will ask you some questions about your goals, needs, preferences, budget, and timeline. We will also conduct some research on your industry, competitors, and target audience. Based on the information we gather, we will create a project proposal and a contract for you to review and approve.

Design: This is the phase where we create the visual and interactive elements of your website. We will start by creating a sitemap and a wireframe, which are the blueprints of your website’s structure and layout. We will then create a mockup, which is a prototype of your website’s appearance and functionality. We will present the mockup to you and ask for your feedback and approval. We will make any revisions as needed until you are satisfied with the design.

Development: This is the phase where we code and program your website. We will use the latest web development technology to create a website that is functional, reliable, and compatible with different devices and browsers. We will also test and debug your website to ensure its quality and performance. We will show you the progress of the development and ask for your feedback and approval.

Delivery: This is the final phase where we launch and maintain your website. We will upload your website to your chosen hosting service and domain name. We will also provide you with a user manual and a training session on how to use and update your website. We will also offer you ongoing support and maintenance services to keep your website running smoothly and securely.

We will also listen to your feedback and suggestions and make any changes as needed. We will work with you as a partner and a friend, not just as a client and a vendor. we value your input and satisfaction throughout the work process. We will communicate with you regularly and keep you updated on the status of your project.

Our Web Designing Services

Our is provides web design services for clients who want to create or improve their online presence. We help clients with various aspects of web designing, such as consultation, strategy, design, development, testing, launch, and maintenance:

Static web design

Liquid web design.

Adaptive web design.

Dynamic web design.

Responsive web design.

Single-page web design.

Why Choose Us?

We are a One-Stop Solution for delivering the best web design and development services. We render customized and affordable web design facilities to suit your requirements. Choose the best plans for building a responsive web design according to your needs:

Excellent technical support

Core PHP &Codeigniter + MySQL.

Secure and Reliable coding.

Satisfactory Customer Support.

SEO-friendly web development.

[valueadsservices]

What is a PHP Developer?

With the integration of AI and automation, business listing websites will become more intuitive, offering smart recommendations and enhanced customer engagement. A business listing website like Value Ads Services is essential for enterprises in Delhi/NCR to grow their online presence and attract potential customers. By leveraging SEO benefits, customer reviews, and a user-friendly platform, businesses can thrive in today’s digital age.

[kremlin]

I do computer work but it's not very hard and kind of boring. How do I get to do hard computer work? Do I have to go to grad school?

hi i tend to miss these because of slipshod ublock custom filters im too birdbrained to fix.

i worked for a large american technology company which sold business machines internationally for close to a decade until laid off in successful accounting fraud scheme a few years ago. started as developer, erm, pardon me, i started as

junior developer

which is a role similar to routinely-executed court jester and human meatwave conscript meant to soak up enemy bullets to cause exhaustion of enemy bullet supply and finally guy that comes in big gross truck with a pump and a tank and a big hose used to suck the shit+piss out of portable toilet/malfunctioning sewer etc. this is for when you are 20 years old or so and they hit you with this work to calm your ass down a bit. my case was cloud bullshit on ancient rickety php stack. 5% keystrokes/clicks are php, 95% remainder is jira and other members of the axis of evil. LOT of dick sucking and butt fucking. Going into men's bathroom and making eye contact with cubicle neighbor before entering stall and fearlessly making disgusting noises. microwaving fish lunch thrice daily. you get the idea. meager paycheck but six figures takehome technically

next is staff dev, wait, god damn fucking tumblr, you can't adjust fonts mid-paragraph, and Big Text is just another type of font, in case you wanted Big Specific font. fucking fuck hold on. next step is

staff developer

no effective change besides greatly increased workload (click those motherfucking jira buttons!! suffer coworker's asinine bad-faith code review comments that HE AND HE ALONE must manually accept your responses to, on HIS time, before you are allowed to click the jira buttons that start the human meat sausage factory to get your 20 line maximum change into an RC and then release and then push candidate and then prod push!! pay raise one thousand dollars annually (lol). Emails. Now you deal with project manager too. speculate as to what sorts of grievous head injuries that man must suffer daily to describe his logic. his job is like the guy from office space that brings documents from one desk to another but he randomly reorders the words on the page in-flight. make plausibly-deniable wife fucking jokes about his wife in earshot. you're almost at the top of the suffering function. next is, no fucking cute font this time, senior developer, sounds cool right, lol, lmao, "senior" "developer" is like "tallest" "midgit".

no pay increase no workload increase but now manager emails you about extremely, extremely personal issues he's facing and also makes his most difficult problems from his boss your problems. one week will pass and then they will hit you with the "we're considering you for a team lead position". answer:

NO

answer no as this is the prescribed path, you take that role, you are maxxed out in workload, you are dealing with forty employee's worth of bullshit, another one thousand dollarinos a year raise, employer has solved efficiency problem with your sanity and burnout as variables. you're supposed to quit or kill yourself within seconds of hitting 30 y/o. don't fall for tricks. say "NO" in a creative way such as "i have tabulated some data and made it into excel pie chart quantifying diff. departments work output and am considering sending it to whoever Dave is, the guy that is one or two or three report levels over your boss' head, you know, his boss' boss' boss or whatever. or say "you are harassing me sexually, racistly" that kind of shit. make threat clearly.

was worth mentioning before, throughout all of this make as many friends and as much of a splash for yourself as possible as its time to trade on that goodwill, tell your boss you want an open relationship and you're going to fuck and suck other managers, and then find the good one with the good team of old fucking geriatric guys who could never be fooled into working more than a reasonable amount daily and also can kill people with their minds since they have been sitting on the bleeding edge of computing since 1969. their boss will usually be, suspiciously, one report rank higher than everyone else. e.g. their boss has a whole other boss + his reports under him. usually small team. go to their boss, say, hi, look at me, look at my beautiful plumage and captivating mating dance, please hire me, pleassseee. his team will say no, they will say things like "I don't know about that kiddo", "That guy seems like a candy-ass", they will read your papers and look at you in the eyes and say it is not compelling, the boss will kind of hire you anyway. if he doesn't you're fucked. if he does you're now a

STAFF ENGINEER

for fifteen minutes and then

ADVISORY/SENIOR/SPECIAL ENGINEER

and the suffering is over. no code minimal jira + squad of gremlin zerglings under your boss whom you can rank-pull and delegate bullshit to, they will be mostly suckers, take advantage of this. 80% of keystrokes/clicks will be in production of beautiful wonderful lovely .docx and .xlsx's, what a godsend, only in an emergency are you allowed to fuck with your zergling's code, usually in a cool way with bullshit procedure removed.

i worked on high performance computing shit. "what the fuck do you mean 2PB or so in and out a day on flash memory", "what the fuck do you mean special infiniband intel MPI library on CD-R stored in Craig's filing cabinet???". Meetings with company people: webcams off, responses optional, snideness allowed. Meetings with client: you must have your dress shirt starched and white glove the shit out of those motherfuckers. timezones = skill issue. i don't care where germany is, i don't give a shit, wake up at 3am for a 20m meeting i take on the toilet or while eating a boiled lobster complete with cracker + lobster bib. customers countable on one hand, invoices to customers not countable with 32 bits. no fucking mistakes ever allowed except for like whitepaper drafts, you cannot fuck the pumpkin on this one, your actual job relies on your ability to hit a button and suck down a week's worth of compute and millions of dollars, boiling swimming pool's worth of TDP, one mistake that leads result data to being able to be characterized as flawed and your balls are getting ripped off. Quarterly IRL meetings = normiepilled normiemaxxing. Dress sharp. leave at 5pm on the dot, go to bar with Old Fucker coworkers, drink wrecklessly with them, have a blast, let them give you a tour of a lab you are absolutely 100% not allowed to be inside, buildings that have posted weight limits per sq. ft. exceeding 250lbs, such a blast. every paycheck a FORTUNE every dinner a banquet every meeting an email every keystroke life or death. you get to meet /lib/doug mofos too one of whom i wrote a very poor kind of poem thing about. thats about it. hope this helps

[kommandonuovidiavoli]

(Henlo Grandma! Hope you're doing okay on your end, sending virtual hugs and cookies!!🍪💙)

If it's okay and hopefully you don't feel too pressured, I've got a few usernames for the game!

@kandykatz

@numbuhinfinitys

@numbuh-72

@artsygirl0315

You can choose whomever and obv not forcing this, hope you're having a great day still!!

AAAAAH!! THE SQUAD!!! THE BEST OC SQUAD!!!

I'll go with ALL of them because I have THINGS TO SAY!

@kandykatz One of the first KND oc artists I saw around when I joined the fandom, and I still love to see her designs/stories pop up from time to time! She improved A LOT since one year ago, for anatomy, colouring and overall composition of pieces! I especially love how she draws the faces of her characters, similar to the KND style, but that could work on their own perfectly! Unfortunately, personality-wise we haven't chatted a lot, and she seems to be either shy or of few words, so I try not to bother too much!

Can't wait for what I saw on Insta about some redesigns!!!

--

@numbuhinfinitys CHILD!! GRANDCHILD OF EUROPE!!! Really funny and with great ideas, I love giving advice to her and plot things on any of my aus or her ideas! She's one of the few in my time zone (she lives literally above me lol), and understands my struggles as an European! Sometimes I wish I could hug her when I see some sad posts, but I'm always afraid I would push boundaries or sound creepy... Art-wise, her art is really expressive, and she improved greatly this year as well! I couldn't do expressions like that at her age LMAO (I have proof).

Maybe right now she's a bit low on inspo or school is kicking ass... Hope she'll be ok soon! Luff u!!

--

@numbuh-72 Followed along the way because EVERYONE ELSE was talking about her and Gianna, so I wanted to... oh crap I just realized I haven't followed this account Y E T *follows*. There we go! Love her stories and art, they remind me of an anime/manga plot with some typical elements, and honestly??? Nice! I love manga-like structures with "ki-sho-ten-ketsu" building! Art style is growing, and I hope it keeps getting better and better! Also, she's pretty fun to talk to, and I loved the little RP with Gianna and Irwin!

Saw on Insta that she's working on other stuff, so GOOD LUCK WITH IT!!!

--

@artsygirl0315 One of the first (if not the very first) OC artists I followed! Gotta tell the truth: at first I didn't want to follow any OC artists and just concentrate on KND fanartists, but... OH COME ON, SECTOR PHP IS TOO INTERESTING NOT TO FOLLOW!!! I love how they are colour coordinated, how they have distinct personalities that are slowly changing and developing as the story goes on! Fav is Phoebe (but I bet it's no surprise at all...). I wanted to interact more, so I decided to throw Irwin at them because all other characters aren't born yet when they're kids ahah... Also, Artsy, you're such a good sport, every time I bother you with my ideas, you immediately jump on to give your input (since it always involves your blorbos), and it just gets better and better!!!

Need to sketch about the last idea we talked about for reasons! ;)

--

I love all of you and your ocs and your art, it's tasty and every story keeps me entertained even if I don't interact with them all!!

Keep up the good work!!!

[theveryevilblog]

Haskell > anything else

Haskell is the best programming language because it lets you write a fully functioning web server with three lines of code and zero understanding of how anything works You don't write programs, you declare intentions, and the compiler decides if you're worthy Every other language lets you make mistakes. Haskell waits patiently then destroys your ego at compile time Besides, who needs to 'build skill' in programming anyway?

Not even comparable to python, which is just... so annoyingly uncomplicated and pointless (to make good python syntax you need to make it as un-python as possible) and javascript? Who needs fast languages anyway? So unsatisfying And don't even get me started on C, C++ or C#, which are literally the same language by the way Rust? Bro, just send me the virus already. I don't care PHP? What does that even stand for? Poverty Holding Person? Like you? Java? You stopped being relevant about thirty years ago Swift? Buddy, I do not care about your apple vision pro R? You couldn't even spare another letter? What are you, C-- or something? Ruby? Just admit that Ruby on Rails died last decade... Go? Go where? Out the door? Because currently, that is what Go developers are being asked to do by employers Perl? I don't even know what that language is

[agam-shel-barvadim]

Fun Hebrew fact ג: "double-colon"

A little background in programming: plenty of programming languages make a use of the following operator:

::

Which is basically just the colon symbol twice in a row.

This operator has a name: The scope resolution operator (named after what it's meant to signify, I won't get into it)

But, this operator happened to have another, fairly-commonly-used name.

You see, there's a programming language called PHP which was mostly developed in Israel back in the day (by Zeev Suraski and Andi Gutmans from the Technion in Haifa. Side note: the language was created by the Danish-Canadian programmer Rasmus Lerdorf).

And PHP was one of the first languages to use the scope resolution operator [source needed].

So these two Israelis, when they had to look for a name for that operator - they decided to call it פעמיים נקודותיים, Hebrew for "double-colon". and in English? paamayim nekudotayim. they didn't bother translating it.

And to this very day, there are PHP error message which include the term "paamayim nekudotayim", and to this very day there are people using that term, often without even knowing it's Hebrew.

So that is how Hebrew found its way into programming.

Sidenote: It's actually supposed to be pa'amayim nekudatayim (unless there's some type of Ashke pronounciation that i'm not aware of, which is fairly possible), and this is a common Israeli mistake (using the plural form instead of the singular before the ayim suffix, which means "two").

Bonus: people complaining about the term on Stack Overflow, a website where people ask for help with programming:

Another bonus: PHP's icon becauae I kinda like it:

[codingquill]

SQL Fundamentals #1: SQL Data Definition

Last year in college , I had the opportunity to dive deep into SQL. The course was made even more exciting by an amazing instructor . Fast forward to today, and I regularly use SQL in my backend development work with PHP. Today, I felt the need to refresh my SQL knowledge a bit, and that's why I've put together three posts aimed at helping beginners grasp the fundamentals of SQL.

Understanding Relational Databases

Let's Begin with the Basics: What Is a Database?

Simply put, a database is like a digital warehouse where you store large amounts of data. When you work on projects that involve data, you need a place to keep that data organized and accessible, and that's where databases come into play.

Exploring Different Types of Databases

When it comes to databases, there are two primary types to consider: relational and non-relational.

Relational Databases: Structured Like Tables

Think of a relational database as a collection of neatly organized tables, somewhat like rows and columns in an Excel spreadsheet. Each table represents a specific type of information, and these tables are interconnected through shared attributes. It's similar to a well-organized library catalog where you can find books by author, title, or genre.

Key Points:

Tables with rows and columns.

Data is neatly structured, much like a library catalog.

You use a structured query language (SQL) to interact with it.

Ideal for handling structured data with complex relationships.

Non-Relational Databases: Flexibility in Containers

Now, imagine a non-relational database as a collection of flexible containers, more like bins or boxes. Each container holds data, but they don't have to adhere to a fixed format. It's like managing a diverse collection of items in various boxes without strict rules. This flexibility is incredibly useful when dealing with unstructured or rapidly changing data, like social media posts or sensor readings.

Key Points:

Data can be stored in diverse formats.

There's no rigid structure; adaptability is the name of the game.

Non-relational databases (often called NoSQL databases) are commonly used.

Ideal for handling unstructured or dynamic data.

Now, Let's Dive into SQL:

SQL is a :

Data Definition language ( what todays post is all about )

Data Manipulation language

Data Query language

Task: Building and Interacting with a Bookstore Database

Setting Up the Database

Our first step in creating a bookstore database is to establish it. You can achieve this with a straightforward SQL command:

CREATE DATABASE bookstoreDB;

SQL Data Definition

As the name suggests, this step is all about defining your tables. By the end of this phase, your database and the tables within it are created and ready for action.

1 - Introducing the 'Books' Table

A bookstore is all about its collection of books, so our 'bookstoreDB' needs a place to store them. We'll call this place the 'books' table. Here's how you create it:

CREATE TABLE books ( -- Don't worry, we'll fill this in soon! );

Now, each book has its own set of unique details, including titles, authors, genres, publication years, and prices. These details will become the columns in our 'books' table, ensuring that every book can be fully described.

Now that we have the plan, let's create our 'books' table with all these attributes:

CREATE TABLE books ( title VARCHAR(40), author VARCHAR(40), genre VARCHAR(40), publishedYear DATE, price INT(10) );

With this structure in place, our bookstore database is ready to house a world of books.

2 - Making Changes to the Table

Sometimes, you might need to modify a table you've created in your database. Whether it's correcting an error during table creation, renaming the table, or adding/removing columns, these changes are made using the 'ALTER TABLE' command.

For instance, if you want to rename your 'books' table:

ALTER TABLE books RENAME TO books_table;

If you want to add a new column:

ALTER TABLE books ADD COLUMN description VARCHAR(100);

Or, if you need to delete a column:

ALTER TABLE books DROP COLUMN title;

3 - Dropping the Table

Finally, if you ever want to remove a table you've created in your database, you can do so using the 'DROP TABLE' command:

DROP TABLE books;

To keep this post concise, our next post will delve into the second step, which involves data manipulation. Once our bookstore database is up and running with its tables, we'll explore how to modify and enrich it with new information and data. Stay tuned ...

Part2